Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Freezing a column
|
|
|
The UK's most regular 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 training - Freezing a column
Resolved · Low Priority · Version Standard
Reply Fri 24 Aug 2007, 11:37Delegate Krystle said...
Krystle has attended:
Excel Advanced course
Word Advanced course
Freezing a column
Hi there
I was wondering how i would freeze a column in Excel. I often have to do this for reports, you know when one column can't move but the others can move behind it?
Many thanks
Krystle
For upcoming training course dates see: Pricing & availability
RE: Freezing a column
you cant freeze a column, on the screen and all the columns that are with it.
Reply Tue 28 Aug 2007, 14:18Delegate Krystle said...
RE: Freezing a column
Hi David
Thank you for your response although it wasn't that explanatory! Are you saying that i cannot freeze a column because i know someone that has done if for me, i just need to know how to do it myself. Should i send you an example of a spreadsheet i have safed where a column has been frozen?
Many thanks
Krystle
Reply Tue 28 Aug 2007, 14:47Delegate Krystle said...
RE: Freezing a column
Hello again
I managed to speak to my colleage in New York that normally does this for me.
To freeze a column you select the column after which you want to freeze. Eg: if you want to freeze column B then you will select column C. Then go to Windows > Freeze panes.
Krystle
|