East Bay Solutions

How to Freeze Columns and Rows in Excel



Problem or Question:

How can I keep certain header columns and rows in place while viewing a large worksheet?



Solution or Answer:

Step 1. Go to the View tab and click on Freeze Panes.

freeze pane.png

Step 2. Select the best option to suit your needs.


For additional assistance view this video at: http://www.youtube.com/watch?v=4UXIk6GyFno

Submitted by: jennifer.toor@csueastbay.edu

Article Details

Last Updated
29th April 2013 03:41:22 pm

Submitted By
Jennifer Toor

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

User Opinions (0 votes)

No users have voted.

How would you rate this answer?

Thank you for rating this answer.

Related Articles

No related articles were found.


No attachments were found.
  • Print This Page
  • Bookmark and Share