98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Spread sheets
Spread sheets
Resolved · Low Priority · Version 2003
Wed 18 Mar 2009, 15:29Delegate Dee said...
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?
Tue 24 Mar 2009, 10:28Trainer Cress said...
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
Tue 24 Mar 2009, 13:10Delegate Dee said...
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
Tue 24 Mar 2009, 14:05Trainer Cress said...
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
Attached files...
first column freeze.bmp
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Colouring cells containing formulasCells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells. |
