The Google Sheets spreadsheet program in Google Workspace offers a wide range of useful features for your day-to-day business, from time recording to invoicing to project planning. All your spreadsheets are automatically linked to your Google account. That way, you have constant access to your files, even from your smartphone.
A variety of shortcuts make it easier to work with Google Sheets. In theory, you can even create and edit spreadsheets without a single click of the mouse. We’ve put together a list of the most useful keyboard shortcuts in Google Sheets. We’ll also show you how to access a menu of all shortcuts directly in Google Sheets. In this menu, you can search for specific keyboard shortcuts and enable compatible shortcuts from other spreadsheet programs (such as Microsoft Excel).
Register a domain name
Build your brand on a great domain, including SSL and a personal consultant!
Private registration24/7 supportEmailIn this guide, we’ll start by introducing you to the most useful Google Sheets keyboard shortcuts so you can edit and format your spreadsheets more easily on a PC or a Mac. Google Sheets also has keyboard shortcuts for navigating spreadsheets and using formulas. We've selected the most important ones for you.
Are you looking for a comprehensive office solution? With the Google Workspace solutions from IONOS, you get the full range of popular Google apps like Gmail, Google Calendar, Google Drive, Google Docs, and Google Sheets all in one package, including your own domain.
| Keyboard shortcuts for Windows | Keyboard shortcuts for Mac | |
|---|---|---|
| Select column | Ctrl + Space | Ctrl + Space |
| Select row | Shift + Space | Shift + Space |
| Select all | Ctrl + aCtrl + Shift + Space | ⌘ + a⌘ + Shift + Space |
| Undo | Ctrl + z | ⌘ + z |
| Redo | Ctrl + yCtrl + Shift + zF4 | ⌘ + y⌘ + Shift + zFn + F4 |
| Find | Ctrl + f | ⌘ + f |
| Find and replace | Ctrl + h | ⌘ + Shift + h |
| Fill range | Ctrl + Enter | ⌘ + Enter |
| Fill down | Ctrl + d | ⌘ + d |
| Fill right | Ctrl + r | ⌘ + r |
| Save (all changes are automatically saved in Google Drive) | Ctrl + s | ⌘ + s |
| Open | Ctrl + o | ⌘ + o |
| Ctrl + p | ⌘ + p | |
| Copy | Ctrl + c | ⌘ + c |
| Cut | Ctrl + x | ⌘ + x |
| Paste | Ctrl + v | ⌘ + v |
| Paste values only | Ctrl + Shift + v | ⌘ + Shift + v |
| Paste format only | Ctrl + Alt + v | ⌘ + Alt+ v |
| Show common keyboard shortcuts | Ctrl + / | ⌘ + / |
| Insert new sheet | Shift + F11 | Shift + Fn + F11 |
| Compact controls | Ctrl + Shift + f | Ctrl + Shift + f |
| Input tools on/off (available in spreadsheets in non-Latin languages) | Ctrl + Shift + k | ⌘ + Shift + k |
| Select input tools | Ctrl + Alt + Shift + k | ⌘ + Option + Shift + k |
| Search menus | Alt + / | Option + / |
| Keyboard shortcuts for Windows | Keyboard shortcuts for Mac | |
|---|---|---|
| Bold | Ctrl + b | ⌘ + b |
| Underline | Ctrl + u | ⌘ + u |
| Italic | Ctrl + i | ⌘ + i |
| Strikethrough | Alt + Shift + 5 | Option + Shift + 5 |
| Center align | Ctrl + Shift + e | ⌘ + Shift + e |
| Left align | Ctrl + Shift + l | ⌘ + Shift + l |
| Right align | Ctrl + Shift + r | ⌘ + Shift + r |
| Apply top border | Alt + Shift + 1 | Option + Shift + 1 |
| Apply right border | Alt + Shift + 2 | Option + Shift + 2 |
| Apply bottom border | Alt + Shift + 3 | Option + Shift + 3 |
| Apply left border | Alt + Shift + 4 | Option + Shift + 4 |
| Remove borders | Alt + Shift + 6 | Option + Shift + 6 |
| Apply outer border | Alt + Shift + 7Ctrl + Shift + 7 | Option + Shift + 7⌘ + Shift + 7 |
| Insert link | Ctrl + k | ⌘ + k |
| Insert time | Ctrl + Shift + ; | ⌘ + Shift + ; |
| Insert date | Ctrl + ; | ⌘ + ; |
| Insert date and time | Ctrl + Alt + Shift + ; | ⌘ + Option + Shift + ; |
| Format as decimal | Ctrl + Shift + 1 | Ctrl + Shift + 1 |
| Format as time | Ctrl + Shift + 2 | Ctrl + Shift + 2 |
| Format as date | Ctrl + Shift + 3 | Ctrl + Shift + 3 |
| Format as currency | Ctrl + Shift + 4 | Ctrl + Shift + 4 |
| Format as percentage | Ctrl + Shift + 5 | Ctrl + Shift + 5 |
| Format as exponent | Ctrl + Shift + 6 | Ctrl + Shift + 6 |
| Remove formatting | Ctrl + \ | ⌘ + \ |
| Keyboard shortcuts for Windows | Keyboard shortcuts for Mac | |
|---|---|---|
| Move to beginning of row | Home | Fn + Left arrow |
| Move to beginning of sheet | Ctrl + Home | ⌘ + Fn + Left arrow |
| Move to end of row | End | Fn + Right arrow |
| Move to end of sheet | Ctrl + End | ⌘ + Fn + Right arrow |
| Scroll to active cell | Ctrl + Backspace | ⌘ + Backspace |
| Move to next sheet | Alt + Down arrow | Option + Down arrow |
| Move to previous sheet | Alt + Up arrow | Option + Up arrow |
| Display list of sheets | Alt + Shift + k | Option + Shift + k |
| Open hyperlink | Alt + Enter | Option + Enter |
| Open Explore | Alt + Shift + x | Option + Shift + x |
| Go to side panel | Ctrl + Alt + .Ctrl + Alt + , | ⌘ + Option + .⌘ + Option + , |
| Move focus out of spreadsheet | Ctrl + Alt + Shift + m | Ctrl + ⌘ + Shift + m |
| Move focus to quicksum (when range of cells is selected) | Alt + Shift + q | Option + Shift + q |
| Move focus to popup (for links, bookmarks and images) | Hold Ctrl + Alt, press e then p | Hold Ctrl + ⌘, press e then p |
| Open drop-down menu on filtered cell | Ctrl + Alt + r | Ctrl + ⌘ + r |
| Open revision history | Ctrl + Alt + Shift + h | ⌘ + Option + Shift + h |
| Open chat inside the spreadsheet | Shift + Esc | Shift + Esc |
| Close drawing editor | Shift + Esc | ⌘ + EscShift + Esc |
| Keyboard shortcuts for Windows | Keyboard shortcuts for Mac | |
|---|---|---|
| Insert/edit note | Shift + F2 | Shift + F2 |
| Insert/edit comment | Ctrl + Alt + m | ⌘ + Option + m |
| Open comment discussion thread | Ctrl + Alt + Shift + a | ⌘ + Option + Shift + a |
| Enter current comment | Hold Ctrl + Alt, press e then c | Hold Ctrl + ⌘, press e then c |
| Move to next comment | Hold Ctrl + Alt, press n then c | Hold Ctrl + ⌘, press n then c |
| Move to previous comment | Hold Ctrl + Alt, press p then c | Hold Ctrl + ⌘, press p then c |
| Keyboard shortcuts for Windows | Keyboard shortcuts for Mac | |
|---|---|---|
| “File” menu | Google Chrome: Alt + fOther browsers: Alt + Shift + f | Ctrl + Option + f |
| “Edit” menu | Google Chrome: Alt + eOther browsers: Alt + Shift + e | Ctrl + Option + e |
| “View” menu | Google Chrome: Alt + vOther browsers: Alt + Shift + v | Ctrl + Option + v |
| “Insert” menu | Google Chrome: Alt + iOther browsers: Alt + Shift + i | Ctrl + Option + i |
| “Format” menu | Google Chrome: Alt + oOther browsers: Alt + Shift + o | Ctrl + Option + o |
| “Data” menu | Google Chrome: Alt + dOther browsers: Alt + Shift + d | Ctrl + Option + d |
| “Tools” menu | Google Chrome: Alt + tOther browsers: Alt + Shift + t | Ctrl + Option + t |
| Open “Insert” menu | Ctrl + Alt + Shift + = Ctrl + Alt + = (with cells selected) | ⌘ + Option + = (with cells selected) |
| Open “Delete” menu | Ctrl + Alt + - (with cells selected) | ⌘ + Option + - (with cells selected) |
| “Form” menu (visible when the spreadsheet is connected to a form) | Google Chrome: Alt + mOther browsers: Alt + Shift + m | Ctrl + Option + m |
| “Add-ons” menu | Google Chrome: Alt + nOther browsers: Alt + Shift + n | Ctrl + Option + n |
| “Help” menu | Google Chrome: Alt + hOther browsers: Alt + Shift + h | Ctrl + Option + h |
| “Accessibility” menu (visible when screen reader support is enabled) | Google Chrome: Alt + aOther browsers: Alt + Shift + a | Ctrl + Option + a |
| “Sheet” menu (copy, delete, and other sheet actions) | Alt + Shift + s | Option + Shift + s |
| “Context” menu | Ctrl + Shift + \ | ⌘ + Shift + \ |
| Keyboard shortcuts for Windows | Keyboard shortcuts for Mac | |
|---|---|---|
| Insert rows above | Ctrl + Alt + Shift + = Ctrl + Alt + = (with rows selected)Google Chrome: Alt + i, then rOther browsers: Alt + Shift + i, then r | ⌘ + Option + = (with rows selected)Ctrl + Option + i, then r |
| Insert rows below | Google Chrome: Alt + i, then WOther browsers: Alt + Shift + i, then w | Ctrl + Option + i, then b |
| Insert columns to the left | Ctrl + Alt + Shift + = Ctrl + Alt + = (with columns selected)Google Chrome: Alt + i, then cOther browsers: Alt + Shift + i, then c | ⌘ + Option + = (with columns selected)Ctrl + Option + i, then c |
| Insert columns to the right | Google Chrome: Alt + i, then oOther browsers: Alt + Shift + i, then o | Ctrl + Option + i, then o |
| Delete rows | Ctrl + Alt + - (with rows selected)Google Chrome: Alt + e, then dOther browsers: Alt + Shift + e, then d | ⌘ + Option + - (with rows selected)Ctrl + Option + e, then d |
| Delete columns | Ctrl + Alt + - (with columns selected)Google Chrome: Alt + e, then eOther browsers: Alt + Shift + e, then e | ⌘ + Option + - (with columns selected)Ctrl + Option + e, then e |
| Hide row | Ctrl + Alt + 9 | ⌘ + Option + 9 |
| Unhide row | Ctrl + Shift + 9 | ⌘ + Shift + 9 |
| Hide column | Ctrl + Alt + 0 | ⌘ + Option + 0 |
| Unhide column | Ctrl + Shift + 0 | ⌘ + Shift + 0 |
| Group rows or columns | Alt + Shift + Right arrow | Option + Shift + Right arrow |
| Ungroup rows or columns | Alt + Shift + Left arrow | Option + Shift + Left arrow |
| Expand grouped rows or columns | Alt + Shift + Down arrow | Option + Shift + Down arrow |
| Collapse grouped rows or columns | Alt + Shift + Up arrow | Option + Shift + Up arrow |
| Keyboard shortcuts for Windows | Keyboard shortcuts for Mac | |
|---|---|---|
| Show all formulas | Ctrl + ~ | Ctrl + ~ |
| Insert array formula | Ctrl + Shift + Enter | ⌘ + Shift + Enter |
| Collapse expanded array formula | Ctrl + e | ⌘ + e |
| Show/hide formula help (when entering a formula) | Shift + F1 | Shift + Fn + F1 |
| Full/compact formula help (when entering a formula) | F1 | Fn + F1 |
| Absolute/relative references (when entering a formula) | F4 | Fn + F4 |
| Toggle formula result previews (when entering a formula) | F9 | Fn + F9 |
| Resize formula bar (move up or down) | Ctrl + Up arrow or Ctrl + Down arrow | Ctrl + Option + Up arrow or Ctrl + Option + Down arrow |
| Keyboard shortcuts for Windows | Keyboard shortcuts for Mac | |
|---|---|---|
| Turn on screen reader support | Ctrl + Alt + z | ⌘ + Option + z |
| Read column | Ctrl + Alt + Shift + c | ⌘ + Option + Shift + c |
| Read row | Ctrl + Alt + Shift + r | ⌘ + Option + Shift + r |
You can view a list of all available keyboard shortcuts by pressing Ctrl + / (division sign in the number pad) on a PC or ⌘ + / on a Mac:
There are shortcut keys in many other office applications and in all operating systems. See our digital guide for articles about Google Docs shortcuts, Mac shortcuts, Word shortcuts, Photoshop shortcuts, PowerPoint shortcuts, Windows shortcuts, and Excel shortcuts.
At the bottom of the list of Google Sheets keyboard shortcuts, you’ll see the “Enable compatible spreadsheet shortcuts” toggle switch. When this switch is turned on, you can use familiar shortcuts from Excel and other spreadsheets in Google Sheets.
To view a list of available shortcuts, click the “View compatible shortcuts” link next to the switch.
HiDrive Cloud Storage with IONOS!
Based in Europe, HiDrive secures your data in the cloud so you can easily access it from any device!
Highly secureShared accessAvailable anywhere
Excel shortcuts enable you to carry out your work a lot faster, but you first have to learn them. We present you with 30 useful Excel key combinations that faciliate your daily work. From navigation, to inserting cells, to calculating totals. If there isn’t already a shortcut for a function you regularly use, you can easily create your own Excel shortcuts.
The Google Sheets Translate formula is a simple tool to automatically translate words and entire sentences within Google tables. The formula uses the tried-and-tested Google translator. So the range of languages available is rather extensive. For word documents, Google provides a similar function within Google Docs.
Google Docs is one of the most widely used collaborative tools for word processing. The program offers a number of practical shortcuts that allow you to create and edit documents more efficiently. We’ll show you the most important Google Docs shortcuts and how to view a list of all keyboard shortcuts directly in the Google tool with just a few clicks.
Provide powerful and reliable service to your clients with a web hosting package from IONOS.
View packages
