Freezing Rows While You Scroll


As just noted, you can use your keyboard's Page Up and Page Down keys to scroll through long spreadsheets. You can also use your mouse to click the onscreen scrollbars to achieve the same movement.

The only problem with scrolling in this manner is that the top rows of the spreadsheettypically used as column headersscroll off the screen when you move down a spreadsheet. Wouldn't it be nice if you could "freeze" your spreadsheet's header row so that it's always visible, even when you're scrolling down?

You're in luck; Google Spreadsheets provides just such a header row freeze function. As you can see in Figure 9, when you freeze the top row (or rows) of a spreadsheet, it stays at the top of the screen, no matter how far down you scroll down. Here's how you do it:

1.

From within your spreadsheet, click the Sort tab.

2.

Click the Freeze button.

3.

Select how many rows you want to freeze as the header row.

Figure 9. A spreadsheet with a frozen header row.


Now, when you scroll through your spreadsheet, the selected rows stay frozen in place at the top of the spreadsheet.




Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net