East Bay Solutions

How to Freeze Columns and Rows in Excel

KB-821

Solution

Problem or Question:

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


Environment:

Excel

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.

Attachments

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