Google Sheets keyboard shortcuts on macOS
Similar to Google Sheets for Windows, Google Sheets for macOS also supports keyboard shortcuts to help users operate faster and save more time. In the article below, TipsMake will show you a list of Google Sheets shortcuts on macOS.
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
You should read it
- Tricks using Google Sheets should not be ignored
- How to create graphs, charts in Google Sheets
- How to align spreadsheets before printing on Google Sheets
- How to enter 0 in Google Sheets
- How to create a phone number can be called on Google Sheets
- How to view editing history on Google Sheets
- 6 useful functions in Google Sheets you may not know yet
- How to fix Google Sheets not allowing scrolling
- How to count words on Google Sheets
- How to set up the right to edit spreadsheets on Google Sheets
- How to write notes, comments on Google Sheets
- How to insert checkboxes on Google Sheets
Maybe you are interested
Top 8 great Halloween movies you should watch How to turn an image into vector for editing in Adobe Illustrator 100+ Beautiful frames to stitch photos Is the sensor vibration reduction technology unique, making Apple want to equip its new iPhone? Risk of virus infection from browser and prevention Turn Raspberry Pi into an Amazon Echo