I have seen spreadsheets created in Microsoft Excel where some rows and/or columns are "floating". That is, no matter where you scroll, you can always see those rows. This is especially handy if the first row, for example, is a set of labels that explains the other rows. I have tried to figure out how to do this using the help that comes with Microsoft Office, but couldn't search for it because I don't know what it's called. Can you help?
2006-08-29 08:52:12 · 4 answers · asked by drshorty 7 in Computers & Internet ➔ Software
To keep titles in sight, divide or split the worksheet by "freezing" the titles in their own pane. The title pane is then locked in place as you scroll through the rest of the worksheet.
You freeze panes by making a selection in the worksheet, which can be done by selecting Freeze Panes on the Window menu.
"But there's a secret to success: To freeze titles, do not select the titles themselves. To freeze:
Column titles--Select the first row below the titles.
Row titles--Select the first column to the right (for example, to keep supplier names in sight as you scroll across the worksheet).
Both column and row titles--Click the cell that is both just below the column titles and just to the right of the row titles.
If you don't get it right the first time, it's easy to unfreeze and try again. Just click Unfreeze Panes on the Window menu.
Tip You can freeze panes anywhere, not just below the first row or to the right of the first column. For example, if you wanted the information in the first three rows to stay in sight as you scroll, you would select the fourth row and freeze."
2006-08-29 09:02:31 · answer #1 · answered by Leah M 3 · 1⤊ 0⤋
Leah is right about freezing the column & row headers. If you want row 1 & column A to be freezed, you just click on B2.
To be more clear, go to Windows (next to Help) on the menu bar & click (Un)Freeze Panes.
As for Gwen's answer... that is only if you were to print out the data, and it is more than a page long, you can use that option & your row and/or column headers will appear on the paper with the data.
2006-08-29 14:30:30 · answer #2 · answered by m8nhia 3 · 1⤊ 0⤋
To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll, then click on "Freeze Panes".
2016-03-27 00:23:54 · answer #3 · answered by ? 4 · 0⤊ 0⤋
File, page setup, sheet, rows/columns to repeat at top.
2006-08-29 08:58:39 · answer #4 · answered by Anonymous · 1⤊ 0⤋