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 » excel training - Freezing a column
excel training - Freezing a column
Resolved · Low Priority · Version Standard
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
RE: Freezing a column
you cant freeze a column, on the screen and all the columns that are with it.
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
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
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:Generate randon numbersSome types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it: |