Dee has attended:
Excel Advanced course
Excel Intermediate course
Spread sheets
Is there a way to freeze the top lines of a large spreadsheet, more than a single printing pane?
RE: spread sheets
Hello Dee
Thank you for your question
If you highlight the cell below the row and to the right of the collumn you want to freeze. Then go to the window menu and select freeze Panes or Split columns
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
RE: spread sheets
I understand about freezing columns on the right side, but I have a very large spreadsheet with about 20 columns and I want to freeze the top row (column headings) so that I can always make sure I am entering the correct numbers under each column. If I could have the data scroll under the column headings, that would be fantastic. It works for a single pane, but I can't get it to work all the way across all my columns.
Any help?
Cheers,
Dee
RE: spread sheets
Hello
Open the spreadsheet and look just above the right hand scroll bar. There is a little box with an arrow. Just above that is a small rectangle. Click on it and hold. Drag it to just under the first row of the spreadsheet and release. This should freeze the whole first row. You will need to click out of the first row and onto the rest of the sheet before scrolling down the rest of the data as this first row can still be scrolled. I have attached a screen shot to show you where I mean.
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
first column freeze.bmp
