OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources]

Greg Perry, M. T. Cozzola, Jennifer Fulton

نسخه متنی -صفحه : 231/ 81

58. Freeze Row and Column Headers

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.

58. Freeze Row and Column Headers.

[View full size image]

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.

Determine What to Freeze

Select the row that

follows the row (or rows) that you want to freeze. For example, if you want the top row with column headings to remain in place no matter how much data falls below it, select the second-from-the-top row by clicking the row number.

Freeze the Row

Select

Freeze from the

Window menu to freeze the row or rows above the top row.

Scroll Down

Scroll down the sheet. The top row remains in place while the data below scrolls upward. No matter where you are in the worksheet, you know the labels that go with the data because the headings are never scrolled off the screen.

TIP

Calc inserts a thick line between the frozen rows (or columns) and the data so you'll know where the break occurs.

Unfreeze the Row

To unfreeze rows or columns you've frozen, select

Freeze from the

Windows menu once again to deselect the option. A check mark next to the

Freeze option indicates that a row or column in this spreadsheet has been frozen. You don't need to select any rows or columns first to unfreeze them.

Freeze Columns

To freeze one or more columns, click the column name of the column that falls to the right of the last column you want to freeze, and then select

Freeze from the

Windows menu. Calc will freeze the column (or columns) so when you scroll to the right, the column titles remain on your screen.

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 .