How do I freeze panes in Excel for Mac?

How to Freeze Column and Row Headings in Excel

Freeze panes to keep track of where you are in a spreadsheet

Nội dung chính Show

How to Freeze Column and Row Headings in Excel
Freeze panes to keep track of where you are in a spreadsheet
What to Know
Freeze the Top Row
Freeze the First Column
Freeze Both Columns and Rows
Unfreeze Columns and Rows
Splitting Panes in Excel for Mac
Try it yourself
What is the shortcut to freeze panes in Excel for Mac?
Why can't I freeze panes in Excel?

What to Know

Freeze top row: View > Freeze Panes (Windows only) > Freeze Top Row.
Freeze first column: View > Freeze Panes (Windows only) > Freeze First Column.
Columns and rows: Select the rows and columns, then View > Freeze Panes (Windows only) > Freeze Panes.

This article describes how to freeze rows and columns in Excel so that they're always visible, no matter where you scroll. Instructions apply to Excel 2019, 2016, 2013, 2010, 2007; Excel Online; and Excel for Mac 2016 and later.

Freeze the Top Row

Follow these three steps to get your worksheet's header to stay in place.

Select View on the ribbon.
Select Freeze Panes. If you're using Excel for Mac, skip this step.
Select Freeze Top Row.
A border appears just below Row 1 to indicate that the area above the line has been frozen. The data in row 1 remains visible as you scroll because the entire row is pinned to the top.

Freeze the First Column

To freeze the first column of a worksheet:

Select View.
Select Freeze Panes. If you're using Excel for Mac, skip this step.
Select Freeze First Column.
The entire column A area is frozen, indicated by the black border between columns A and B. Enter some data into column A and scroll to the right; you'll see the data move with you.

Freeze Both Columns and Rows

To keep specified rows and columns visible:

Select a cell below the row that you want to freeze and to the right of the column you want to freeze. These are the rows and columns that will stay visible when you scroll.
Select View.
Select Freeze Panes. If you're using Excel for Mac, skip this step.
Select Freeze Panes.
Two black lines appear on the sheet to show which panes are frozen. The rows above the horizontal line are kept visible while scrolling. The columns to the left of the vertical line are kept visible while scrolling.

Unfreeze Columns and Rows

When you no longer want certain rows and columns to stay in place when you scroll, unfreeze all the panes in Excel. The data in the frames will remain, but the rows and columns that were frozen will return to their original positions.

To unfreeze panes, select View > Freeze Panes > Unfreeze Panes. On Excel for Mac, select View > Unfreeze Panes instead.

FAQ

Why would I freeze rows in Microsoft Excel?
Freezing rows keeps them visible across the top of your screen, no matter how far down you scroll. This is useful when a spreadsheet's rows extend downward past the height of your computer's screen and has multiple columns.
Why would I freeze columns in Microsoft Excel?
Freezing columns keeps them visible on the left side of your screen, no matter how far to the right you scroll. This is useful when a spreadsheet's columns extend to the right past the width of your computer's screen and has multiple rows.

Thanks for letting us know!

Get the Latest Tech News Delivered Every Day

Freeze Panes gives users the option to freeze specific columns or specific rows only. To do these, follow the method below:

Freeze First Column

The first column is locked in place during Spreadsheet navigation.

Freeze Top Row

The first row is locked in place during Spreadsheet navigation.

Freeze specific columns

This lets you highlight the columns that you want to freeze.

Click on the Freeze Panes icon and select Freeze Panes from the menu.

Now, all the specific columns are locked and stay in place as you navigate your Spreadsheet. A grey line separates locked columns from the unlocked ones.

For instance, one would like to lock A to C of their Spreadsheet. Simply highlight these columns.

Click on the Freeze Panes icon and select Freeze Panes from the menu.

Notice that columns A to C are now locked and a grey line separates these columns from the rest of the columns in your Spreadsheet.

Freeze specific rows

Choose the cell below the row that you want to freeze. Click it.

Click on the Freeze Panes icon and select Freeze Panes from the menu.

Now, all the rows above are locked and stay in place even when scrolling. A grey line separates locked rows from the unlocked ones.

For instance, one would like to lock A1 to A6 of their Spreadsheet. Simply choose A7, then click.

Click on the Freeze Panes icon and select Freeze Panes from the menu.

Notice that A1 to A6 are now locked and a grey line separates these rows from the rest of the rows in your Spreadsheet.

Users also have the option to lock in view the first column or the first row of the spreadsheet. To do such, follow these simple steps:

Unfreeze Panes

Arranging your Excel spreadsheet to its default setting is easy. To unlock the panes that were once grouped together, follow these steps:

Locate your Tool Bar and choose Layout Menu.

Drag down the menu and click Unfreeze panes.

That’s it!

Now, there’s another way on how to do this.

It’s by using the ‘Split Option’ to freeze and separate your rows into different worksheets.

This is more helpful than freezing rows if you have lots of columns on the left. Or you have several rows at the top that you want to see and freezing all of them doesn’t work.

Here’s how it looks and works.

Splitting Panes in Excel for Mac

Split Panes lets you split your spreadsheet into 2 or 4 areas, keeping two areas in place while the other two moveable.

In this case, working with Excel will be more systematic and organized which equates to time and energy saved. One will be able to browse through important numbers while keeping other significant digits viewable.

To split panes, simply follow the steps below:

First, open Excel for Mac.

Next, choose a Spreadsheet that you would like to work with.

Choose the column to the right and the row below of the table you want to split.

Locate your Tool Bar and choose ‘View’.

Choose the Split Panes icon.

For instance, you would like to split row 15.

Select row 16 and column 16.

Click on the Split icon and you’ll see divisions on your Excel worksheet, making it easier to work.

Try it yourself

Each and every feature in Microsoft Excel aims to help its users boost up productivity and achieve desired outputs without great effort.

Need help with your Microsoft Excel software?

In case you still don’t have one yet and you’re a student, you can buy a full suite of programs, Microsoft Office 2019 Home and Student for Mac.

Or if you just need Excel, go for single Excel software which is a bit cheaper.

You can buy them both from FastSoftwares.

What is the shortcut to freeze panes in Excel for Mac?

There are a few different ways to freeze panes in Excel. You can use the Ribbon, the Freeze Panes button on the View tab, or you can use one of the following keyboard shortcuts: Alt + W + F.

Why can't I freeze panes in Excel?

To enable the Freeze Panes command again, you must choose either the Normal or Page Break Preview commands. You'll have to manually restore any frozen panes that you lost when you chose Page Layout view. Figure 1: Excel's Page Layout command disables the Freeze Panes command and unfreezes rows/columns, as well.