how do i freeze a single row in excel for mac

When you purchase through links on our site, we may earn an affiliate commission.

I mean, its one thing to compare one or two rows of information when its a small subset of data, but when its 10 rows or more, things can get unwieldy.

When your spreadsheets become too unwieldy, theres only one solution: freeze the rows and columns.

Image credit: Future) Freezing the rows and columns in Excel is pretty simple and it makes navigating your spreadsheet so much easier.

When its done correctly, the chosen panes within Excels freeze panes are locked in place.

That means those specific rows so theyre always visible when you scroll.

More often than not, youll probably only freeze 1 or 2 rows or column, but Excel doesnt limit how many of either you can freeze, which can come in handy for larger, data-heavy sheets.

This how-to works with Microsoft Excel 2016 as well as later versions.

How to freeze a row in Excel There are two quick steps to freezing or locking rows.

Select the row right below the row or rows you want to freeze.

If you want to freeze columns, select the cell immediately to the right of the column you want to freeze.

In this example, we want to freeze rows 1 to 6, so weve selected row 7.

Go to the View tab 3.

As you can see in our example, the frozen rows will stay visible when you scroll down.

You can tell where the rows were frozen by the green line dividing the frozen rows and the rows below them.

If you want to unfreeze the rows, go back to the Freeze Panes command and choose Unfreeze Panes.

Note that under the Freeze Panes command, you can also choose Freeze Top Row, which will freeze the top row thats visible (and any others above it) or Freeze First Column, which will keep the leftmost column visible when you scroll horizontally.

Besides allowing you to compare different rows in a long spreadsheet, the freeze panes feature lets you keep important information, such as table headings, always in view.

Need more Excel tricks Check out our tutorials on How to Lock Cells in Excel, How to Use VLOOKUP in Excel and our Excel tips roundup to boost your productivity in a big way.

You can unsubscribe at any time and well never share your details without your permission.

How Do I Freeze A Single Row In Excel For Mac