Question

To freeze the top 3 rows, the rows the cursor should be placed at the following cell location?

Answer 1

To freeze the top 3 rows in Excel, place the cursor in cell A4, then use the View tab to select Freeze Panes. This locks the rows above cell A4 as you scroll through your worksheet.

Step-by-step explanation:

To freeze the top 3 rows in Excel, you need to place your cursor in cell A4. This is because freezing panes in Excel always freezes the rows and columns above and to the left of the active cell, respectively. So, by selecting A4, you are effectively telling Excel to freeze the first three rows of your worksheet. Here's how you do it step-by-step:

• Select cell A4.
• Go to the View tab on the Excel ribbon.
• Click on the Freeze Panes button.
• Choose Freeze Panes from the drop-down menu.

Once complete, rows 1 to 3 will remain stationary as you scroll down the worksheet, allowing you to view your header information easily.