Microsoft Office Tutorials and References
In Depth Information
Freezing Rows and Columns at the Same Time
Figure 9–36. Can’t stay away: The salesperson names are still there
And you can do the same for the first row, by clicking Freeze Top Row.
NOTE: When you click Freeze Top Row or Freeze First Column, Excel will freeze the first row or
column you can currently see on screen. That is, if you choose Freeze First Column when
column C is the leftmost column on the screen, it will freeze column C, not A. If row 6 is currently
the top row you can see, Freeze First Row will keep row 6 at the top of the screen.
To turn off a freeze view, click Freeze Panes Unfreeze Panes.
Freezing Rows and Columns at the Same Time
There may be other times when you need to freeze some rows and columns
simultaneously. In our case, we might want to always be able to see both the
salesperson names and the week numbers as we scroll in either direction—vertically or
horizontally. Thus, we’d want to freeze the salesperson name column and the row listing
week numbers, something like Figure 9–37.
Figure 9–37. The first two salesperson names and the first five week numbers have disappeared, because we’ve
scrolled both down and across the worksheet after having clicked Freeze Panes. Note the row header numbers
and column header gaps (4 through 7 and A through G).
To achieve this effect, you need to click the Freeze Panes option once you decide exactly
which rows and columns you want to freeze. The rule is this: to freeze a column you
click in the column immediately to the right of the one you want to freeze, and to freeze
a row you click in the row immediately beneath the one you want to freeze. Thus, in this
case you’d click in the cell shown in Figure 9–38.
Search JabSto ::

Custom Search