How-To Geek
Make Row Labels In Excel 2007 Freeze For Easier Reading
If you have large and long workbooks or Excel spreadsheets, being able to see the column or row labels is extremely important. Here is a quick way to freeze the labels in place for fast and easy viewing of your data.
Click on View on the Ribbon and select Freeze Panes.
Now click Freeze Top Row. If you want to Freeze other rows as well just highlight them before choosing Freeze Panes.
That’s it! Now as you can see by the example, you will be able to scroll throughout the document while keeping the column or rows in place.
Got Feedback? Join the discussion at discuss.howtogeek.com
Comments (18)
Programmer by day, geek by night, The Geek, also known as Lowell Heddings, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on Google+ if you'd like.
- Published 06/26/07
this was exatly what I was looking for. thank you.
Thanks sooo much
Thank you very much, It is very helpful!!
thank you very very much…
much appreciated your help..
Thank u.It is really useful
this was exatly what I was looking for. thank you very very much.
thxxxxxxxxxxxxxx
this facality is very good…
How would I freeze Row 1 AND Column A at the same time, so if I scrolled right I kept the names and if I scrolled down I kept the headings?
Thank you it is very useful, keep updating with latest information
THANK YOU……… VERY MUCH
Great Man! this is what i am looking 4 !!
This was exactly what I needed. Great screenshots.
what if I want to freeze the second or third row? or more that one row? I have the title of the page in the first row and the info I want frozen is in the second row.
thank you very very very much!!!!!
This is exactly what i was searching for.. Thanks
It was the very helpfull. The screen shot given is informative. Thanks.
thanks who drop this
Thaks it’s help full me