Keyboard Shortcuts in Google Sheets [Top 100]

google sheets keyboard shortcuts

In this article, we will learn about keyboard shortcuts in google sheets. All of us already know and use many keyboard shortcuts in google sheets. So we all know that keyboard shortcuts are really helpful to boost our productivity and save a lot of time and effort for us. This article is meant to explore many of the helpful keyboard shortcuts. Today I have brought you 100 keyboard shortcuts in google sheets. Many of you know many of them already, but still, there are plenty of new things for everyone in this article. So without further delay let’s move ahead and get into it.

Importance of Keyboard Shortcuts in Google Sheets

I think everyone knows the importance of keyboard shortcuts in google sheets, and in any other application either web-based or system based. We all love keyboard shortcuts, and we always look for a shortcut to perform a specific task instead of doing it manually by using a mouse click on various places on a specific position. So, there are still a lot of things you do manually in google sheets to date.

But after this article, you will not be using the mouse as much as you use currently it. I have 100 great keyboard shortcuts for you that are available for both windows and mac. So, as you know the importance of keyboard shortcuts, you don’t need further to know their importance, therefore, we need to know more and more about keyboard shortcuts in google sheets to improve our productivity and save time consumption.

See also  How to Make a Table in Google Sheets (Complete Guide)

Top 100 Keyboard Shortcuts in Google Sheets

Here we will see each shortcut, we will see the keys used for them in windows and Mac, and then we will also see the operations.

Keyboard Shortcuts in Google Sheets – General Shortcuts

 

Shortcut Function Windows MAC
Select All Selects all the data on the sheet Ctrl + a ⌘ + a

 

Shortcut Function Windows MAC
Select a column Selects the column of the cells you have selected. Ctrl +Space Ctrl + Space

 

Shortcut Function Windows MAC
Select a row Selects the row of the cells you have selected. Shift + space Shift + space

 

Shortcut Function Windows MAC
Redo Redo any task performed Ctrl + y ⌘ + y

 

Shortcut Function Windows MAC
Undo Undo any task performed Ctrl + z ⌘ + z

 

Shortcut Function Windows MAC
Find Find any supplied data in the sheet Ctrl + f ⌘ + f

 

Shortcut Function Windows MAC
Find and Replace Find the supplied data, and replace it with new data supplied Ctrl + h ⌘ + Shift + h

 

Shortcut Function Windows MAC
Save Saves all the changes Ctrl + s ⌘ + s

 

Shortcut Function Windows MAC
Open Opens the file Ctrl + o ⌘ + o

 

Shortcut Function Windows MAC
Print Opens the print window Ctrl + p ⌘ + p

 

Shortcut Function Windows MAC
Fill down Fills down the value or formula from the cell Ctrl + d ⌘ + d

 

Shortcut Function Windows MAC
Fill right Fills right the value or formula from the cell Ctrl + r ⌘ + r

 

Shortcut Function Windows MAC
Cut Cuts the selected data, and hold for one time paste Ctrl + x ⌘ + x

 

Shortcut Function Windows MAC
Copy Copies the selected data, and hold for unlimited times paste Ctrl + c ⌘ + c

 

Shortcut Function Windows MAC
Paste Pastes the copied or cut data Ctrl + v ⌘ + v

 

Shortcut Function Windows MAC
Paste values only Pastes only the values from the copied or cut data (do not paste formatting) Ctrl + Shift + v ⌘ + Shift + v

 

Shortcut Function Windows MAC
Open Keyboard shortcuts Open the keyboard shortcuts window Ctrl + / ⌘ + /

 

Shortcut Function Windows MAC
Compact Control Hide the main menus Ctrl + Shift + f Ctrl + Shift + f

 

Shortcut Function Windows MAC
Add new Sheet Adds a new sheet to an existing workbook Shift + F11 Shift + Fn + F11

 

Shortcut Function Windows MAC
Search the menus Opens a search box for searching the menus Alt + / Option + /
See also  How to Make a Scatter Plot in Google Sheets (Complete Guide)

 

Keyboard Shortcuts in Google Sheets – Formatting Shortcuts

 

Shortcut Function Windows MAC
Italic Converts the selection into italic Ctrl + i ⌘ + i

 

Shortcut Function Windows MAC
Bold Converts the selection into bold Ctrl + b ⌘ + b

 

Shortcut Function Windows MAC
Underline Adds underline below the selection Ctrl + u ⌘ + u

 

Shortcut Function Windows MAC
Strike-through Strikes-through over the selected text Alt + Shift + 5 Option + Shift + 5

 

Shortcut Function Windows MAC
Right align Align the selected cells or text to the right Ctrl + Shift + r ⌘ + Shift + r

 

Shortcut Function Windows MAC
Left align Align the selected cells or text to left Ctrl + Shift + l ⌘ + Shift + l

 

Shortcut Function Windows MAC
Center align Align the selected cells or text to the center Ctrl + Shift + e ⌘ + Shift +e

 

Shortcut Function Windows MAC
Add top border Adds a border to the top Alt + Shift + 1 Option + Shift + 1

 

Shortcut Function Windows MAC
Add right border Adds a border to the right Alt + Shift + 2 Option + Shift + 2

 

Shortcut Function Windows MAC
Add left border Adds a border to the left Alt + Shift + 4 Option + Shift + 4

 

Shortcut Function Windows MAC
Add bottom border Adds a border to the bottom Alt + Shift + 3 Option + Shift + 3

 

Shortcut Function Windows MAC
Remove all borders Removes all the borders from the selected cell/range Alt + Shift + 6 Option + Shift + 6

 

Shortcut Function Windows MAC
Add outer border Adds only outer border to selection Alt + Shift + 7 Option + Shift + 7

 

Shortcut Function Windows MAC
Insert date Insert current data in the cell Ctrl + ; ⌘ + ;

 

Shortcut Function Windows MAC
Insert time Insert current time in the cell Ctrl + Shift + ; ⌘ + Shift + ;

 

Shortcut Function Windows MAC
Insert date and time Insert current date and time in the cell Ctrl + Alt + Shift + ; ⌘ + Option + Shift + ;

 

Shortcut Function Windows MAC
Format as Decimal Formats the selection into decimal format Ctrl + Shift + 1 Ctrl + Shift + 1

 

Shortcut Function Windows MAC
Format as time Formats the selection into time format Ctrl + Shift + 2 Ctrl + Shift + 2

 

Shortcut Function Windows MAC
Format as date Formats the selection into date format Ctrl + Shift + 3 Ctrl + Shift + 3

 

Shortcut Function Windows MAC
Format as currency Formats the selection into currency format Ctrl + Shift + 4 Ctrl + Shift + 4

 

Shortcut Function Windows MAC
Format as Percentage Formats the selection into percentage format Ctrl + Shift + 5 Ctrl + Shift + 5

 

Shortcut Function Windows MAC
Format as exponent Formats the selection into an exponential format Ctrl + Shift + 6 Ctrl + Shift + 6

 

Shortcut Function Windows MAC
Clear formatting Removes all the formatting of the selected cell/range and set everything to default Ctrl + \ ⌘ + \

 

Shortcut Function Windows MAC
Insert Link Insert a link into the selected cell Ctrl + k ⌘ + k

 

See also  How to use SORTN Function in Google Sheets (Best Guide)

Keyboard Shortcuts in Google Sheets – Formula Related Shortcuts

 

Shortcut Function Windows MAC
Resize formula bar Add/remove line space in the formula bar fx Ctrl + Up / Ctrl + Down Ctrl + Option + Up / Ctrl + Option + Down

 

Shortcut Function Windows MAC
Toggle previews On/off formula results previews F9 Fn + F9

 

Shortcut Function Windows MAC
Reference conversion Change absolute to relative, or relative to absolute cell references F4 Fn + F4

 

Shortcut Function Windows MAC
Formula help Online help regarding the formula F1 Fn + F1

 

Shortcut Function Windows MAC
Show/hide formula help show or hide the formula help Shift + F1 Shift + Fn + F1

 

Shortcut Function Windows MAC
Collapse expanded array formula Collapses the expanded array formula in a shorter span Ctrl + e ⌘ + e

 

Shortcut Function Windows MAC
Insert array formula Insert an array formula Ctrl + Shift + Enter ⌘ + Shift + Enter

 

Shortcut Function Windows MAC
Show all formulas Shows all the formulas on the sheets instead of the results Ctrl + ~ Ctrl + ~

 

Keyboard Shortcuts in Google Sheets – Navigation Shortcuts

 

Shortcut Function Windows MAC
Move to start Moves cursor to the beginning of the line/row Home Fn + Left Arrow

 

Shortcut Function Windows MAC
Move to end Moves cursor to the end of the line/row End Fn + Right Arrow

 

Shortcut Function Windows MAC
Move to start to a sheet Moves you to the beginning of the sheet Ctrl + Home ⌘ + Fn + Left Arrow

 

Shortcut Function Windows MAC
Move to the end of the sheet Moves you to the end of the sheet Ctrl + End ⌘ + Fn + Right Arrow

 

 

Shortcut Function Windows MAC
Scroll active cell Scrolls down the active cell Ctrl + Backspace ⌘ + Backspace

 

Shortcut Function Windows MAC
Move to next Move you to the next sheet of the same workbook Alt + Down Arrow Option + Down Arrow

 

 

Shortcut Function Windows MAC
Move to previous Move you to the previous sheet of the same workbook Alt + Up Arrow Option + Up Arrow

 

 

Shortcut Function Windows MAC
Display sheets Displays the list of all the sheets Alt + Shift + k ⌘ + a

 

Shortcut Function Windows MAC
Open Link Open a hyperlink into the default browser Alt + Enter Option + Enter

 

Shortcut Function Windows MAC
Go to the side panel Goes to the side panel Ctrl + Alt + . ⌘ + Option + .

 

 

Shortcut Function Windows MAC
Focus out Move focus out Ctrl + Alt + Shift + m Ctrl + ⌘ + Shift + m

 

 

Shortcut Function Windows MAC
Quick sum move to a quick sum Alt + Shift + q Option + Shift + q

 

 

Shortcut Function Windows MAC
Focus to pop-up Move focus to pop-up holding Ctrl + Alt, press e then p holding Ctrl + ⌘, press e then p

 

 

Shortcut Function Windows MAC
Version History Opens the version history Ctrl + Alt + Shift + h ⌘ + Option + Shift + h

 

See also  How to Use VLOOKUP in Google Sheets (User Guide)

 

Keyboard Shortcuts in Google Sheets – Edit, Notes, and Comment Shortcuts

 

Shortcut Function Windows MAC
Insert note Inserts or edit a note Shift + F2 Shift + F2

 

Shortcut Function Windows MAC
Insert comment Inserts or edit a comment Ctrl + Alt + m ⌘ + Option + m

 

 

Shortcut Function Windows MAC
Open comments Opens the thread of the comments Ctrl + Alt + Shift + a ⌘ + Option + Shift + a

 

 

Shortcut Function Windows MAC
Enter comment Enters the current comment holding Ctrl + Alt, press e then c holding Ctrl + ⌘, press e then c

 

 

Shortcut Function Windows MAC
Jump to next Jump to the next comment holding Ctrl + Alt, press n then c holding Ctrl + ⌘, press n then c

 

 

Shortcut Function Windows MAC
Jump to previous Moves back to the previous comment holding Ctrl + Alt, press p then c holding Ctrl + ⌘, press p then c

 

 

Keyboard Shortcuts in Google Sheets – Menu Shortcuts

 

Shortcut Function Windows MAC
File menu Opens file menu Alt + f Ctrl + Option + f

 

 

Shortcut Function Windows MAC
Edit menu Opens edit menu  Alt + e Ctrl + Option + e

 

 

Shortcut Function Windows MAC
View menu Opens view menu Alt + v Ctrl + Option + v

 

 

Shortcut Function Windows MAC
Insert menu On/off formula results previews Alt + i Ctrl + Option + i

 

 

Shortcut Function Windows MAC
Format menu Opens the format menu Alt + o Ctrl + Option + o

 

 

Shortcut Function Windows MAC
Data menu Opens the data menu Alt + d Ctrl + Option + d

 

 

Shortcut Function Windows MAC
Tools menu Opens the tool menu Alt + t Ctrl + Option + t

 

 

Shortcut Function Windows MAC
Extensions menu Opens the extensions menu Alt + n Ctrl + Option + n

 

 

Shortcut Function Windows MAC
Help menu Opens the help menu Alt + h Ctrl + Option + h

 

 

Shortcut Function Windows MAC
Sheet menu Opens the sheet menu Alt + Shift + s Option + Shift + s

 

 

Shortcut Function Windows MAC
Context menu Opens the context menu Ctrl + Shift + \ ⌘ + Shift + \

 

Shortcut Function Windows MAC
Accessibility menu Opens the accessibility menu  Alt + a Ctrl + Option + a
See also  How to Find Absolute Value in Google Sheets (4 Methods)

 

Keyboard Shortcuts in Google Sheets – Rows and Columns Shortcuts

 

Shortcut Function Windows MAC
Insert row below Inserts a row below to a selection Alt + I, then w Ctrl + Option + i, then b

 

Shortcut Function Windows MAC
Insert row above Inserts a row above to selection Alt + I, then r Ctrl + Option + i, then r

 

 

Shortcut Function Windows MAC
Insert row left Insert a row left to selection Alt + I, then c Ctrl + Option + i, then c

 

Shortcut Function Windows MAC
Insert row right Inserts a row right to selection Alt + I, then o Ctrl + Option + i, then o

 

Shortcut Function Windows MAC
Delete rows Deletes the selected rows Ctrl + Alt + – (with rows selected) ⌘ + Option + –

 

 

Shortcut Function Windows MAC
Delete columns Deletes the selected columns Ctrl + Alt + – (with columns selected) ⌘ + Option + –

 

 

Shortcut Function Windows MAC
Hide column Hides the selected column Ctrl + Alt + 0 ⌘ + Option + 0

 

Shortcut Function Windows MAC
Unhide column Unhides selected column Ctrl + Shift + 0 ⌘ + Shift + 0

 

 

Shortcut Function Windows MAC
Hide row Hides the selected row Ctrl + Alt + 9 ⌘ + Option + 9

 

 

Shortcut Function Windows MAC
Unhide row Unhides the selected tow Ctrl + Shift + 9 ⌘ + Shift + 9

 

Shortcut Function Windows MAC
Group row / column Groups the selected rows or columns Alt + Shift + Right Arrow Option + Shift + Right Arrow

 

 

Shortcut Function Windows MAC
Ungroup row/column Ungroups the selected rows or columns Alt + Shift + Left Arrow Option + Shift + Left Arrow

 

 

Shortcut Function Windows MAC
Expand Expand grouped rows or columns Alt + Shift + Down Arrow Option + Shift + Down Arrow

 

 

Shortcut Function Windows MAC
Collapse Collapse grouped rows or columns Alt + Shift + Up Arrow Option + Shift + Up Arrow

 

Conclusion

Wrapping up keyboard shortcuts in google sheets. We have seen many categories and learned various very frequently used and normally used keyboard shortcuts in google sheets. I have used keys for both windows and mac as the top operating systems right now.

I hope you have got all the shortcuts and you’re improving your productivity. I hope you find this article helpful. Thank you so much for reading. Keep learning with Office demy.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

OfficeDemy.com
Logo
Enable registration in settings - general