I have a spreadsheet that a local city has created showing vertical benchmark information.
The first row has the column heading information in it. The benchmark information occupies row 2 thru 1899.
Is there a way to "lock" the first row in place, and have that row always visible, and scroll thru the remaining rows?
Thanks in advance.
In the older version I use, you can put your cursor on row 2 and select Window /Freeze to always display row 1 as you scroll.
Another way to just view, but not print that way, use Window / Split and adjust so the upper window shows your desired header rows.
You can put header rows on each printed page by going to File / PageSetup / Sheet and dragging on the row-select boxes to tell it how many rows.
Yes in Excel it is the "Freeze Panes" option on the "Windows" pull down menu. Example if you select cell B2 and execute Freeze Panes the top row and left column of the spreadsheet will remain in view. Open Office is the same process the command is simply "Freeze" and the results are the same.
Thanks guys, that worked like a champ!