Question

How can you freeze columns a and b and rows 1 through 2 in the worksheet?

Answer 1

To freeze columns A and B and rows 1 through 2 in a spreadsheet, select cell C3 and then use the Freeze Panes feature under the View tab in the Window group.

Step-by-step explanation:

To freeze columns A and B and rows 1 through 2 in a worksheet, such as in Microsoft Excel, you need to use the Freeze Panes feature. Here is a step-by-step guide:

After these steps, columns A and B will be frozen on the screen, and so will the first two rows. As you scroll through your spreadsheet, these rows and columns will remain in view.