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.



Related:
  • Looking for values and formulas in Excel
    Dealing with numbers, formulas and equations is a difficult task especially when we are trying to create something just by ourselves.  Personally, I lways measured in inches and weight in pounds.  So when putting those entries in paper with those standards that need equivalents in the...
  • I Am Looking for A Tutorial In Excel
    I am looking for Certified Microsoft Excel Instructors for a possible one-on-one session with me.  Prospective applicants must strictly be female, since I am also a female. She must have five years experience in the said field.  A pleasing personality and patience is required as she...
  • Microsoft to Generate More Jobs through Online Service
    Microsoft, manufacturer of Microsoft Office, Microsoft Visio and Microsoft Project is now thinking of giving back to the community.   Having seen how the recession has hit the United States causing people to lose everything they own in a flash, Bill Gates decided that Microsoft can do more for...

    • Posted in Reference and Education