Freeze First Column and Row in Excel
Excel's a great tool to work with data, especially lots of data. Having frozen rows and columns helps a lot while analyzing large datasets. Excel provides a very easy way to freeze rows and columns. Here's how -
Freeze both First Row and First Column
To freeze both the first row and first column together, select the cell B2 and click Windows >> Freeze Panes.
The first row and column will remain static depending on whether you scroll vertically or horizontally.Freeze First Row Only
To Freeze the first row, select the row below it i.e the second row.
Now in the menu, go to Windows >> Freeze Panes.This completely freezes the first row. The row will always be still while scrolling down.
Freeze First Column Only
Select the second column i.e the B column. After that, go to Windows >> Freeze Panes.
More Excel Tips:
Convert Rows to Columns and Columns to Rows
Transfer Excel Spreadsheet to Access Table
Export Access Table to Excel
32 Comments:
Comment by 
Santa Cruz, California on August 31, 2010 at 12:06 AM
Santa Cruz, California on August 31, 2010 at 12:06 AM
thank you! i've been dying to figure this out. the key tip was "click B2". also, readers should know that you must Unfreeze panes before the Freeze panes option appears in Excel 2010.
This does not work in Excel 2007. When you click Freeze Panes...a drop down shows up and asks you to select between three options 1)Unfreeze Panes 2)Freeze the Top Row and 3)Freeze the First Column. Does anyone know how to Freeze both the Top Row and the First Column in Excel 2007?
Okay...it appears enough clicks on the Split Panes button will lock both columns and rows starting from the cell you have selected at the time you click the Split Panes button.
this does work in 2007. when you click "b2", the top option changes from 'unfreeze all panes' to 'freeze all panes' and allows you to freeze both the top and leftmost row/column
Thanks a lot
You just saved me HOURS of work. God bless.
Thank you!!
In Word 2010 you have to go to the View tab to find the freeze panes option.
In Word 2010 you have to go to the View tab to find the freeze panes option.
Just what I was looking for. Thanks!
jeez, thanks so much but this is why I dislike excel - this is totally obvious, that you'd need to do this, yet totally undocumented and unintuitive!!
B2- This is the sweetest thing my whole entire excel life! Thank you much much! =)
this works in 2007 a little different. select the cell that will be the cross-point of the column and row you want to freeze. for example, select cell C3 if you ant to freeze from row 2 up and column A and B.
Wow...this just helped me soo much. Thanks.
Thanks, saved me a long time searching!
THANKS BUDDY GOOD JOB........!
FINALLY! The only tips that understood what i was searching for! thanks a lot!
Gave in short very clear and fully meaningful. I was not getting clear idea. In Lotus it is made the row and column first title kept steady so other data can be browse through.
Keep continue, Regards,
Keep continue, Regards,
Thank you for the helpful comments
Thank you for the B2 tip. Excel help makes it sounds like you can only freeze the top row OR first column, not both.
Many thanks!!!
Just a heads up that it doesn't necessarily have to be B2. Just pick the cell below and to the right of where your column and row intersect and hit the Freeze Pane button.
I wanted to show the top two rows and the first three columns. Put my cursor in C4, hit "Freeze Panes" and bam! Works like a charm.
I wanted to show the top two rows and the first three columns. Put my cursor in C4, hit "Freeze Panes" and bam! Works like a charm.
Thank you very much
no doubt, this was killing me. THANK YOU FOR POSTING THIS:)
two clicks and problem solved, thank you!
two clicks and problem solved, thank you!
Fantastic, thank you!!!!!
perfect - a useful and simple article which has answered my question... how rare! thankyou.
you just saved my life thanks!!!!!
thanks for the useful tip! i had been figuring how to freeze both first row & column for months!
Thank you this was driving me nuts!!! Finally an answer and it was so simple!
haha i've been trying to find the solution for a while now. thx for the info!
Excellent....Thanks a lot for that...this made my day....I was doing lot of R&D myself to figure out this with no luck.
Thank you. That click B2 was THE tip :D
You rock!! I think I love you.
is there a way to freeze worksheets as well? I have 40 worksheets on one document and I want the first work sheet to stay where it is when I scroll through them if that makes sense. Not sure if this is possible?
