Using the Google Sheets shortcut on macOS is a faster and simpler way to manipulate spreadsheets. To open a list of Google Sheets keyboard shortcuts on macOS, just press Cmd + /.
Google Sheets keyboard shortcuts on macOS
1. Google Sheets shortcut operations in general
Here's a list of the Google Sheets keyboard shortcuts on macOS that can be used to manipulate common tasks, like copying or selecting columns of rows:
- Cmd + C: copy the selected cells to the clipboard.
- Cmd + X: cut selected cells to clipboard.
Cmd + V: paste the content copied into the worksheet.
Cmd + Shift + V : paste the values.
- Cmd + Space: selects all columns.
- Shift + Space: select the entire row.
- Cmd + A: select all cells.
- Cmd + Z: come back.
- Cmd + Y: repeat the operation.
- Cmd + F: look in the sheet.
- Cmd + H: find and replace in a worksheet.
- Cmd + Option + Shift + H : open spreadsheet revision history.
2. Google Sheets keyboard shortcuts format cells
Similar to Excel, Google Sheets also supports many keyboard shortcuts that you can use to format worksheet cells. Here are the Google Sheets keyboard shortcuts that format cells 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 cell.
- Cmd + Shift + L: left alignment.
- Cmd + Shift + R: right-aligned.
- Cmd +; : insert current date.
- Cmd + Shift + 7: add a border to the selected cells.
- Option + Shift + 6: remove the border from the selected cells.
- Ctrl + Shift + 1: format as a decimal number.
- Ctrl + Shift + 2: time format.
- Ctrl + Shift + 3: date format.
- Ctrl + Shift + 4: currency format.
- Ctrl + Shift + 5: format by percentage.
- Ctrl + Shift + 6 : format exponent.
Cmd: remove all formatting from the selected cells.
3. Google Sheets keyboard shortcuts move around the spreadsheet
- Arrow keys left / right / up / down: move left, right, up or down the cell.
- Ctrl + Option + arrow left / right: move to the first or last cell in a row.
- Ctrl + Option + arrow up / down: move to the first or last cell in a column.
- Fn + left arrow: move to the beginning of the row.
- Fn + right arrow: move to the end of the row.
- Cmd + Fn + left arrow: move to the beginning of the sheet.
Cmd + Fn + right arrow: move to the end of the sheet.
- Cmd + Backspace: scroll to the current working cell.
- Option + down / up arrow : if you are working on a lot of pictures, use this Google Sheets shortcut to move, open the next or previous sheet.
Option + Shift + K: show a list of all sheets.
- Ctrl + Cmd + Shift + M : move Focus out of the worksheet.
4. Google Sheets shortcuts to manipulate formulas
- Ctrl + -: show all formulas in the worksheet.
- Cmd + Shift + Enter : insert the array formula.
- Fn + F1: show full or reduced formula.
- Fn + F9: toggle the preview of results.
5. Google Sheets keyboard shortcuts work with rows and columns
- Cmd + D: copy data from the first column to selected cells below.
Cmd + R: copy data from the first row to the selected right rows.
Cmd + Enter: copy data from the first cell into other selected cells.
- Cmd + Option + 9 : hide a row.
- Cmd + Shift + 9 : show a row.
- Cmd + Option + 0: hide a column.
- Cmd + Shift + 0 : show a column.
- Ctrl + Option + I + R: insert the rows above.
- Ctrl + Option + I + W: insert the 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.
- Ctrl + Option + F : Open the File menu.
- Ctrl + Option + E: Open the Edit menu.
- Ctrl + Option + V : Open the View menu.
- Ctrl + Option + I: Open the Insert menu.
- Ctrl + Option + O: Open the Format menu.
- Ctrl + Option + T: Open the Tools menu.
- Ctrl + Option + H : open the Help menu.
- Ctrl + Option + A : Open the Accessibility menu.
- Cmd + Option + Shift + K: open the Input Tools menu.
- Cmd + Shift + F: Switch to Compact mode (hide menu).
- Shift + right click: displays the browser context menu.
TipsMake above article has just introduced you to the list of Google Sheets shortcuts on macOS. Also, if you are using Windows, you can refer to some existing articles to learn more Google Sheets shortcuts on Windows.
Good luck
Google SheetsncG1vNJzZmismaXArq3KnmWcp51ktLC7xqWcZquYmrK1v4yknLKan5a%2FpXnSoaarrJOqwbR5zqdkppmTpMA%3D