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
