Google sheets are a great way to keep track of information and are especially helpful for those who are visual learners. Google sheets can be used for a variety of purposes, from tracking expenses to organizing a grocery list. The best part about Google sheets is that they can be accessed from anywhere, at any time.
However, the Google sheets user interface can be a bit daunting for those who are new to it. This is where keyboard shortcuts come in handy. By using keyboard shortcuts, users can quickly and easily navigate the Google sheets interface without having to take their hands off the keyboard.
In this article, we will provide a list of keyboard shortcuts for both Windows and Mac users that will help make your Google sheets experience more efficient and enjoyable.
Contents
Google Sheets Shortcuts for Windows and Mac Users
Are you a heavy Google Sheets user? If you are, you probably know there are plenty of keyboard shortcuts that can make your life a lot easier.
But did you know there are different keyboard shortcuts for Windows and Mac users? That’s right, the keys are different depending on what operating system you’re using.
So, if you want to make the most out of Google Sheets, it’s important to know the keyboard shortcuts for both Windows and Mac.
Here are the most important Google Sheets keyboard shortcuts for Windows and Mac users:
Google Sheets Common Shortcuts for Windows
If you are a Windows user, you may be surprised to learn that there are some useful shortcuts that can make using Google Sheets a lot easier. Here are a few of the most useful ones:
WINDOWS | ACTION |
Alt + / | Search the menus |
Ctrl + / | Show keyboard shortcuts |
Ctrl + A | Select all |
Ctrl + Alt + Shift + K | Select input tools |
Ctrl + C | Copy |
Ctrl + D | Fill down |
Ctrl + Enter | Fill range |
Ctrl + F | Find |
Ctrl + H | Find and replace |
Ctrl + O | Open |
Ctrl + P | |
Ctrl + R | Fill right |
Ctrl + Shift + F | Compact controls |
Ctrl + Shift + K | Input tools on/off |
Ctrl + Shift + V | Paste values only |
Ctrl + Space | Select column |
Ctrl + V | Paste |
Ctrl + X | Cut |
Ctrl + Y | Redo |
Ctrl + Z | Undo |
Shift + F11 | Insert new sheet |
Shift + Space | Select row |
Google Sheets Common Shortcuts for Mac
If you’re a Mac user and you use Google Sheets, you’re in luck. There are a number of shortcuts that can make using Google Sheets on a Mac much easier and faster. Here are some of the most useful shortcuts for Mac users:
MAC | ACTION |
Option + / | Search the menus |
⌘ + / | Show keyboard shortcuts |
⌘ + A | Select all |
⌘ + Option + Shift + K | Select input tools |
⌘ + C | Copy |
⌘ + D | Fill down |
⌘ + Enter | Fill range |
⌘ + F | Find |
⌘ + Shift + H | Find and replace |
⌘ + O | Open |
⌘ + P | |
⌘ + R | Fill right |
Ctrl + Shift + F | Compact controls |
⌘ + Shift + K | Input tools on/off |
⌘ + Shift + V | Paste values only |
Ctrl + Space | Select column |
⌘ + V | Paste |
⌘ + X | Cut |
⌘ + Y | Redo |
⌘ + Z | Undo |
Shift + Fn + F11 | Insert new sheet |
Shift + Space | Select row |
A shortcut is the best way to navigate Google Sheets faster. There are a number of navigation shortcuts that can help you get around Google Sheets quickly and easily.
Here are some of the most useful Google Sheets navigation shortcuts for Windows and Mac:
WINDOWS | MAC | ACTION |
Alt + Down arrow | Option + Down arrow | Move to the next sheet |
Alt + Enter | Option + Enter | Open hyperlink |
Alt + Shift + 1 | Option + Shift + 1 | Apply top border |
Alt + Shift + 2 | Option + Shift + 2 | Apply right border |
Alt + Shift + 3 | Option + Shift + 3 | Apply bottom border |
Alt + Shift + 4 | Option + Shift + 4 | Apply left border |
Alt + Shift + 5 | Option + Shift + 5 | Strikethrough |
Alt + Shift + 6 | Option + Shift + 6 | Remove borders |
Alt + Shift + 7 | Option + Shift + 7 | Apply outer border |
Alt + Shift + K | Option + Shift + K | Display a list of sheets |
Alt + Shift + Q | Option + Shift + Q | Move to a quick sum |
Alt + Shift + X | Option + Shift + X | Open Explore |
Alt + Up arrow | Option + Up arrow | Move to the previous sheet |
Ctrl + ; | ⌘ + ; | Insert date |
Ctrl + \ | ⌘ + \ | Clear formatting |
Ctrl + Alt + . | ⌘ + Option + . | Go to a side panel |
Ctrl + Alt + R | Ctrl + ⌘ + R | An open drop-down menu on filtered cell |
Ctrl + Alt + Shift + ; | ⌘ + Option + Shift + ; | Insert date and time |
Ctrl + Alt + Shift + H | ⌘ + Option + Shift + H | Open revision history |
Ctrl + Alt + Shift + M | Ctrl + ⌘ + Shift + M | Move focus off a spreadsheet |
Ctrl + B | ⌘ + B | Bold |
Ctrl + Backspace | ⌘ + Backspace | Scroll to an active cell |
Ctrl + End | ⌘ + Fn + Right arrow | Move to the end of a sheet |
Ctrl + Home | ⌘ + Fn + Left arrow | Move to begin of sheet |
Ctrl + I | ⌘ + I | Italic |
Ctrl + K | ⌘ + K | Insert link |
Ctrl + Shift + ; | ⌘ + Shift + ; | Insert time |
Ctrl + Shift + 1 | Ctrl + Shift + 1 | Format as decimal |
Ctrl + Shift + 2 | Ctrl + Shift + 2 | Format as time |
Ctrl + Shift + 3 | Ctrl + Shift + 3 | Format as date |
Ctrl + Shift + 4 | Ctrl + Shift + 4 | Format as currency |
Ctrl + Shift + 5 | Ctrl + Shift + 5 | Format as Percentage |
Ctrl + Shift + 6 | Ctrl + Shift + 6 | Format as exponent |
Ctrl + Shift + E | ⌘ + Shift + E | Center align |
Ctrl + Shift + L | ⌘ + Shift + L | Left align |
Ctrl + Shift + R | ⌘ + Shift + R | Right align |
Ctrl + U | ⌘ + U | Underline |
End | Fn + Right arrow | Move to the end of the row |
Google Sheets Formatting Shortcuts
The windows and mac users, the best ways to save time when formatting on Google Spreadsheets. Here, you’ll be happy to know that there are several shortcuts you can use to speed up the process.
WINDOWS | MAC | ACTION |
Alt + Shift + 1 | Option + Shift + 1 | Apply top border |
Alt + Shift + 2 | Option + Shift + 2 | Apply right border |
Alt + Shift + 3 | Option + Shift + 3 | Apply bottom border |
Alt + Shift + 4 | Option + Shift + 4 | Apply left border |
Alt + Shift + 5 | Option + Shift + 5 | Strikethrough |
Alt + Shift + 6 | Option + Shift + 6 | Remove borders |
Alt + Shift + 7 | Option + Shift + 7 | Apply outer border |
Ctrl + ; | ⌘ + ; | Insert date |
Ctrl + \ | ⌘ + \ | Clear formatting |
Ctrl + Alt + Shift + ; | ⌘ + Option + Shift + ; | Insert date and time |
Ctrl + B | ⌘ + B | Bold |
Ctrl + I | ⌘ + I | Italic |
Ctrl + K | ⌘ + K | Insert link |
Ctrl + Shift + ; | ⌘ + Shift + ; | Insert time |
Ctrl + Shift + 1 | Ctrl + Shift + 1 | Format as decimal |
Ctrl + Shift + 2 | Ctrl + Shift + 2 | Format as time |
Ctrl + Shift + 3 | Ctrl + Shift + 3 | Format as date |
Ctrl + Shift + 4 | Ctrl + Shift + 4 | Format as currency |
Ctrl + Shift + 5 | Ctrl + Shift + 5 | Format as Percentage |
Ctrl + Shift + 6 | Ctrl + Shift + 6 | Format as exponent |
Ctrl + Shift + E | ⌘ + Shift + E | Center align |
Ctrl + Shift + L | ⌘ + Shift + L | Left align |
Ctrl + Shift + R | ⌘ + Shift + R | Right align |
Ctrl + U | ⌘ + U | Underline |
Google Sheets Menu Shortcuts
The Google Sheets Menu Shortcuts for Windows and Mac can help users quickly access some of the most commonly used sheet commands. To access the menu shortcuts, simply press the keyboards as given below:
WINDOWS | MAC | ACTION |
Alt + A (Chrome) / Alt + Shift + A | Ctrl + Option + A | Accessibility menu |
Alt + D (Chrome) / Alt + Shift + D | Ctrl + Option + D | Data menu |
Alt + E (Chrome) / Alt + Shift + E | Ctrl + Option + E | Edit menu |
Alt + F (Chrome) / Alt + Shift + F | Ctrl + Option + F | File menu |
Alt + H (Chrome) / Alt + Shift + H | Ctrl + Option + H | Help menu |
Alt + I (Chrome) / Alt + Shift + I | Ctrl + Option + I | Insert menu |
Alt + M (Chrome) / Alt + Shift + M | Ctrl + Option + M | Form menu |
Alt + N (Chrome) / Alt + Shift + N | Ctrl + Option + N | Add-ons menu |
Alt + O (Chrome) / Alt + Shift + O | Ctrl + Option + O | Format menu |
Alt + Shift + S | Option + Shift + S | Sheet menu |
Alt + T (Chrome) / Alt + Shift + T | Ctrl + Option + T | Tools menu |
Alt + V (Chrome) / Alt + Shift + V | Ctrl + Option + V | View menu |
Ctrl + Alt + – | ⌘ + Option + – | Open delete menu |
Ctrl + Alt + Shift + = | ⌘ + Option + = | Open insert menu |
Ctrl + Shift + \ | ⌘ + Shift + \ | Context menu |
Google Sheets Formulas Shortcuts
This is a great way to use google sheets formulas shortcuts for windows and mac. There are many ways that you can use these shortcuts to make your work easier and faster. The formula shortcuts are as follows:
WINDOWS | MAC | ACTION |
Ctrl + ~ | Ctrl + ~ | Show all formulas |
Ctrl + E | ⌘ + E | Collapse an expanded array formula |
Ctrl + Shift + Enter | ⌘ + Shift + Enter | Insert array formula |
Ctrl + Up / Ctrl + Down arrow | Ctrl + Option + Up / Ctrl + Option + Down arrow | Resize formula bar |
F1 | Fn + F1 | Full/compact formula help |
F4 | Fn + F4 | Absolute/relative references |
F9 | Fn + F9 | Toggle formula result previews |
Shift + F1 | Shift + Fn + F1 | Show/hide formula help |
Google Sheets Rows and Columns Shortcuts
WINDOWS | MAC | ACTION |
Alt + E, then D (Chrome) / Alt + Shift + E, then D | Ctrl + Option + E, then D | Delete rows |
Alt + E, then E (Chrome) / Alt + Shift + E, then E | Ctrl + Option + E, then E | Delete columns |
Alt + I, then C (Chrome) / Alt + Shift + I, then C | Ctrl + Option + I, then C | Insert columns to the left |
Alt + I, then O (Chrome) / Alt + Shift + I, then O | Ctrl + Option + I, then O | Insert columns to the right |
Alt + I, then R (Chrome) / Alt + Shift + I, then R | Ctrl + Option + I, then R | Insert rows above |
Alt + I, then W (Chrome) / Alt + Shift + I, then W | Ctrl + Option + I, then B | Insert rows below |
Alt + Shift + Down arrow | Option + Shift + Down arrow | Expand grouped rows or columns |
Alt + Shift + Left arrow | Option + Shift + Left arrow | Ungroup rows or columns |
Alt + Shift + Right arrow | Option + Shift + Right arrow | Group rows or columns |
Alt + Shift + Up arrow | Option + Shift + Up arrow | Collapse grouped rows or columns |
Ctrl + Alt + 0 | ⌘ + Option + 0 | Hide column |
Ctrl + Alt + 9 | ⌘ + Option + 9 | Hide row |
Ctrl + Shift + 0 | ⌘ + Shift + 0 | Unhide column |
Ctrl + Shift + 9 | ⌘ + Shift + 9 | Unhide row |
Google Sheets Notes and Comments Shortcuts
WINDOWS | MAC | ACTION |
Ctrl + Alt + M | ⌘ + Option + M | Insert/edit comment |
Ctrl + Alt + Shift + A | ⌘ + Option + Shift + A | Open comment discussion thread |
Holding Ctrl + Alt, press E then C | Holding Ctrl + ⌘, press E then C | Enter current comment |
Holding Ctrl + Alt, press N then C | Holding Ctrl + ⌘, press N then C | Move to the next comment |
Holding Ctrl + Alt, press P then C | Holding Ctrl + ⌘, press P then C | Move to the previous comment |
Shift + F2 | Shift + F2 | Insert/edit note |
Google Sheets Screen Readers Shortcuts
WINDOWS | MAC | ACTION |
Ctrl + Alt + H | ⌘ + Option + H | Enable braille support |
Ctrl + Alt + Shift + C | ⌘ + Option + Shift + C | Read Column |
Ctrl + Alt + Shift + R | ⌘ + Option + Shift + R | Read row |
Ctrl + Alt + Z | ⌘ + Option + Z | Turn on screen reader support |
How to use Google Sheets?
Google Sheets is a free online spreadsheet application that allows you to create and format spreadsheets and simultaneously work with other people. You can also upload existing spreadsheets from Excel or other software. Here are some basics on how to use Google Sheets:
Creating a New Spreadsheet
To create a new spreadsheet, open Google Drive (drive.google.com) and click on the “New” button. Then, select “Google Sheets” from the drop-down menu. This will open up a new blank spreadsheet in your browser.
Formatting Your Spreadsheet
Once you have a blank spreadsheet open, you can start entering your data. You can format your data in a variety of ways, such as changing the font size or color, adding or removing cell borders, and more.
To format your data, select the cells that you want to format. Then, click on the “Format” option in the top menu. This will open up a sidebar on the right side of the screen with a variety of formatting options.
Inserting Images and Charts
In addition to data, you can also insert images and charts into your Google Sheet. To insert an image, click on the “Insert” option in the top menu. Then, select “Image” from the drop-down menu. This will open up a window where you can search for an image or upload one from your computer.
To insert a chart, click on the “Insert” option in the top menu. Then, select “Chart” from the drop-down menu. This will open up a window where you can select the type of chart you want to insert.
Working with Others
One of the great things about Google Sheets is that you can easily share your spreadsheet with others and work on it together in real-time. To share your spreadsheet, click on the “Share” button in the top-right corner of the screen. This will open up a window where you can enter the email addresses of the people you want to share the spreadsheet with.
Once you’ve shared your spreadsheet, you and the other people you’ve shared it with will be able to edit it simultaneously. You’ll see each other’s changes in real-time, and you can chat with each other using the chat box in the right sidebar.
Finally, I hope this article helps you to make your work faster on Google Sheets. As you can see, there is a large number of keyboard shortcuts available that can save you time and make working with spreadsheets a breeze. So, be sure to share with others to help them work with Google Sheets.