1. Home
  2. MS Office

Excel 2010: Freeze Rows And Columns

Excel 2010 comes with Freeze Row and Freeze Column features, which make it easy to match and read details of huge data sets. If you are dealing with huge datasheet containing student records, then you may want to freeze top row or first column to easily understand data while scrolling up / across the datasheet. In this post, we will take a look at how to freeze top row and first column.

scroll down the sheet1

In order to make the first column and row label apparent while scrolling, you need to follow very simple steps.

First off, head over to View tab, click Freeze Top Row to make the row labels appear, when you are scrolling.

view 1

As shown in the screenshot below, top row labels are visible even at the bottom of the page.

row stuck

Now if you want to freeze first column, Click Freeze First Column, to do the same with the columns.

freeze columns

Leave a comment