98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Cells
Cells
Resolved · High Priority · Version 2007
Abdur has attended:
Excel Introduction course
Excel Intermediate course
Word Intermediate course
Cells
how to freeze cells?
RE: cells
Hello Abdur
Thank you for your question and welcome to the forum.
I am assuming you are referring to using freeze panes?
To use the freeze panes in Excel 2007, go to the View tab, and click the Freeze Panes button within the Windows group of buttons.
You have three options:
Freeze top row (freezes first row only)
Freeze first column (freezes left most column only)
If you have selected a cell at the intersection of the rows and columns you would like to freeze, then select Freeze Panes to freeze both rows and columns.
I hope this helps.
Kind regards
Amanda
Tue 26 May 2009: Automatically marked as resolved.
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:Currency formatCtrl+Shift+$ applies the Currency format, with two decimal places |