« Random numbers: Normal Distribution I | Main | Averaging non-zero values »
September 23, 2004
Freezing row & column headers
For large spreadsheets that do not fit completely in the window, it is useful to be able to freeze the row and/or column headers to better view the data.
Consider the example below, where we have 12 columns and a large number of rows. By selecting the cell below and to the right of A1 and selecting Window - Freeze , you will now be able to scroll down or to the right while keeping the top row and left column frozen in place.
Note that once you close a sheet, the above setting disappears and you will need to refreeze your window when you reopen the sheet.
Note that once you close a sheet, the above setting disappears and you will need to refreeze your window when you reopen the sheet.
Posted by Dave at September 23, 2004 12:26 AM
Comments
This setting is not lost by closing in 1.1.4
Posted by: Anonymous at January 24, 2005 08:47 PM
Someone should add the ability to freeze in both directions. So you can scroll between 2 different columns or rows that you want to see continuously. Of course one can just move the row or column on the right to the left so they always show but it's a good idea nonetheless.
Posted by: Ross at April 25, 2005 06:39 PM