To freeze the top row, open your Excel spreadsheet. Select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Top Row option in the popup menu. Now when you scroll down, you should still continue to see the column headings. How to freeze rows in Excel. Freezing rows in Excel is a few clicks thing. You just click View tab Freeze Panes and choose one of the following options, depending on how many rows you wish to lock: Freeze Top Row - to lock the first row. Freeze Panes - to lock several rows. The detailed guidelines follow below. How to freeze top row in Excel.

• How To Freeze Multiple Columns In Excel
• Freeze Multiple Panes Excel 2013
• How To Freeze First 2 Rows
• Freeze Row Excel Mac 2011

1. Lock specific rows or columns in place by freezing panes, so you can scroll through an Excel spreadsheet and still see the top row or left column. You can freeze just the top row and first column or multiple rows and columns.
2. I just signed up for the latest MS Office 365 Business Edition for my MAC through my ISP, Go Daddy. I assume it's 2016. I am unable to freeze several rows because the 'View' drop down menu only allows you 3 choices: 1. Unfreeze Panes. Freeze Top Row. Freeze First Column. I have tried all kinds of work-arounds with no luck.

If you are usually working with large worksheets, it is really important that you become familiar with the steps to Freeze Rows and Columns in Excel.

Freeze Rows and Columns in Excel

How To Freeze Multiple Columns In Excel

As you must have noticed, the Column headings go out of view and are no longer visible when you scroll down in an Excel worksheet.

Without the Column headings being visible, it becomes really difficult to enter new data in to proper Columns or to review and compare the existing data.

A simple solution to this problem is to simply Freeze the entire Row containing Columns headings. Once this is done, the Column headings will become frozen and will always be visible when you scroll down.

Similarly, it is possible to Freeze Columns and also Freeze both Rows and Columns at the same time in Excel.

Note: Freezing Rows or Columns has no effect on printing, it only affects the way that worksheet appears on the screen.

1. Freeze Rows in Excel

In case you want to make the Column Headings stationary and always visible when you scroll down, you can follow the steps below to Freeze the Row containing Column headings.

1.1. Select the Row (or the first cell in the row) located right below the Row that contains the Column headings.

1.2. Next, click on the View tab > click on Freeze Panes and then click on Freeze Panes option in the drop-down menu.

This will freeze the Row containing Column Headings and this particular Row will always stay visible when you scroll down the worksheet.

2. Freeze Columns in Excel

If the worksheet spans multiple columns you may want to make certain column/columns always visible when you scroll to the side on the worksheet (Right or Left).

2.1. Select any Cell located immediately to the right of the Column that you want to freeze. In our case, we have selected Cell B2, in order to Freeze the Column A containing “Items”.

2.2. Next, click on the View tab > click on Freeze Panes and then click on Freeze Panes in the drop-down menu.

This will Freeze Column A and this particular Column will always stay visible when you scroll sideways on the worksheet

3. Freeze Both Rows and Columns in Excel

In certain cases, you may want to Freeze the Row containing Column Headings and also Freeze the first column or few selected columns in the worksheet.

To Freeze both rows and columns, select the Cell located to the right of the Column that you want to Freeze and below the Row that you want to Freeze.

In our case, we have selected Cell B2 in order to Freeze the second Row containing column headings and also Freeze Column A containing “Items”.

After selecting the right-cell, click on the View tab > Freeze Panes > Freeze Panes option in the drop-down menu.

Now the rows above the selected Cell will remain frozen when you scroll down and also the Columns to the left of the selected Cell will also remain frozen when you scroll to the side.

Unfreeze Rows and Columns Panes in Excel

At any time, you can Unfreeze Rows and Columns in Excel by clicking on the View Tab > Freeze Panes > Unfreeze Panes option in the drop-down menu.

The Frozen Rows or Columns will become free and they will no longer remain frozen or stationary when you scrolled up or down.

Freeze Panes Not Available in Excel

You may come across an issue where the Freeze Panes option is not available, appears grayed out or it does not work. This issue is usually related to the worksheet being in “Page Layout” view.

To fix this issue, click on the View Tab and then click on Normal or Page Break Preview.

Freeze Panes option can also get disabled due to the workbook being in protected mode.

However, this issue has been fixed in newer versions of Microsoft Excel and you will only face this problem while working on files created using an older versions of Excel (older than Excel 2013).

How to lock or unlock cells in Excel?

In Microsoft Excel 2007 or later versions like Excel 2019, we want to protect few cells only in a worksheet, then how to do it?

Solution: There are two situations to lock cells in excel depending on these reasons.

1. If You Want the Majority of Cells Locked
2. If You Want the Majority of Cells Unlocked

They are explained as follows:-

A. If You Want the Majority of Cells Locked:

1. Select the cells that you want to remain unprotected. To select nonadjacent (non-contiguous) cells, hold down CTRL and click the cells that are to remain unprotected.

(Image 1)

2. On Excel 2007 or later, make right click on any selected cell and select FORMAT-CELL, and then click ProtectionClick to clear the Locked check box and click OK.
   [xyz-ihs snippet=”Excel-Curriculum”]

(Image 2)

3. In Excel 2007 or later, click the Review tab, and click Protect Type a password if you want one, and then click OK.

(Image 3)

B. If You Want the Majority of Cells Unlocked:

To leave the majority of the cells on the worksheet unlocked, follow these steps:

1. Select the entire worksheet by clicking the Select All button (the gray rectangle in the upper-left corner of the worksheet where the row 1 and column A headings meet), or by pressing CTRL+A.

(Image 4)

2. On Excel 2007 or later, make right click on any selected cell and select FORMAT CELL, and then click Protection.Click to clear the Locked check box and click OK.

(Image 5)

3. Select the cells that you want to protect. To select nonadjacent (non-contiguous) cells, hold down CTRL and click the cells that you want to protect.

Return to the Format Cells dialog box, and then click the Protection tab. Click to select the Locked check box, and then click OK.
[xyz-ihs snippet=”Excel-online-Course”]

Freeze Multiple Panes Excel 2013

(Image 6)

4. In Excel 2007 or later, click the Review tab, and click Protect Sheet. Type a password, if you want one, and then click OK.

(Image 7)

If you find this information helpful then check out our latest Excel Dashboard Course to learn more about excel & dashboard. In this training, you get lifetime access videos with the latest updates and more.

To get better insights on Excel, check out these sections:
Advanced Excel Tutorials & Free online Excel courses

How To Freeze First 2 Rows

Freeze Row Excel Mac 2011