Keyboard Shortcuts in Google Sheets [Top 100]

The top 5 Best Keyboard Shortcuts in Google Sheets you should know:

Select All: Shortcut: Ctrl + A (Windows) or ⌘ + A (Mac): Selects all the data on the sheet, making it useful for quickly highlighting all the content in your document.
Undo: Shortcut: Ctrl + Z (Windows) or ⌘ + Z (Mac): Reverses the last action, allowing you to quickly correct mistakes or changes.
Redo: Shortcut: Ctrl + Y (Windows) or ⌘ + Y (Mac): Redoes any previously undone action, helping you reapply changes you may have reversed.
Cut: Shortcut: Ctrl + X (Windows) or ⌘ + X (Mac): Cuts the selected data from your sheet, allowing you to move it to another location or clipboard.
Paste: Shortcut: Ctrl + V (Windows) or ⌘ + V (Mac): Pastes the data you’ve copied or cut to the clipboard into your sheet, making it handy for quickly duplicating content

Learn more rotating options in the article below.

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.

Table of Contents

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.

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 + /

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

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

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

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

Frequently Asked Questions

Are the Keyboard Shortcuts in Google Data Studio Similar to Those in Google Sheets?

Yes, the keyboard shortcuts in Google Data Studio are similar to those in Google Sheets. Both platforms offer convenient shortcuts to navigate and perform tasks efficiently. If you’re already familiar with Google Sheets shortcuts, you’ll find it easy to adapt to using google data studio shortcuts as well.

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.