Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11Google 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
Isabella HumphreyYou 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
- How to create graphs, charts in Google Sheets
google sheets also features a graphical representation, showing the data that are included so that users can change the chart. - List of common shortcuts for Google Sheets on Chrome OS (Part 3)google sheets consists of worksheets, each sheet consists of multiple cells created by rows and columns, the toolbar supports basic tools such as formatting sheets, cells, text, inserting charts, images, ... .
- Pubg keyboard shortcuts - All the Pubg keyboard shortcuts you need to knowpubg keyboard shortcuts - all the pubg keyboard shortcuts you need to know. to become a professional gamer and survive in the world of pubg (playerunknowns battlegrounds), in addition to the powerful configuration computer, the keyboard, the correct mouse, the shortcut keys for quick operation are quite important for each gamer.
- Useful keyboard shortcuts in Microsoft Word (Part 2)tips make introduce to you how to use the shortcut set with the f key from f1, f2, f3, ..., f12 with detailed explanation, easy-to-understand illustrations.
- How to align spreadsheets before printing on Google Sheetsbefore printing spreadsheet data on google sheets, users should adjust the data sheet before printing to get a better layout.
- Shortcut list for Google Docs on your computer (Part 1)google docs does not have as many functions as microsoft office but only provides some essential features to help you draft an effective document. using keyboard shortcuts makes it easy to understand how to use google docs.
- Google Drive for creating quick access shortcuts from the desktopto make it easier for users, google has just released a new google drive update that creates shortcuts to docs, sheets, and slides document types right on the user's desktop.
- Summary of 60+ latest keyboard shortcuts on Windows computersthe tips for using shortcuts super fast on windows computers. quick guide on how to use simple and easy to understand keyboard shortcuts. let's find out together now!
- How to change keyboard shortcuts in Photoshopadobe photoshop allows you to change keyboard shortcuts related to any function of the application. this article will show you how to change keyboard shortcuts in photoshop on windows and mac, as well as how to reset keyboard shortcuts to their default values.
- Useful keyboard shortcuts in Microsoft Word (Part 3)to continue the previous post, tips make would like to summarize for you how to use the shortcut keys with the f key from f7, f8, ..., f12 with detailed explanation, easy-to-understand illustrations.
Mac OS X
- The error causes Mac users to lose data
- How to check if the Macbook Battery is faulty or not?
- 3 simple and quick ways to take a screenshot on your MacBook
- How to turn a MacBook into a desktop Mac
- How to set up a local web server (Local Web Server) on Windows, macOS, and Linux
- Top 8 best photo editors for Mac
The error causes Mac users to lose data
How to check if the Macbook Battery is faulty or not?
3 simple and quick ways to take a screenshot on your MacBook
How to turn a MacBook into a desktop Mac
How to set up a local web server (Local Web Server) on Windows, macOS, and Linux