OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources] نسخه متنی

58. Freeze Row and Column Headers

42 Enter Simple Data into a Spreadsheet

61 Center a Heading over Multiple Columns

Often, you'll enter lots of data into a spreadsheetperhaps daily sales figures, for example. As you add more and more data, your sheets will grow to be quite large. Perhaps at the end of each month, quarter, or fiscal year, you close your books so that you can consolidate the data and begin anew the next time period.

Until you restart the data entry for the next time period, the data can consume many rows and columns as time goes by. Eventually your data will take more than one screen, which can lead to a problem: If you initially put labels across the top of the sheet to label the columns and put labels down the left column to label the rows of data, when you page down or move too far to the right, the column and row headings will scroll off the screen. In order to keep track of what the purpose of your sheet's values are, you can freeze the scrolling of row and column headers so that those headers remain on the screen while the rest of the data scrolls under or to the right of them.

TIP

You can freeze as many contiguous rows or columns as you need. For example, your sheet title and column headings might span three rows. All rows below those three frozen rows will scroll up and down, but the three remain in place so you'll know what the columns represent.

TIP

If you want to freeze both row and column headings, click to select the cell that intersects the row and column following the headings you want to freeze before selecting

Windows, Freeze .