Tech Xpress

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.

Freeze First Row and First Column in ExcelThe 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.

Freeze First Row in ExcelNow 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.

Freeze First Column in Excel
More Excel Tips:
Convert Rows to Columns and Columns to Rows
Transfer Excel Spreadsheet to Access Table
Export Access Table to Excel

Home
posted by Vijeesh Ravindran, Tuesday, December 02, 2008


34 Comments:

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.
Comment by Anonymous Anonymous on January 5, 2011 at 10:02 PM  
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?
Comment by Anonymous Anonymous on January 5, 2011 at 10:08 PM  
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.
Comment by Anonymous Anonymous on February 1, 2011 at 11:33 PM  
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.
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!!
Comment by Anonymous Anonymous on May 25, 2011 at 8:44 AM  
B2- This is the sweetest thing my whole entire excel life! Thank you much much! =)
Comment by Anonymous Anonymous on June 24, 2011 at 1:36 AM  
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.
Comment by Anonymous Anonymous on July 18, 2011 at 9:05 PM  
Wow...this just helped me soo much. Thanks.
Comment by Anonymous Anonymous on July 28, 2011 at 9:31 PM  
Thanks, saved me a long time searching!
THANKS BUDDY GOOD JOB........!
Comment by Anonymous Anonymous on September 14, 2011 at 9:07 AM  
FINALLY! The only tips that understood what i was searching for! thanks a lot!
Comment by Anonymous Anonymous on September 19, 2011 at 10:33 AM  
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,
Comment by Anonymous Anonymous on September 21, 2011 at 12:05 AM  
Thank you for the helpful comments
Comment by Anonymous Anonymous on September 30, 2011 at 7:20 PM  
Thank you for the B2 tip. Excel help makes it sounds like you can only freeze the top row OR first column, not both.
Comment by Anonymous Anonymous on October 4, 2011 at 8:05 PM  
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.
Comment by Anonymous Anonymous on December 16, 2011 at 9:15 AM  
Thank you very much
Comment by Anonymous Anonymous on January 7, 2012 at 2:33 PM  
no doubt, this was killing me. THANK YOU FOR POSTING THIS:)

two clicks and problem solved, thank you!
Comment by Anonymous Anonymous on January 11, 2012 at 2:39 AM  
Fantastic, thank you!!!!!
Comment by Anonymous Anonymous on January 11, 2012 at 8:07 PM  
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!
Comment by Anonymous Anonymous on March 7, 2012 at 8:29 AM  
Thank you this was driving me nuts!!! Finally an answer and it was so simple!
Comment by Anonymous Anonymous on March 13, 2012 at 7:23 AM  
haha i've been trying to find the solution for a while now. thx for the info!
Comment by Anonymous Anonymous on March 28, 2012 at 11:11 PM  
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.
Comment by Anonymous Anonymous on April 26, 2012 at 11:05 PM  
Thank you. That click B2 was THE tip :D
Comment by Anonymous Anonymous on May 15, 2012 at 2:54 AM  
You rock!! I think I love you.
Comment by Anonymous Anonymous on December 5, 2012 at 9:06 PM  
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?
Comment by Anonymous Anonymous on September 10, 2013 at 10:48 PM  
Thank YOU!
LOL! I didn't know its such easy! Last night I stuck in it about an hour :)