How to freeze columns in Google Sheets on Mac: steps and how to undo it

Why freezing columns helps on a wide sheet

A wide sheet gets hard to read fast. Once you scroll right, the names or IDs that tell you what each row means slide out of view. Freezing a column pins it to the left edge of the window, so it stays put while the rest of the sheet moves under it.

People usually freeze columns on payroll sheets, customer lists and project trackers. These files often run across many columns, and the label you need is usually in column A. Freeze that one column and you always know whose row you are reading.

Freezing is a view setting. The cells underneath stay exactly as they were, with the same values, formulas and formatting.

Choose the column count, not the cell

Freezing in Sheets always starts at the left edge. Google's official steps say to select a row or column you want to freeze, then choose how many rows or columns to freeze from the menu. The number you pick decides which columns stay on screen.

Every column from the left edge up to your chosen count stays visible. If you pick 1 column, only column A is pinned. If you pick 2 columns, columns A and B are pinned. Clicking column C does not pin C by itself. You need the count that reaches it.

Count with the column letters across the top of the grid. Column A is 1, B is 2, C is 3, and so on. If you want A through C pinned, pick 3 columns. That one habit stops most wrong freezes.

Freeze the label column and nothing else, unless you read a second column on every line. Each frozen column takes up width on screen. A wide frozen block can cover most of a laptop window, and then you have little room to scroll. Keep the frozen area small so the data still has space.

A worked example with names and months

Say column A holds employee names. The months run across row 1, starting in column B. You want to check December figures against the right names. Select column A, open View, choose Freeze, then pick 1 column.

Scroll right to the end of the year. The names stay on screen the whole time. Now add a department in column B, and the months start in column C. Choose 2 columns instead of 1. Columns A and B stay pinned together while you scroll through the months.

Check that the dividing line sits after column B, not after the first month. If it sits in the wrong place, open View > Freeze again and pick the count that matches the columns you read on every row. The fix takes one click, and the data does not change.

Freeze multiple columns in Google Sheets

Multiple frozen columns work the same way as one. You pick a count, and Sheets pins that many columns from the left. The rule is simple, but people often pick a count that is one too low or one too high. Read the labels on screen after each change.

Once a freeze is on, Sheets draws a thin line between the frozen area and the rest of the sheet. Use that line to check your work. If the line sits after the column you wanted, the freeze is right. If it sits too far right, pinned columns will crowd out your scroll area.

Test the freeze with a real scroll. Move right with the trackpad, then back left. The label columns should not move at all. If a data column slides under the frozen block, your count is one too low.

Freeze rows and columns together

A header row and a label column often need freezing at the same time. Google's Freeze submenu handles rows and columns separately. Set the row freeze with 1 row, then set the column freeze from the same menu. Both stay on at once, so the top left corner holds still when you scroll in either direction.

What to do when the column sits in the middle

Freezing only reaches columns from the left edge. If the column you need sits in the middle, the freeze has to cover every column before it. That can pin far more width than you wanted.

You have two sensible options. The first is to move the column you need next to the labels. Select the column letter, then drag the column by its header to the new spot. Moving columns changes the layout, so check any formulas and tell colleagues who use the file.

The second option is to freeze every column up to the one you need. Add up the on-screen width of those columns. If the frozen block fills most of the window, choose the first option instead.

Save a copy before you rearrange anything. Use File > Make a copy, then test the freeze there. The original stays as it was while you work out the layout.

Mistakes people make with frozen columns

• Expecting a middle column to pin. Sheets freezes from the left edge, so a column in the middle needs every column before it frozen too.
• Freezing too much width. A wide frozen block leaves little room to scroll, so keep to the label columns.
• Thinking freezing moved the data. The freeze changes the view only. Cells, formulas and formatting stay where they were.
• Using the wrong No option. No columns removes column freezes, and No rows removes row freezes. Picking the wrong one looks like the freeze did not work.
• Clicking one count too far. One extra click can pin a column you did not mean to pin. Check the dividing line after each change.

Unfreeze columns in Google Sheets without losing your place

Unfreezing takes the same route as freezing. Open View, choose Freeze, then click No columns. Your scroll position does not change, so you stay where you were. To remove a row freeze, use No rows instead. Each option removes only its own kind of freeze.

If you want to keep the labels but see more data, try a filter instead of a freeze. Freezing keeps columns visible without hiding anything. A filter hides rows you do not need. To set one, choose Data > Create a filter, then use the filter arrows in the header row.

Get help from Lazur while you work

If you are not sure where a menu sits, Lazur can help on your screen. Hold ⌥ ⌘ and ask where the View menu is. Lazur draws a circle and a label around it, then answers out loud. You can also ask it to walk you through the freeze. It guides you one click at a time and waits for each click.

Lazur only listens and looks at the screen while you hold the shortcut. Audio and the screenshot go to AI providers to answer you, and they are not stored. You still do the clicks. Lazur points, explains and waits.

Check the result before you rely on it

Scroll to the far right of your data and confirm the label column is still on screen. Then scroll up and down. Any frozen row should stay at the top. If something jumps, open View > Freeze and check the count. You can change it at any time without losing data.

1. Scroll right until you reach the last column of data.
2. Confirm the label columns are still on the left.
3. Scroll down and confirm any frozen header row stays at the top.
4. Zoom out in your browser with ⌘ and the minus key if the frozen area crowds the screen.

Small screens and sharing the file

On a laptop with a small display, every frozen column takes a bigger share of the width. Test the freeze with the window at your normal size. Zooming is a browser setting, so pressing ⌘ and the minus key gives you room without changing the sheet.

Freezing is a view setting on your screen. It is not a lock on the data. If the key columns matter, label them in the data too, so anyone who opens the file without the freeze can still read it.

Fix a freeze that will not stick

If Freeze looks missing or greyed out, click a column letter or a cell first. Sheets needs a selection before the freeze options work. If the menu still looks limited, the file may be locked or shared in a way that limits changes. Ask the owner for edit access, or copy the data to a sheet you own and freeze it there.

If the wrong columns stay pinned, do not guess. Open View > Freeze > No columns, then pick the count again from the left edge. Count the column letters once more before you choose.

Where to go next

If the freeze works, the next problem is usually the data itself. Data analysts can read about cleaning data and building pivot tables in Google Sheets for data analysts on Mac. Marketers who share reports can compare shortcuts and sheet limits in Google Sheets for marketers on Mac. To see what Lazur costs before you install it, check pricing.