• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Controlling Rows, Columns, an... > Locking Headings in Place with Freez...

Locking Headings in Place with Freeze Panes

In most worksheets, you type a label at the top of each column or to the left of each row to indicate the type of data in each cell. When you’re typing data entries in a column or row, these labels help you figure out what you need to type in each cell. Unfortunately, as you scroll down or to the right, your column and row headings scroll outside the viewing area. To keep them onscreen, you can freeze the columns or rows by following these steps:

1.
Click the cell that’s directly below the row(s) you want to freeze and to the right of the column(s) you want to freeze, as shown in Figure 5.6.

Figure 5.6. Choose the cell below the rows and to the right of the columns you want to freeze.


2.
Open the Window menu and choose Freeze Panes. A dark line appears below the frozen rows and to the right of the frozen columns. The frozen rows and columns remain onscreen at all times.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint