Page 220 - Excel 2013 All-in-One For Dummies

202 A Spreadsheet with a View
To use the Freeze Panes feature in this manner, you first position the cell pointer in the cell that’s located to the immediate left of the column or col- umns that you want to freeze and immediately beneath the row or rows that you want to freeze before you click the Freeze Panes button on the Ribbon’s View tab followed by Freeze Panes on the button’s drop-down menu. (You can also do this by pressing Alt+WF and pressing the Enter key to choose the Freeze Pane option from the drop-down menu.)
To freeze the top row of the worksheet (assuming that it contains column headings) from anywhere in the worksheet (it doesn’t matter where the
cell cursor is), choose the Freeze Top Row option from the Freeze Panes button’s drop-down menu. If you want to freeze the first column (assuming that it contains row headings) from anywhere in the worksheet, choose the Freeze First Column option from the Freeze Panes button’s drop-down menu instead.
Figures 3-10 and 3-11 illustrate how this works. Figure 3-10 shows the Income Analysis spreadsheet after freezing column A and rows 1 and 2. To do this,
I positioned the cell cursor in cell B3 before choosing Freeze Panes from
the Freeze Panes button’s drop-down menu. Notice the thin black line that runs down column A and across row 2, marking which column and rows of the worksheet are frozen on the display and that will now remain in view — regardless of how far you scroll to the right to new columns or scroll down to new rows.
Figure 3-10:
The income worksheet after freezing column A and rows 1:2 in the worksheet display.