so that as you are working down the page you know what is in each column and don't have to keep scrolling back to the top every time you have to add new data.
2006-07-29 02:32:53 · 6 answers · asked by Anonymous in Computers & Internet ➔ Other - Computers
Place the cursor in the row and col where you want the title to remain visable
go to the menus at top of page
Click window
Click "Freeze Window"
To unfreeze, repeat and choose "unfreeze."
2006-07-29 02:39:03 · answer #1 · answered by ed 7 · 0⤊ 0⤋
Click on 'Window' and then 'Freeze panes'. Make sure the cell that you have selected is in the row below/to the right of the cells that you want to freeze. i.e. if you want the top line and the first column to be frozen, select cell B2, if you just want the top line select A2 etc.
2006-07-29 02:40:45 · answer #2 · answered by Anonymous · 0⤊ 0⤋
In the tools menu theres an option called "Freeze Pane". Click that, then select the groups of columns and rows you want to see, and bobs your uncle, as it were.
2006-07-29 02:39:46 · answer #3 · answered by population_man 2 · 0⤊ 0⤋
it doesn t work for print. how to print the freeze row in every page top??
2016-07-29 06:37:41 · answer #4 · answered by ..S O H A G.. 1 · 0⤊ 0⤋
thank you it took me forever to find out it is not compatible with page view
2014-12-18 04:36:07 · answer #5 · answered by CHARLIE 1 · 0⤊ 0⤋
RTFM its called HELP.
2006-07-29 07:46:19 · answer #6 · answered by johncob 5 · 1⤊ 0⤋