Buzz
Similar to Google Sheets for Windows, Google Sheets for macOS also supports shortcuts to help users operate faster and save time. In this article, Mytour will introduce you to the list of Google Sheets shortcuts on macOS.
Using Google Sheets shortcuts on macOS is a way to manipulate spreadsheets faster and more simply. To open the shortcut list on Google Sheets on macOS, just press Cmd + /.
Compilation of Google Sheet shortcuts on MacOS
Google Sheets Shortcuts:
1. General operations.
2. Cell formatting.
3. Navigating around the spreadsheet.
4. Working with formulas.
5. Working with rows, columns.
6. Accessing Google Sheets menu.
1. General operations.
2. Cell formatting.
3. Navigating around the spreadsheet.
4. Working with formulas.
5. Working with rows, columns.
6. Accessing Google Sheets menu.
List of Google Sheets shortcuts on macOS
1. Google Sheets general operations shortcuts
Below is a list of Google Sheets shortcuts on macOS used for general tasks, such as copying or selecting columns and rows:
- Cmd + C: copy selected cells to clipboard.
- Cmd + X: cut selected cells to clipboard.
- Cmd + V: paste copied content into spreadsheet.
- Cmd + Shift + V: paste values.
- Cmd + Space: select all columns.
- Shift + Space: select all rows.
- Cmd + A: select all cells.
- Cmd + Z: undo.
- Cmd + Y: repeat action.
- Cmd + F: find in spreadsheet.
- Cmd + H: find and replace in spreadsheet.
- Cmd + Option + Shift + H: open spreadsheet edit history.
2. Google Sheets cell formatting shortcuts
Similar to Excel, Google Sheets also supports many shortcuts that you can use to format cells in a spreadsheet. Below are the Google Sheets cell formatting shortcuts on macOS:
- Cmd + B: bold.
- Cmd + I: italic.
- Cmd + U: underline.
Ctrl+Shift+E (Windows/Chrome OS) or Cmd+Shift+E (macOS): Center align a cell.
- Cmd + Shift + E: center align.
- Cmd + Shift + L: left align.
- Cmd + Shift + R: right align.
- Cmd + ; : insert current date.
- Cmd + Shift + 7: add border to selected cells.
- Option + Shift + 6: remove border from selected cells.
- Ctrl + Shift + 1: format as decimal number.
- Ctrl + Shift + 2: format as time.
- Ctrl + Shift + 3: format as date.
- Ctrl + Shift + 4: format as currency.
- Ctrl + Shift + 5: format as percentage.
- Ctrl + Shift + 6: format as exponent.
- Cmd : \: remove all formatting from selected cells.
3. Google Sheets shortcuts for navigating around the spreadsheet
- Left / Right / Up / Down arrow keys: move left, right, up, or down one cell.
- Ctrl + Option + Left / Right arrow keys: move to the first or last cell in a row.
- Ctrl + Option + Up / Down arrow keys: move to the first or last cell in a column.
- Fn + Left arrow key: move to the beginning of the row.
- Fn + Right arrow key: move to the end of the row.
- Cmd + Fn + Left arrow key: move to the beginning of the spreadsheet.
- Cmd + Fn + Right arrow key: move to the end of the spreadsheet.
- Cmd + Backspace: scroll to the currently active cell.
- Option + Down / Up arrow keys: when working with multiple sheets, use this Google Sheets shortcut to navigate to the next or previous sheet.
- Option + Shift + K: display a list of all sheets.
- Ctrl + Cmd + Shift + M: move the focus out of the spreadsheet.
4. Google Sheets shortcuts for working with formulas
- Ctrl + -: show all formulas in the spreadsheet.
- Cmd + Shift + Enter: insert an array formula.
- Fn + F1: display the formula in full or collapse it.
- Fn + F9: toggle the result preview mode.
5. Google Sheets shortcuts for working with rows, columns
- Cmd + D: copy data from the first column down to the selected cells below.
- Cmd + R: copy data from the first row to the right selected rows.
- Cmd + Enter: copy data from the first cell to other selected cells.
- Cmd + Option + 9: hide a row.
- Cmd + Shift + 9: unhide a row.
- Cmd + Option + 0: hide a column.
- Cmd + Shift + 0: unhide a column.
- Ctrl + Option + I + R: insert rows above.
- Ctrl + Option + I + W: insert rows below.
- Ctrl + Option + I + C: insert column to the left.
- Ctrl + Option + I + O: insert column to the right.
- Ctrl + Option + E+ D: delete row.
- Ctrl + Option + E + E: delete column.
6. Access Google Sheets menu shortcuts on macOS
- Ctrl + Option + F: open File menu.
- Ctrl + Option + E: open Edit menu.
- Ctrl + Option + V: open View menu.
- Ctrl + Option + I: open Insert menu.
- Ctrl + Option + O: open Format menu.
- Ctrl + Option + T: open Tools menu.
- Ctrl + Option + H: open Help menu.
- Ctrl + Option + A: open Accessibility menu.
- Cmd + Option + Shift + K: open Input Tools menu.
- Cmd + Shift + F: switch to Compact mode (hide menu).
- Shift + right-click: display browser context menu.
Mytour has just introduced you to the Google Sheets shortcut list on macOS. Additionally, if you are using Windows, you can refer to some articles on Mytour to learn more about Google Sheets shortcuts on Windows.
- Read more: Google Sheets shortcuts on Windows.
