98.8% 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 » Freezing panes
Freezing panes
Resolved · Low Priority · Version 2007
Fri 3 Jul 2009, 16:23Delegate Marya said...
Marya has attended:
Excel Intermediate course
Freezing panes
how do you freeze panes both vertical and horizontal together?
Mon 6 Jul 2009, 13:53
Edited on Mon 6 Jul 2009, 13:54Trainer Carlos said...
RE: freezing panes
Hi Marya
To freeze panes both Horizontal and Vertical together you first decide which columns and rows are to be frozen (Eg Column A and rows 1-5).
Then, in the above case, you select cell B6 because the system freezes above and to the left of the selected cell
Hope this helps
Carlos
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:Wrapping Text in a Cell in an Excel 2010 WorkbookWhen you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER. |
