Can you create keyboard shortcuts in Google Sheets?

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!

Table of Contents

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 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 toKeyboard
shortcutCompatible
keyboard shortcutInsert a commentCtrl+Alt+mAlt+r,c
Alt+i,mOpen comment historyCtrl+Alt+Shift+aAlt+a,c,o
Alt+r,a
Alt+v,cSpell checkF7
Alt+r,s
Alt+t,s,sSelect allCtrl+a
Ctrl+Shift+SpaceCtrl+Shift+8Select a columnCtrl+SpaceSelect a rowShift+Space

Copy and paste commands shortcuts

How toKeyboard
shortcutCompatible
keyboard shortcutCopyCtrl+c
Ctrl+InsertAlt+h,c,c
Alt+e,cCopy down (fill down)Ctrl+dAlt+h,f,i,d
Alt+e,i,dCopy to the right (fill right)Ctrl+rAlt+h,f,i,r
Alt+e,i,rCopy to the range (fill range)Ctrl+EnterCutCtrl+xAlt+h,x
Alt+e,tPasteCtrl+v
Shift+InsertAlt+h,v,p
Alt+e,pPaste format onlyCtrl+Alt+vAlt+h,v,rPaste values onlyCtrl+Shift+vAlt+h,v,vPaste formula onlyAlt+h,v,fPaste all except bordersAlt+h,v,b
Alt+e,s,bPaste column widths onlyAlt+h,v,wPaste transposedAlt+h,v,tAlt+e,s,e

Edit commands shortcuts

How toKeyboard
shortcutCompatible
keyboard shortcutEdit the selected cellF2Open the Insert row/column menuCtrl+Alt+Shift+=
Ctrl+Alt+=Ctrl+Shift+=
Ctrl+=
Alt+h,i,i
Alt+i,eInsert one row aboveAlt+h,i,r
Alt+i,rInsert one row belowAlt+i,bInsert one column leftAlt+h,i,c
Alt+i,cInsert one column rightAlt+i,oInsert a cell and shift downAlt+i,dOpen the Delete row/column menuCtrl+Alt+-Ctrl+-
Alt+h,d,dDelete the current rowAlt+h,d,r
Alt+e,dDelete the current columnAlt+h,d,cDelete values in the cellAlt+h,e,c
Alt+e,a,c
Alt+e,vInsert current dateCtrl+;Insert current timeCtrl+Shift+;Insert current date and timeCtrl+Alt+Shift+;Insert a linkCtrl+kAlt+n,i
Alt+i,i
Alt+i,kInsert/edit a noteShift+F2Clear notesAlt+h,e,m
Alt+e,a,mInsert a checkboxAlt+i,xUndo an actionCtrl+zAlt+2
Alt+e,uRedo an actionCtrl+y
Ctrl+Shift+z
F4Alt+3
Alt+e,r

Sheet commands shortcuts

How toKeyboard
shortcutCompatible
keyboard shortcutAccess the sheet menuAlt+Shift+sShow sheet listShift+Alt+kInsert a new sheetShift+F11Alt+Shift+F1
Alt+h,i,s
Alt+i,w
Alt+i,sDelete the current sheetAlt+h,d,s
Alt+e,lHide the current sheetAlt+h,o,u,s
Alt+o,h

Menus access shortcuts

Note: Menus access shortcuts work only if compatible spreadsheet shortcuts are disabled.

How to
accessKeyboard
shortcutKeyboard
shortcut
for MacCompatible
keyboard
shortcutContext menuCtrl+Shift+\
Ctrl+Shift+xShift+F10File menuAlt+Shift+f
Alt+fCtrl+Alt+fEdit menuAlt+Shift+e
Alt+eCtrl+Alt+eView menuAlt+Shift+v
Alt+vCtrl+Alt+vInsert menuAlt+Shift+I
Alt+IFormat menuAlt+Shift+o
Alt+oCtrl+Alt+oCtrl+1Data menuAlt+Shift+d
Alt+dCtrl+Alt+dTools menuAlt+Shift+t
Alt+tCtrl+Alt+tAdd-ons menuAlt+Shift+n
Alt+nCtrl+Alt+nHelp menuAlt+Shift+h
Alt+hCtrl+Alt+z

View commands shortcuts

How toKeyboard
shortcutCompatible
keyboard shortcutShow compact controlsCtrl+Shift+fHide selected columnsCtrl+Alt+0Ctrl+0
Alt+h,o,u,c
Alt+o,c,hHide selected rowsCtrl+Alt+9Ctrl+9
Alt+h,o,u,r
Alt+o,r,hUnhide columnsCtrl+Shift+0Alt+h,o,u,l
Alt+o,c,uUnhide rowsCtrl+Shift+9Alt+h,o,u,o
Alt+o,r,uShow all formulasCtrl+`Alt+m,h
Alt+v,aShow formula barCtrl+Shift+uAlt+w,v,f
Alt+v,fShow full screenCtrl+F1
Alt+v,uShow gridlinesAlt+w,v,g
Alt+v,g

Data commands shortcuts

How toKeyboard
shortcutCompatible
keyboard shortcutInsert a chartAlt+F1
Alt+n,k
Alt+i,hProtect a sheetAlt+h,o,p
Alt+r,p
Alt+t,p
Alt+t,tSort range by the selected column
(top to bottom)Alt+h,s,s
Alt+d,rSort range by the selected column
(bottom to top)Alt+h,s,o
Alt+d,tSort rangeAlt+h,s,u
Alt+d,sCreate a filterAlt+h,s,f
Alt+d,fCreate a pivot tableAlt+n,v
Alt+d,pDefine a named rangeAlt+m,n
Alt+i,n
Alt+d,nClean up suggestionsAlt+a,y
Alt+d,ySplit text to columnsAlt+a,e
Alt+d,eRemove duplicate rowsAlt+a,m
Alt+d,mApply Data ValidationAlt+a,v
Alt+d,l
Alt+d,vFreeze the first rowAlt+w,f,r
Alt+v,r,oFreeze the first columnAlt+w,f,c
Alt+v,r,lFreeze two first rowsAlt+v,r,wFreeze two first columnsAlt+v,r,mFreeze up to the current columnsAlt+v,r,pUnfreeze rowsAlt+v,r,rUnfreeze columnsAlt+v,r,cTrim whitespaceAlt+d,i

Formatting commands shortcuts

How toKeyboard
shortcutCompatible
keyboard shortcutAlign centerCtrl+Shift+eAlt+h,a,c
Alt+o,a,cAlign leftCtrl+Shift+lAlt+h,a,l
Alt+o,a,lAlign rightCtrl+Shift+rAlt+h,a,r
Alt+o,a,rAlign topAlt+h,a,t
Alt+o,a,tAlign middleAlt+h,a,m
Alt+o,a,mAlign bottomAlt+h,a,b
Alt+o,a,bApply top borderAlt+Shift+1Alt+h,b,pApply bottom borderAlt+Shift+3Alt+h,b,oApply left borderAlt+Shift+4Alt+h,b,lApply right borderAlt+Shift+2Alt+h,b,rApply outer borderAlt+Shift+7
Ctrl+Shift+7Alt+h,b,sApply all bordersAlt+h,b,aRemove bordersAlt+Shift+6Ctrl+Shift+-
Alt+h,b,nApply BoldCtrl+bCtrl+2
Alt+h,1
Alt+o,bApply ItalicCtrl+iCtrl+3
Alt+h,2
Alt+o,iApply UnderlineCtrl+uCtrl+4
Alt+h,3,u
Alt+o,uApply StrikethroughAlt+Shift+5Ctrl+5
Alt+o,kWrap textAlt+h,w
Alt+o,w,wMerge cells horizontallyAlt+h,m,a
Alt+o,m,hMerge all cellsAlt+h,m,m
Alt+o,m,aUnmerge cellsAlt+h,m,u
Alt+o,m,uResize a rowAlt+h,o,a
Alt+o,r,aResize a columnAlt+h,o,i
Alt+o,c,aApply conditional formattingAlt+h,l
Alt+o,d
Alt+o,fClear formattingCtrl+/Alt+h,e,f
Alt+e,a,fRotate text in the cell (tilt up)Alt+h,f,q,o
Alt+o,r,pRotate text in the cell (tilt down)Alt+h,f,q,l
Alt+o,r,wRotate text in the cell (stack vertically)Alt+h,f,q,v
Alt+o,r,vRotate text in the cell (rotate up)Alt+h,f,q,uRotate text in the cell (rotate down)Alt+h,f,q,d
Alt+o,r,d

Navigation commands shortcuts

How toKeyboard
shortcutCompatible
keyboard shortcutFind in the sheetCtrl+fFind and replace in the sheetCtrl+hAlt+h,f,d,r
Alt+e,e
Alt+e,fMove to the beginning of the sheetCtrl+HomeMove to the end of the sheetCtrl+EndMove to the next sheetCtrl+Shift+PageDown
Alt+ArrowDownMove to the previous sheetCtrl+Shift+PageUp
Alt+ArrowUpMove to the beginning of the rowHomeMove to the end of the rowEndMove to the next commentCtrl+Alt+n
Ctrl+Alt+cAlt+a,c,nMove to the previous commentAlt+a,c,pOpen ExploreAlt+Shift+xOpen Filter dropdown menuCtrl+Alt+rScroll to the active cellCtrl+BackspaceSee all keyboard shortcutsCtrl+/See version historyCtrl+Alt+Shift+hGo to a specific rangeF5
Alt+e,gGo to the Help CenterShift+F1F1

Number format shortcuts

How to applyKeyboard
shortcutCompatible
keyboard shortcutNumber format: automaticCtrl+Shift+`
Alt+o,n,mNumber format: plain textAlt+o,n,xNumber format: numberCtrl+Shift+1Alt+h,k
Alt+o,n,nNumber format: percentCtrl+Shift+5Alt+h,p
Alt+o,n,pNumber format: scientificCtrl+Shift+6Alt+o,n,sNumber format: accountingAlt+h,a,n
Alt+o,n,aNumber format: financialAlt+o,n,fNumber format: currencyCtrl+Shift+4Alt+o,n,cNumber format: currency (rounded)Alt+o,n,rNumber format: dateCtrl+Shift+3Alt+o,n,dNumber format: timeCtrl+Shift+2Alt+o,n,tNumber format: date timeAlt+o,n,iNumber format: durationAlt+o,n,uIncrease decimal placesAlt+h,0Decrease decimal placesAlt+h,9

File commands shortcuts

How toKeyboard
shortcutCompatible
keyboard shortcutOpen a fileCtrl+oAlt+f,oPrintCtrl+pCtrl+F2
Alt+f,pOpen a new spreadsheetAlt+f,n
Alt+w,nShare the spreadsheetAlt+f,h
Alt+t,bOpen spreadsheet settingsAlt+f,t
Alt+f,g

Function commands shortcuts

How toKeyboard
shortcutCompatible
keyboard shortcutSet absolute/relative references in formulaF4Insert the AVERAGE functionAlt+h,u,a
Alt+m,u,a
Alt+i,u,aInsert the COUNT functionAlt+h,u,c
Alt+m,u,c
Alt+i,u,cInsert the MAX functionAlt+h,u,m
Alt+m,u,m
Alt+i,u,mInsert the MIN functionAlt+h,u,i
Alt+m,u,i
Alt+i,u,iInsert the SUM functionAlt+h,u,s
Alt+m,u,s
Alt+i,u,s

Grouping commands shortcuts

How toKeyboard shortcutGroup columns/rowsAlt+Shift+ArrowRightUngroup columns/rowsAlt+Shift+ArrowLeftExpand grouped columns/rowsAlt+Shift+ArrowDownCollapse grouped columns/rowsAlt+Shift+ArrowUp

Screen reader support shortcuts

How toKeyboard
shortcutCompatible
keyboard shortcutSpeak anchorCtrl+Alt+aAlt+a,c,aSpeak columnCtrl+Alt+Shift+cAlt+a,s,lSpeak commentCtrl+Alt+a
Ctrl+Alt+cAlt+a,c,cSpeak rowCtrl+Alt+Shift+rAlt+a,s,rSpeak formattingAlt+a,s,fSummarize chart contentCtrl+Alt+Shift+vToggle screen reader supportCtrl+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. Here is a link to it.

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. 

Usually, 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!   

How do I add a keyboard shortcut to Google Sheets?

How do I create a key code for Google Sheets?

How do I create my own keyboard shortcuts?