Use Google Sheets Shortcuts to Optimize Your Workflow in 2023
If I want to copy only the values returned by a formula in a cell, I need to do the following:
- Right-click on the cell with the formula and select Copy.
- Right-click on the target cell and select Paste special.
- Pick Paste values only on the sub-menu.
Alternatively, I can press Ctrl(or ⌘ for Mac)+c to copy and Ctrl(⌘)+Shift+v to paste values only. The alternative option is much faster since it’s implemented using Google Sheets shortcuts. They let you do a lot of manipulations in your spreadsheet without any mouse clicks. Read on to learn everything about these hotkeys to become a Google Sheets expert!
What are keyboard shortcuts for Google Sheets?
Google Sheets shortcuts are combinations of keys on the keyboard that let you perform specific spreadsheet tasks (navigate, edit, etc.) quickly. Everyone knows the basic shortcuts, such as Ctrl(⌘)+c to copy, Ctrl(⌘)+v to paste, Ctrl(⌘)+z to undo, and so on. Those work in Google Sheets as well. At the same time, there are plenty of others, which you can explore by pressing Ctrl(⌘)+/. This is the major hotkey that unfolds all the others you can use.
What are the compatible spreadsheet shortcuts and how do you enable them?
The compatible spreadsheet shortcuts are keyboard shortcuts used in another well known spreadsheet program – Microsoft Excel. If you enable them, you’ll get 134 additional shortcuts to streamline your workflow.
Note: Compatible spreadsheet shortcuts do not function on Mac.
Some of the compatible shortcuts duplicate the common hotkeys. For example, to paste values only, you can use a common shortcut Ctrl+Shift+v, as well as a compatible one – Alt+h,v,v.
Others are unique. For example, you can paste transposed only with compatible shortcuts – Alt+h,v,t or Alt+e,s,e.
To enable the compatible spreadsheet shortcuts, press Ctrl+/ and toggle them on.
Shortcuts on PC, Mac, and Chrome OS
To select a column, you need to press Ctrl+Space, and this shortcut works for PC, Mac, and Chrome OS. However, some shortcuts may differ a bit depending on the device you are using.
Mac users mostly need to replace the Ctrl key with Command (⌘), as well as Alt with Option (⌥), but it’s not a one-size-fits-all method. For example, it works for the Insert time shortcut:
For PC: Ctrl+Shift+;
For Mac: ⌘+Shift+;
But to Format as time, you can use the PC shortcut on your Mac without any changes:
Ctrl+Shift+2
Check out this spreadsheet with a detailed list of shortcuts for PC, Mac, and Chrome OS in one table.
Spreadsheet shortcuts on Android and iPhone/iPad
If you connect an external keyboard to your Android or iOS device, you’ll also be able to use a limited number of Google Sheets hotkeys (how many may depend on the keyboard and language you use). Check out the Google Support page for details.
Google Sheets shortcuts by category
Now, let’s have a look at what exactly you can do in your spreadsheet with a mouse unplugged or touchpad off.
Review and select commands shortcuts
| How to | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Insert a comment | Ctrl+Alt+m | Alt+r,c Alt+i,m |
| Open comment history | Ctrl+Alt+Shift+a | Alt+a,c,o Alt+r,a Alt+v,c |
| Spell check | F7 Alt+r,s Alt+t,s,s | |
| Select all | Ctrl+a Ctrl+Shift+Space | Ctrl+Shift+8 |
| Select a column | Ctrl+Space | |
| Select a row | Shift+Space |
Copy and paste commands shortcuts
| How to | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Copy | Ctrl+c Ctrl+Insert | Alt+h,c,c Alt+e,c |
| Copy down (fill down) | Ctrl+d | Alt+h,f,i,d Alt+e,i,d |
| Copy to the right (fill right) | Ctrl+r | Alt+h,f,i,r Alt+e,i,r |
| Copy to the range (fill range) | Ctrl+Enter | |
| Cut | Ctrl+x | Alt+h,x Alt+e,t |
| Paste | Ctrl+v Shift+Insert | Alt+h,v,p Alt+e,p |
| Paste format only | Ctrl+Alt+v | Alt+h,v,r |
| Paste values only | Ctrl+Shift+v | Alt+h,v,v |
| Paste formula only | Alt+h,v,f | |
| Paste all except borders | Alt+h,v,b Alt+e,s,b | |
| Paste column widths only | Alt+h,v,w | |
| Paste transposed | Alt+h,v,tAlt+e,s,e |
Edit commands shortcuts
| How to | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Edit the selected cell | F2 | |
| Open the Insert row/column menu | Ctrl+Alt+Shift+= Ctrl+Alt+= | Ctrl+Shift+= Ctrl+= Alt+h,i,i Alt+i,e |
| Insert one row above | Alt+h,i,r Alt+i,r | |
| Insert one row below | Alt+i,b | |
| Insert one column left | Alt+h,i,c Alt+i,c | |
| Insert one column right | Alt+i,o | |
| Insert a cell and shift down | Alt+i,d | |
| Open the Delete row/column menu | Ctrl+Alt+- | Ctrl+- Alt+h,d,d |
| Delete the current row | Alt+h,d,r Alt+e,d | |
| Delete the current column | Alt+h,d,c | |
| Delete values in the cell | Alt+h,e,c Alt+e,a,c Alt+e,v | |
| Insert current date | Ctrl+; | |
| Insert current time | Ctrl+Shift+; | |
| Insert current date and time | Ctrl+Alt+Shift+; | |
| Insert a link | Ctrl+k | Alt+n,i Alt+i,i Alt+i,k |
| Insert/edit a note | Shift+F2 | |
| Clear notes | Alt+h,e,m Alt+e,a,m | |
| Insert a checkbox | Alt+i,x | |
| Undo an action | Ctrl+z | Alt+2 Alt+e,u |
| Redo an action | Ctrl+y Ctrl+Shift+z F4 | Alt+3 Alt+e,r |
Sheet commands shortcuts
| How to | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Access the sheet menu | Alt+Shift+s | |
| Show sheet list | Shift+Alt+k | |
| Insert a new sheet | Shift+F11 | Alt+Shift+F1 Alt+h,i,s Alt+i,w Alt+i,s |
| Delete the current sheet | Alt+h,d,s Alt+e,l | |
| Hide the current sheet | Alt+h,o,u,s Alt+o,h |
Menus access shortcuts
Note: Menus access shortcuts work only if compatible spreadsheet shortcuts are disabled.
| How to access | Keyboard shortcut | Keyboard shortcut for Mac | Compatible keyboard shortcut |
|---|---|---|---|
| Context menu | Ctrl+Shift+\ Ctrl+Shift+x | Shift+F10 | |
| File menu | Alt+Shift+f Alt+f | Ctrl+Alt+f | |
| Edit menu | Alt+Shift+e Alt+e | Ctrl+Alt+e | |
| View menu | Alt+Shift+v Alt+v | Ctrl+Alt+v | |
| Insert menu | Alt+Shift+I Alt+I | ||
| Format menu | Alt+Shift+o Alt+o | Ctrl+Alt+o | Ctrl+1 |
| Data menu | Alt+Shift+d Alt+d | Ctrl+Alt+d | |
| Tools menu | Alt+Shift+t Alt+t | Ctrl+Alt+t | |
| Add-ons menu | Alt+Shift+n Alt+n | Ctrl+Alt+n | |
| Help menu | Alt+Shift+h Alt+h | Ctrl+Alt+z |
View commands shortcuts
| How to | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Show compact controls | Ctrl+Shift+f | |
| Hide selected columns | Ctrl+Alt+0 | Ctrl+0 Alt+h,o,u,c Alt+o,c,h |
| Hide selected rows | Ctrl+Alt+9 | Ctrl+9 Alt+h,o,u,r Alt+o,r,h |
| Unhide columns | Ctrl+Shift+0 | Alt+h,o,u,l Alt+o,c,u |
| Unhide rows | Ctrl+Shift+9 | Alt+h,o,u,o Alt+o,r,u |
| Show all formulas | Ctrl+` | Alt+m,h Alt+v,a |
| Show formula bar | Ctrl+Shift+u | Alt+w,v,f Alt+v,f |
| Show full screen | Ctrl+F1 Alt+v,u | |
| Show gridlines | Alt+w,v,g Alt+v,g |
Data commands shortcuts
| How to | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Insert a chart | Alt+F1 Alt+n,k Alt+i,h | |
| Protect a sheet | Alt+h,o,p Alt+r,p Alt+t,p Alt+t,t | |
| Sort range by the selected column (top to bottom) | Alt+h,s,s Alt+d,r | |
| Sort range by the selected column (bottom to top) | Alt+h,s,o Alt+d,t | |
| Sort range | Alt+h,s,u Alt+d,s | |
| Create a filter | Alt+h,s,f Alt+d,f | |
| Create a pivot table | Alt+n,v Alt+d,p | |
| Define a named range | Alt+m,n Alt+i,n Alt+d,n | |
| Clean up suggestions | Alt+a,y Alt+d,y | |
| Split text to columns | Alt+a,e Alt+d,e | |
| Remove duplicate rows | Alt+a,m Alt+d,m | |
| Apply Data Validation | Alt+a,v Alt+d,l Alt+d,v | |
| Freeze the first row | Alt+w,f,r Alt+v,r,o | |
| Freeze the first column | Alt+w,f,c Alt+v,r,l | |
| Freeze two first rows | Alt+v,r,w | |
| Freeze two first columns | Alt+v,r,m | |
| Freeze up to the current columns | Alt+v,r,p | |
| Unfreeze rows | Alt+v,r,r | |
| Unfreeze columns | Alt+v,r,c | |
| Trim whitespace | Alt+d,i |
Formatting commands shortcuts
| How to | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Align center | Ctrl+Shift+e | Alt+h,a,c Alt+o,a,c |
| Align left | Ctrl+Shift+l | Alt+h,a,l Alt+o,a,l |
| Align right | Ctrl+Shift+r | Alt+h,a,r Alt+o,a,r |
| Align top | Alt+h,a,t Alt+o,a,t | |
| Align middle | Alt+h,a,m Alt+o,a,m | |
| Align bottom | Alt+h,a,b Alt+o,a,b | |
| Apply top border | Alt+Shift+1 | Alt+h,b,p |
| Apply bottom border | Alt+Shift+3 | Alt+h,b,o |
| Apply left border | Alt+Shift+4 | Alt+h,b,l |
| Apply right border | Alt+Shift+2 | Alt+h,b,r |
| Apply outer border | Alt+Shift+7 Ctrl+Shift+7 | Alt+h,b,s |
| Apply all borders | Alt+h,b,a | |
| Remove borders | Alt+Shift+6 | Ctrl+Shift+- Alt+h,b,n |
| Apply Bold | Ctrl+b | Ctrl+2 Alt+h,1 Alt+o,b |
| Apply Italic | Ctrl+i | Ctrl+3 Alt+h,2 Alt+o,i |
| Apply Underline | Ctrl+u | Ctrl+4 Alt+h,3,u Alt+o,u |
| Alt+Shift+5 | Ctrl+5 Alt+o,k | |
| Wrap text | Alt+h,w Alt+o,w,w | |
| Merge cells horizontally | Alt+h,m,a Alt+o,m,h | |
| Merge all cells | Alt+h,m,m Alt+o,m,a | |
| Unmerge cells | Alt+h,m,u Alt+o,m,u | |
| Resize a row | Alt+h,o,a Alt+o,r,a | |
| Resize a column | Alt+h,o,i Alt+o,c,a | |
| Apply conditional formatting | Alt+h,l Alt+o,d Alt+o,f | |
| Clear formatting | Ctrl+/ | Alt+h,e,f Alt+e,a,f |
| Rotate text in the cell (tilt up) | Alt+h,f,q,o Alt+o,r,p | |
| Rotate text in the cell (tilt down) | Alt+h,f,q,l Alt+o,r,w | |
| Rotate text in the cell (stack vertically) | Alt+h,f,q,v Alt+o,r,v | |
| Rotate text in the cell (rotate up) | Alt+h,f,q,u | |
| Rotate text in the cell (rotate down) | Alt+h,f,q,d Alt+o,r,d |
| How to | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Find in the sheet | Ctrl+f | |
| Find and replace in the sheet | Ctrl+h | Alt+h,f,d,r Alt+e,e Alt+e,f |
| Move to the beginning of the sheet | Ctrl+Home | |
| Move to the end of the sheet | Ctrl+End | |
| Move to the next sheet | Ctrl+Shift+PageDown Alt+ArrowDown | |
| Move to the previous sheet | Ctrl+Shift+PageUp Alt+ArrowUp | |
| Move to the beginning of the row | Home | |
| Move to the end of the row | End | |
| Move to the next comment | Ctrl+Alt+n Ctrl+Alt+c | Alt+a,c,n |
| Move to the previous comment | Alt+a,c,p | |
| Open Explore | Alt+Shift+x | |
| Open Filter dropdown menu | Ctrl+Alt+r | |
| Scroll to the active cell | Ctrl+Backspace | |
| See all keyboard shortcuts | Ctrl+/ | |
| See version history | Ctrl+Alt+Shift+h | |
| Go to a specific range | F5 Alt+e,g | |
| Go to the Help Center | Shift+F1 | F1 |
Number format shortcuts
| How to apply | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Number format: automatic | Ctrl+Shift+` Alt+o,n,m | |
| Number format: plain text | Alt+o,n,x | |
| Number format: number | Ctrl+Shift+1 | Alt+h,k Alt+o,n,n |
| Number format: percent | Ctrl+Shift+5 | Alt+h,p Alt+o,n,p |
| Number format: scientific | Ctrl+Shift+6 | Alt+o,n,s |
| Number format: accounting | Alt+h,a,n Alt+o,n,a | |
| Number format: financial | Alt+o,n,f | |
| Number format: currency | Ctrl+Shift+4 | Alt+o,n,c |
| Number format: currency (rounded) | Alt+o,n,r | |
| Number format: date | Ctrl+Shift+3 | Alt+o,n,d |
| Number format: time | Ctrl+Shift+2 | Alt+o,n,t |
| Number format: date time | Alt+o,n,i | |
| Number format: duration | Alt+o,n,u | |
| Increase decimal places | Alt+h,0 | |
| Decrease decimal places | Alt+h,9 |
File commands shortcuts
| How to | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Open a file | Ctrl+o | Alt+f,o |
| Ctrl+p | Ctrl+F2 Alt+f,p | |
| Open a new spreadsheet | Alt+f,n Alt+w,n | |
| Share the spreadsheet | Alt+f,h Alt+t,b | |
| Open spreadsheet settings | Alt+f,t Alt+f,g |
Function commands shortcuts
| How to | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Set absolute/relative references in formula | F4 | |
| Insert the AVERAGE function | Alt+h,u,a Alt+m,u,a Alt+i,u,a | |
| Insert the COUNT function | Alt+h,u,c Alt+m,u,c Alt+i,u,c | |
| Insert the MAX function | Alt+h,u,m Alt+m,u,m Alt+i,u,m | |
| Insert the MIN function | Alt+h,u,i Alt+m,u,i Alt+i,u,i | |
| Insert the SUM function | Alt+h,u,s Alt+m,u,s Alt+i,u,s |
Grouping commands shortcuts
| How to | Keyboard shortcut |
|---|---|
| Group columns/rows | Alt+Shift+ArrowRight |
| Ungroup columns/rows | Alt+Shift+ArrowLeft |
| Expand grouped columns/rows | Alt+Shift+ArrowDown |
| Collapse grouped columns/rows | Alt+Shift+ArrowUp |
Screen reader support shortcuts
| How to | Keyboard shortcut | Compatible keyboard shortcut |
|---|---|---|
| Speak anchor | Ctrl+Alt+a | Alt+a,c,a |
| Speak column | Ctrl+Alt+Shift+c | Alt+a,s,l |
| Speak comment | Ctrl+Alt+a Ctrl+Alt+c | Alt+a,c,c |
| Speak row | Ctrl+Alt+Shift+r | Alt+a,s,r |
| Speak formatting | Alt+a,s,f | |
| Summarize chart content | Ctrl+Alt+Shift+v | |
| Toggle screen reader support | Ctrl+Alt+z |
Real-life use case: building a sales monitor with keyboard shortcuts only
Now we suggest you practice your shortcut skills. In the blog post How to Build Sales Tracker with Google Sheets, we’ve tailored an interactive sales monitor stuffed with numerous formulas, charts, data validation and other features. Let’s iterate some of the flow but with one requirement: your mouse will be unplugged or touchpad will be off. You’ll have your keyboard only to handle the challenge!
Step 1: Importing the raw data
The sales monitor will be powered by the data from Pipedrive, so let’s import it into Google Sheets first. For this, you’ll need to install Coupler.io, a GSheets add-on, and set up a Pipedrive importer.
Open a new spreadsheet
We’re on the spreadsheet with Google Sheets shortcuts descriptions. Let’s create a new one for the sales dashboard.
- Press Ctrl+/ and use Tab to select Enable compatible spreadsheet shortcuts.
- Once selected, press Space to toggle on compatible shortcuts and Esc to leave the window.
- Now, press Alt+f,n, and voila – a new spreadsheet has been created.
Rename the new spreadsheet
To access menus, we’ll need to disable the compatible spreadsheet shortcuts for a while. Press Ctrl+/ and use Tab to select Enable compatible spreadsheet shortcuts. Once selected, press Space to toggle them off and Esc to leave the shortcut window.
Press Alt+Shift+f to open the File menu and select Rename to specify the name of the new spreadsheet – for example, Sales monitor.
Install Coupler.io
Coupler.io is a tool that lets you integrate different apps and data sources with Google Sheets. Check out the available integrations.
Streamline your data analytics & reporting with Coupler.io!
Coupler.io is an all-in-one data analytics and automation platform designed to close the gap between getting data and using its full potential. Gather, transform, understand, and act on data to make better decisions and drive your business forward!
- Save hours of your time on data analytics by integrating business applications with data warehouses, data visualization tools, or spreadsheets. Enjoy 200+ available integrations!
- Preview, transform, and filter your data before sending it to the destination. Get excited about how easy data analytics can be.
- Access data that is always up to date by enabling refreshing data on a schedule as often as every 15 minutes.
- Visualize your data by loading it to BI tools or exporting it directly to Looker Studio. Making data-driven decisions has never been easier.
- Easily track and improve your business metrics by creating live dashboards on your own or with the help of our experts.
Try Coupler.io today at no cost with a 14-day free trial (no credit card required), and join 700,000+ happy users to accelerate growth with data-driven decisions.
Start 14-day free trialUsually, you can install Coupler.io from the G Suite Marketplace via this direct link. But, since we’re using the keyboard only, let’s install the add-on right from the spreadsheet.
Press Alt+Shift+n to open the Add-ons menu and select Get add-ons. Use Tab to select the search bar and find Coupler.io. A few more manipulations with Tab and Enter and you’ll see the add-on on your spreadsheet (it’s also available in the Add-ons menu).
Friendly note: it’s quite inconvenient to install add-ons using the keyboard only, so we recommend you do this with your mouse or touchpad 🙂
Set up a Pipedrive importer
We won’t stumble on how to set up a Pipedrive importer. The flow has been described in Export Data from Pipedrive to Google Sheets. You can also refer to the knowledge base for details. The main point is that you need to connect Coupler.io to your Pipedrive account and specify the data entity (Deals, Persons, or Organizations) you’re going to import. Besides, you can enable the automatic data refresh. This function imports data automatically on a set schedule!
Use Tab, Space and Enter buttons to set up the Pipedrive importer without a mouse or touchpad. It’s not very comfortable, but this is the challenge!
Run the importer when ready and welcome your data. For our sales monitor, we’ve imported Pipedrive deals.
Step 2: Building the sales dashboard using Google Sheets shortcuts
Create a new sheet for the dashboard
With the raw data in your spreadsheet, we can get to calculations. Let’s enable the compatible shortcuts (Ctrl+/=>Tab (three times)=>Space =>Esc) and jump to the sheet where the dashboard will be. Press Ctrl+Shift+PageDown or Ctrl+Shift+PageUp to navigate between your sheets.
Then press Alt+Shift+s to enter the Sheets menu. Choose Rename and type in the name you like. We picked “Dashboard”.
Calculations
We’re going to make a table consisting of three columns: Country Name, Conversion Rate and Total Revenue:
- Country Name – select a cell (A1) and type in the following formula:
={"Country name"; UNIQUE(Deals!Z2:Z)}
It will filter out all countries from your Pipedrive deals and attach the name to the column automatically.
- Conversion Rate – select the B1 cell and type in the column name: “Conversion Rate”. Select the B2 cell and apply the following formula:
=COUNTIF( Filter(Deals!$AL$2:$AL,Deals!$Z$2:$Z=A2),"won")/ COUNTA( Filter(Deals!$AL$2:$AL,Deals!$Z$2:$Z=A2) )
Now, select the B2 cell, hold Shift and select the cells down to the end of countries list. Then press Ctrl+d and the formulas will be applied to the rest of countries.
- Total Revenue – do the same trick for Total Revenue with the following formula:
=SUM( Filter(Deals!$AF$2:$AF,Deals!$Z$2:$Z=A2,Deals!$AL$2:$AL="won") )
Number format
We want the Conversion Rate to be shown in percent and the Total Revenue in US dollars. Here are the shortcuts meant to help with that:
- Select the B2 cell and press Ctrl+Shift+ArrowDown. This will select the data range to the end. Now press Ctrl+Shift+5 to apply the Percent format to the range.
- Select the C2 cell and press Ctrl+Shift+ArrowDown to select the data range. Press Alt+o,n,c or Ctrl+Shift+4 to apply the Currency format to the range.
Formatting the table
Now, let’s make our table look dainty. Select the A1 cell and press Ctrl+Shift+ArrowRight to select the cells with column names. Now, press Ctrb+b to make them Bold.
Press Ctrl+Shift+ArrowDown to select the entire table and then press Alt+h,b,a to apply borders.
Inserting a chart
We’re ready to insert a chart based on our table. For this, select any cell within the table range and press Ctrl+a to select all. Then press Alt+F1 (alternative shortcuts, Alt+n,k and Alt+i,h) to insert a chart. The shortcut worked and we’ve got the chart, but…
The only way to access the Chart editor was to press Fn+MenuKey. However, not all keyboards have this key and we failed to find another way to access the Chart editor. If you know it, please write in the comments.
To wrap up
We completed the challenge. Now we know that you should not reject pointing devices (mouse or touchpad) for complex tasks in spreadsheets. Some features like Chart Editor or Conditional Formatting are designed for click-based activities. From our experience, it was a pain to edit the chart with the keyboard only. As for the Google Sheets shortcuts, they can significantly speed up your workflow. However, for this, you need to keep specific hotkeys in your memory so you can apply them when necessary. We hope that our blog post will help you with that and Coupler.io will help you automate data import for your project. Good luck with your data!
