Select an Entire Row or Column in Excel for Mac: Why Ctrl+Space Can Fail (2026)

How do you select an entire row or column in Excel for Mac?

Microsoft lists Ctrl+Spacebar for the entire column and Shift+Spacebar for the entire row, and Exceljet agrees; Cmd+A selects the current region or the whole sheet when pressed more than once.

  1. Click any cell in the column or row.

  2. Press Ctrl+Spacebar for the column, or Shift+Spacebar for the row.

  3. Press Cmd+A once for the current region and again for the whole sheet, as Microsoft describes.

Why does Ctrl+Space not select the column on some Macs?

Microsoft marks Select the entire column with an asterisk meaning it can conflict with a default macOS shortcut, and Apple lists Control-Space bar as selecting the previous input source with multiple input sources.

Apple says Control-Space bar and Control-Option-Space bar select the previous or next input source if you use multiple input sources to type in different languages. Microsoft's own explanation of its asterisk mentions changing the Show Desktop shortcut, which is not what Apple lists for Control-Space, so we cannot tell which macOS shortcut Microsoft means. If you use one keyboard language, the input-source conflict Apple describes may not apply to you.

  1. Open System Settings, Keyboard, Keyboard Shortcuts.

  2. Look under Input Sources and the other categories for an entry using Control-Space.

  3. Microsoft's instruction is to clear the checkbox of the conflicting shortcut, then retry in Excel.

How do you select visible cells, the current region or the whole sheet?

Microsoft lists Cmd+A for the current region or entire sheet, Shift+Cmd+Asterisk for visible cells only, and Cmd+A or Cmd+Shift+Spacebar for Select all in its frequently used list.

TaskMicrosoft (Mac table)ExceljetApple
Select entire columnCtrl+Spacebar (flagged with an asterisk)Control+SpaceControl-Space bar: select the previous input source, with multiple input sources
Select entire rowShift+SpacebarShift+Space (index)Not listed
Select current region or sheetCmd+A, press more than once to expandNot openedNot applicable
Select all (frequently used list)Cmd+A or Cmd+Shift+SpacebarNot openedNot applicable
Select only visible cellsShift+Cmd+AsteriskNot openedNot applicable

What do the sources say?

Microsoft and Exceljet agree on Ctrl+Spacebar for columns and Shift+Spacebar for rows, but only Microsoft flags the column shortcut as conflicting, and Apple lists Control-Space bar for input sources.

We found no source that reports which Macs are affected, so the fix above is a checklist, not a diagnosis.

Where does Mac Excel Shortcuts fit?

Mac Excel Shortcuts is our app that replicates Windows Excel shortcuts on a Mac. We did not check whether it covers Ctrl+Space, so see the covered-list page before relying on it.

It has a free trial of 7 days or 10 shortcut uses, then costs $49 once or $4.99 a month. This page is not a test of the app. See the list of shortcuts it covers.

FAQs

What is the shortcut to select a column in Excel for Mac?

Microsoft lists Ctrl+Spacebar for the entire column. It marks that shortcut as one that can conflict with a macOS default.

What is the shortcut to select a row in Excel for Mac?

Microsoft lists Shift+Spacebar for the entire row.

Why does Ctrl+Space switch my keyboard language?

Apple lists Control-Space bar as selecting the previous input source if you use multiple input sources.

How do I select the whole sheet?

Microsoft lists Cmd+A, pressed more than once, and Cmd+Shift+Spacebar for Select all.

How we checked this guide

We opened the pages below on November 15, 2026. We read Microsoft's Excel for Mac shortcut table directly from the page and compared it with the other sources. We did not test Excel on a Mac. Limits: Microsoft carries no edit date and its explanation of the asterisk does not match the shortcut Apple lists; Exceljet pages were read only as an index; Apple describes input sources generally, not Excel.

References

← Back to all articles

Mac Excel Shortcuts: Excel shortcuts not working on Mac? Alt E S V, Paste Values, the Windows way. Try it free for 7 days.