How to insert a row above in Google Sheets on Mac: keyboard and menu steps

Google Sheets on a Mac runs in your browser. The sources I checked describe it as a web app, and I found no native Mac app for it. That means the steps work in any browser where you open the file, unless an extension gets in the way. The hard part is rarely the keys. The hard part is selecting the right row first, because that choice decides where the new row lands.

These steps come from Google's help pages and one third-party guide. I did not check them on a live Mac for this page. Where the menu label is uncertain, the text says so, so read the labels on your screen before you click.

Insert a row above with the keyboard shortcut on Mac

The fastest route is ⌘ ⌥ =. Hold Command and Option, then press the equals key. Google's keyboard shortcut help page lists this combination for inserting rows above when rows are selected. Use it when you already know which row should move down. You do not need to open any menu.

Here is the sequence in plain steps. Click the row number on the left edge. Check that the whole row turns highlighted. Press ⌘ ⌥ =. A blank row appears above the row you picked, and the existing data shifts down by one row.

• Your selection covers the row that should move down.
• You have edit access to the file, so you can change its rows.
• No browser extension uses the same keys.
• You know which row the new one should sit above.

Select the right row before you insert

A row is selected when its number on the left edge turns highlighted. Clicking a cell selects only that cell. That is a different thing, and it causes most of the confusion. Google's page says 'with rows selected', and it does not say a single cell will work.

The Bricks guide takes a different route. It says to select a row from a cell with Shift and Space, then press ⌘ ⌥ =. The guide calls that combination the most fluid for everyday use. Try it if you already work from the keyboard. Click the row number if you want the least guesswork.

Here is why the selection matters. Say your budget sheet has a totals row at row 14. You want a new expense above the totals. If you click cell C14 by mistake, you may not be sure which row the insert will use. Clicking the number 14 removes that doubt.

Insert a row above from the right-click menu

Google's Workspace Learning Center cheat sheet describes the mouse route. Select a row, then right-click the highlighted selection. Go to the Insert option and pick where the new row should go. The cheat sheet describes this route, not a keyboard shortcut.

The exact wording is the part that varies. A summary of Google's help text suggested a label like 'Insert 1 row above'. I could not confirm that label on Google's page. Read the submenu on your screen, and pick the option that places the new row above the one you selected.

Right-click works well when you cannot remember the keys. It also helps on a computer you share, where you would rather not change a shortcut setting. The trade-off is speed. Each insert takes more clicks than the shortcut does.

Use the Insert menu from the keyboard

Google's shortcut page, as summarized, gives ⌃ ⌥ I to open the Insert menu on a Mac. From there, R then R inserts a row above. R then B inserts a row below. This is the least familiar route, so practice it on a copy of the sheet first.

Once the sequence works, it is quick. Your hand stays on the keyboard. That matters on a long sheet where you add several rows in a row. Check the result after each insert until the pattern feels automatic.

Worked example: adding a row to a budget sheet

Say you have a budget sheet. The header sits in row 1, the expenses run from row 2 to row 13, and the total sits in row 14. You need a new travel expense above the total. Click the number 14. Press ⌘ ⌥ =. The total moves to row 15, and row 14 is blank for the travel entry.

Now check the formula. A total in row 15 that sums B2 to B13 may not grow to include a new row 14. Google's help pages I opened do not explain how formulas react to every insert. Look at the formula after the insert, and fix the range if it skipped the new row.

Why the shortcut does nothing on Mac

Most failures come from three causes. The first is selection. A third-party guide says a single selected cell can open an insert menu instead of adding a row. Select the whole row by its number, then try again.

The second cause is browser extensions. Password managers and screen clippers can use the same key combination. The Bricks guide suggests testing in an Incognito or Private window. If the shortcut works there, an extension is the likely cause. Disable it or change its shortcut.

The third cause is macOS. The system can reserve some key combinations. Open System Settings, go to Keyboard, then Keyboard Shortcuts, and look for a conflict with ⌘ ⌥ = or ⌃ ⌥ I. Change only the setting that conflicts, and write down what you changed so you can reverse it.

Mistakes people make when they insert rows

• Selecting one cell instead of the whole row, then wondering where the new row went.
• Inserting above a header row without checking the formulas and charts that read it.
• Testing a new shortcut on the live file instead of a copy.
• Forgetting undo. ⌘ Z reverses the last insert in one step, while it is still the last action.
• Assuming the menu wording on your screen matches a guide written for another version.

Most of these have the same fix, which is a quick check. Look at the new row, then at the rows around it. Confirm that totals and sorted ranges still point where you expect.

How big can a Google Sheets file get?

Long sheets can hit limits before they run out of rows. Google doubled the cell limit per spreadsheet. The limit went from up to 10 million cells to up to 20 million cells. The announcement is dated September 10, 2026.

Rollout began September 10 for Rapid Release domains and September 28 for Scheduled Release domains. The announcement does not say what happens at the limit. It gives no error message, and it does not mention row or column limits.

Do not assume the cell limit tells you how many rows you can add. Each new row adds cells, though, so a wide sheet reaches the cap sooner. To estimate, multiply the number of columns by the number of rows you expect to use.

Why careful row edits matter

Panko's audits are older studies, and they cover spreadsheets in general, not Google Sheets. In five audits covering 55 spreadsheets, Panko's page states that the authors found important errors in 91%. The pattern is still useful. Row inserts look small, and they can break formulas that you never look at.

A quick check after each insert catches many problems early. That check takes seconds. Fixing a broken total after a week of edits takes much longer.

Where Lazur fits in

Lazur is a voice assistant for the Mac. Hold ⌥ ⌘, which is Option and Command, and ask about anything on screen. Lazur listens and looks at the screen only while you hold the keys. It answers out loud, and it points at things it can see.

Ask where something is, and Lazur draws a circle and a label around it. A question like 'Where's the Insert menu?' gets you a circle on the menu. That helps when a guide's wording does not match your screen. Ask how to do something, and Lazur guides you one click at a time. It waits for each click.

• Where's the Insert menu?
• Walk me through inserting a row above with the right-click menu.
• Which row is selected right now?
• Why did nothing happen when I pressed the shortcut?
• What's the difference between selecting a cell and selecting a row?

Lazur points and explains. You still press the keys and make the change. It does not click buttons, edit files or operate Google Sheets for you. That split keeps the sheet in your hands.

What to do after the row is in place

Fill the new row first, then check the rows around it. Confirm that totals, sorted ranges and formulas still point where you expect. If something looks wrong, press ⌘ Z while the insert is still the last action.

If you clean data often, the data analyst guide covers cleanup, pivots and asking Lazur for help in Sheets on Mac. Read Google Sheets for data analysts on Mac when you are ready for the next step.

Practice on a copy of the sheet for a few minutes. Once the shortcut works, it becomes a habit you stop thinking about.