Excel Help Tips Part Four: Freezing Panes

July 18th, 2010 by admin

Welcome to another session of our Microsoft Excel Tutorial.  After talking about rows and columns last week, we now move on to freezing panes.  Before we begin, always remember everything we discussed can found in Excel’s help section.  All your questions can be answered there. Take the time to read it for reference.

This week, we will answer the question: “how do i freeze panes in excel?”

To begin, choose the row that you want to freeze by clicking the corresponding row heading of your choice.  Row headings are the number found on the leftmost side of the sheet.  You will know you are successful because the whole selected row will be highlighted after clicking the row heading.

After selecting the rows, now select the columns you want to freeze by clicking the corresponding column heading of your choice.  Column headings are the number found on the topmost part of the sheet.  You will know you are successful because the whole selected column will be highlighted after clicking the column heading.

Once you have the rows selected, go to the View tab, look for the Window group, look for the Freeze Pane command and you are done.  

That is all the time and space we have for now.  Tune in next week and we will answer the question: “how do i fix cells in excel?”

Copies of our past lessons are now available in our archives for download.  Just log-in with your username and password and download the lesson of your choice.  This done free of charge but do not forget to leave us a feedback by signing the guestbook.

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Posted in Reference and Education | | Comments Off

Comments are closed.

Sorry, the comment form is closed at this time.