Google Sheets keyboard 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
- 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
May be interested
- The error causes Mac users to lose datamac users who are thinking of upgrading to macos big sur should double check this before updating. and recently, a new problem has been discovered on macos big sur, a very rudimentary bug that no one would think a company as famous for its meticulousness as apple can encounter.
- How to check if the Macbook Battery is faulty or not?recently, apple has officially confirmed that the macbook pro has a faulty pin and provides users with a link to look up the faulty macbook battery so that users can check if their macbook is having problems. .
- 3 simple and quick ways to take a screenshot on your MacBookyou want to take a picture of the macbook's screen but are struggling forever. then don't worry, this article will guide you through 3 simple and quick screenshots of the macbook. stay tuned!
- How to turn a MacBook into a desktop Macin the article below, tipsmake will guide you on how to turn a macbook into a mac desktop.
- How to set up a local web server (Local Web Server) on Windows, macOS, and Linuxwhen developing your own website, you need to have the ability to observe and evaluate what the website might look like from a regular visitor's perspective. here are the steps for setting up a local web server on windows, mac and linux
- Top 8 best photo editors for Macby adding and installing one of the best photo editors for mac today, you can easily edit, edit your photo collection in the most professional way.