Excel 2010 Masterclass – Freezing Rows and Columns

Excel 2010 Graphic
Freezing rows and columns is a built-in function that Microsoft Excel provides to help when working with large spreadsheets.

If you have worked with large spreadsheets before, then you will know some of the problems associated with viewing parts of the data area. If you haven’t, then download our accompanying spreadsheet and see what we mean.

You can download a sample staff details spreadsheet >>here<<, in Excel 2010 format.

Problem

If you have downloaded the Staff Details spreadsheet above, you will notice that when you scroll to the right you lose sight of the staff member names.

So, for example, if you want to know the date that Diana Prince started with the company, you find her name in the first column (column A) and scroll to the right to find the date she started (column K). Are you at the right date? It is hard to confirm if you can no longer see the persons name.

Subsequently, we now want to find out the date of birth for Sally Nice. Again, we find her name in the first column and then scroll to the right to the date of birth column. Which one is it? We can no longer see the column headings.

So that’s the problem … let’s sort it.

Solutions

Excel 2010 Graphic

     1. Freezing the top row

Go to the View ribbon bar and click on the Freeze Panes button that you will find in the Window section (shown right).

Select Freeze Top Row.

At first glance it looks as if nothing has happened but if you scroll down you will notice that the titles at the top are now always in view.

     2. Freezing the first column

Go back to the View ribbon bar and click on the Freeze Panes button that you found in the Window section.

Select Freeze First Column.

This unfreezes the top row from before and freezes the first column instead. Try scrolling from left to right and notice that, now, the staff members name is always on show.

     3. Freezing columns and rows together

Go back to the View ribbon bar and click on the Freeze Panes button that you found in the Window section.

Select Unfreeze Panes.

Select cell B2.

Go back to the View ribbon bar and click on the Freeze Panes button once more.

Select Freeze Panes.

This has frozen the top row and the first column at the same time.

Problem solved, methinks.

That is the end of our Freezing Rows and Columns masterclass.

Please use the comments box below to let us know what you think of our blogs.

Bob Thomson is an IT professional with over 20 years experience in the industry having worked as a Consultant, Director, Manager and Trainer. He has vast experience using Microsoft software packages as an individual and in businesses situations.

Bob Thomson
Owner / Managing Director
Real Options