How to Freeze a Row in Microsoft Excel

Member

By Mike
User-Submitted Article

Article Rating:

(0 Ratings)

Freeze a Row in Microsoft Excel

Freezing a row in Microsoft Excel means to lock the column headers for a row. Let me explain. Lets say you have a spreadsheet. And in that spreadsheet in row 1 are all the headers for the columns which describe the data for each column. So in cell A1 you could have dates, B1, product names, C1, prices and so forth. If you have a spreadsheet with enough data that you need to scroll in order to see, if you do not freeze the column headers they will scroll right along with the rest of the data. Therefore we need to freeze the column headers so the data scrolls but not what describes what that data is.

In this tutorial I will show you how to freeze the first row in Microsoft Excel, which contains column headers.

Difficulty: Easy

Instructions

Things You'll Need:

Microsoft Excel

Step 1

Launch Microsoft Excel and create a new blank worksheet.
Step 2

In cell A1 type in "DATE", in cell B1 type in "DESCRIPTION", in cell C1 type in "PRICE" and in cell D1 type in QUANTITY. Row 1 will act as our column headers. Your worksheet should look like the one in the picture associated with this step.
Step 3

Click on cell A2 to put the focus box in there.
Step 4

Click on "Window" from the menu options located at the top of the screen as circled in red in the picture associated with this step.
Step 5

On the submenu that appears select "Freeze Panes" as circled in red in the picture associated with this step.
Step 6

You will now notice that a darker line separates row 1 from the rest of the rows. If you were to scroll down you will see that row 1 is frozen and will not scroll.