Google Sheets Keyboard Shortcuts for Windows and Mac

Google sheets are a great way to keep track of information and are especially helpful for those who are visual learners. Google sheets can be used for a variety of purposes, from tracking expenses to organizing a grocery list. The best part about Google sheets is that they can be accessed from anywhere, at any time.

However, the Google sheets user interface can be a bit daunting for those who are new to it. This is where keyboard shortcuts come in handy. By using keyboard shortcuts, users can quickly and easily navigate the Google sheets interface without having to take their hands off the keyboard.

In this article, we will provide a list of keyboard shortcuts for both Windows and Mac users that will help make your Google sheets experience more efficient and enjoyable.

Contents

Google Sheets Shortcuts for Windows and Mac Users

Are you a heavy Google Sheets user? If you are, you probably know there are plenty of keyboard shortcuts that can make your life a lot easier.

But did you know there are different keyboard shortcuts for Windows and Mac users? That’s right, the keys are different depending on what operating system you’re using.

So, if you want to make the most out of Google Sheets, it’s important to know the keyboard shortcuts for both Windows and Mac.

Here are the most important Google Sheets keyboard shortcuts for Windows and Mac users:

Google Sheets Common Shortcuts for Windows

If you are a Windows user, you may be surprised to learn that there are some useful shortcuts that can make using Google Sheets a lot easier. Here are a few of the most useful ones:

WINDOWSACTION
Alt + /Search the menus
Ctrl + /Show keyboard shortcuts
Ctrl + ASelect all
Ctrl + Alt + Shift + KSelect input tools
Ctrl + CCopy
Ctrl + DFill down
Ctrl + EnterFill range
Ctrl + FFind
Ctrl + HFind and replace
Ctrl + OOpen
Ctrl + PPrint
Ctrl + RFill right
Ctrl + Shift + FCompact controls
Ctrl + Shift + KInput tools on/off
Ctrl + Shift + VPaste values only
Ctrl + SpaceSelect column
Ctrl + VPaste
Ctrl + XCut
Ctrl + YRedo
Ctrl + ZUndo
Shift + F11Insert new sheet
Shift + SpaceSelect row

Google Sheets Common Shortcuts for Mac

If you’re a Mac user and you use Google Sheets, you’re in luck. There are a number of shortcuts that can make using Google Sheets on a Mac much easier and faster. Here are some of the most useful shortcuts for Mac users:

MACACTION
Option + /Search the menus
⌘ + /Show keyboard shortcuts
⌘ + ASelect all
⌘ + Option + Shift + KSelect input tools
⌘ + CCopy
⌘ + DFill down
⌘ + EnterFill range
⌘ + FFind
⌘ + Shift + HFind and replace
⌘ + OOpen
⌘ + PPrint
⌘ + RFill right
Ctrl + Shift + FCompact controls
⌘ + Shift + KInput tools on/off
⌘ + Shift + VPaste values only
Ctrl + SpaceSelect column
⌘ + VPaste
⌘ + XCut
⌘ + YRedo
⌘ + ZUndo
Shift + Fn + F11Insert new sheet
Shift + SpaceSelect row

Google Sheets Navigation Shortcuts

A shortcut is the best way to navigate Google Sheets faster. There are a number of navigation shortcuts that can help you get around Google Sheets quickly and easily.

Here are some of the most useful Google Sheets navigation shortcuts for Windows and Mac:

WINDOWSMACACTION
Alt + Down arrowOption + Down arrowMove to the next sheet
Alt + EnterOption + EnterOpen hyperlink
Alt + Shift + 1Option + Shift + 1Apply top border
Alt + Shift + 2Option + Shift + 2Apply right border
Alt + Shift + 3Option + Shift + 3Apply bottom border
Alt + Shift + 4Option + Shift + 4Apply left border
Alt + Shift + 5Option + Shift + 5Strikethrough
Alt + Shift + 6Option + Shift + 6Remove borders
Alt + Shift + 7Option + Shift + 7Apply outer border
Alt + Shift + KOption + Shift + KDisplay a list of sheets
Alt + Shift + QOption + Shift + QMove to a quick sum
Alt + Shift + XOption + Shift + XOpen Explore
Alt + Up arrowOption + Up arrowMove to the previous sheet
Ctrl + ;⌘ + ;Insert date
Ctrl + \⌘ + \Clear formatting
Ctrl + Alt + .⌘ + Option + .Go to a side panel
Ctrl + Alt + RCtrl + ⌘ + RAn open drop-down menu on filtered cell
Ctrl + Alt + Shift + ;⌘ + Option + Shift + ;Insert date and time
Ctrl + Alt + Shift + H⌘ + Option + Shift + HOpen revision history
Ctrl + Alt + Shift + MCtrl + ⌘ + Shift + MMove focus off a spreadsheet
Ctrl + B⌘ + BBold
Ctrl + Backspace⌘ + BackspaceScroll to an active cell
Ctrl + End⌘ + Fn + Right arrowMove to the end of a sheet
Ctrl + Home⌘ + Fn + Left arrowMove to begin of sheet
Ctrl + I⌘ + IItalic
Ctrl + K⌘ + KInsert link
Ctrl + Shift + ;⌘ + Shift + ;Insert time
Ctrl + Shift + 1Ctrl + Shift + 1Format as decimal
Ctrl + Shift + 2Ctrl + Shift + 2Format as time
Ctrl + Shift + 3Ctrl + Shift + 3Format as date
Ctrl + Shift + 4Ctrl + Shift + 4Format as currency
Ctrl + Shift + 5Ctrl + Shift + 5Format as Percentage
Ctrl + Shift + 6Ctrl + Shift + 6Format as exponent
Ctrl + Shift + E⌘ + Shift + ECenter align
Ctrl + Shift + L⌘ + Shift + LLeft align
Ctrl + Shift + R⌘ + Shift + RRight align
Ctrl + U⌘ + UUnderline
EndFn + Right arrowMove to the end of the row

Google Sheets Formatting Shortcuts

The windows and mac users, the best ways to save time when formatting on Google Spreadsheets. Here, you’ll be happy to know that there are several shortcuts you can use to speed up the process.

WINDOWSMACACTION
Alt + Shift + 1Option + Shift + 1Apply top border
Alt + Shift + 2Option + Shift + 2Apply right border
Alt + Shift + 3Option + Shift + 3Apply bottom border
Alt + Shift + 4Option + Shift + 4Apply left border
Alt + Shift + 5Option + Shift + 5Strikethrough
Alt + Shift + 6Option + Shift + 6Remove borders
Alt + Shift + 7Option + Shift + 7Apply outer border
Ctrl + ;⌘ + ;Insert date
Ctrl + \⌘ + \Clear formatting
Ctrl + Alt + Shift + ;⌘ + Option + Shift + ;Insert date and time
Ctrl + B⌘ + BBold
Ctrl + I⌘ + IItalic
Ctrl + K⌘ + KInsert link
Ctrl + Shift + ;⌘ + Shift + ;Insert time
Ctrl + Shift + 1Ctrl + Shift + 1Format as decimal
Ctrl + Shift + 2Ctrl + Shift + 2Format as time
Ctrl + Shift + 3Ctrl + Shift + 3Format as date
Ctrl + Shift + 4Ctrl + Shift + 4Format as currency
Ctrl + Shift + 5Ctrl + Shift + 5Format as Percentage
Ctrl + Shift + 6Ctrl + Shift + 6Format as exponent
Ctrl + Shift + E⌘ + Shift + ECenter align
Ctrl + Shift + L⌘ + Shift + LLeft align
Ctrl + Shift + R⌘ + Shift + RRight align
Ctrl + U⌘ + UUnderline

Google Sheets Menu Shortcuts

The Google Sheets Menu Shortcuts for Windows and Mac can help users quickly access some of the most commonly used sheet commands. To access the menu shortcuts, simply press the keyboards as given below:

WINDOWSMACACTION
Alt + A (Chrome) / Alt + Shift + ACtrl + Option + AAccessibility menu
Alt + D (Chrome) / Alt + Shift + DCtrl + Option + DData menu
Alt + E (Chrome) / Alt + Shift + ECtrl + Option + EEdit menu
Alt + F (Chrome) / Alt + Shift + FCtrl + Option + FFile menu
Alt + H (Chrome) / Alt + Shift + HCtrl + Option + HHelp menu
Alt + I (Chrome) / Alt + Shift + ICtrl + Option + IInsert menu
Alt + M (Chrome) / Alt + Shift + MCtrl + Option + MForm menu
Alt + N (Chrome) / Alt + Shift + NCtrl + Option + NAdd-ons menu
Alt + O (Chrome) / Alt + Shift + OCtrl + Option + OFormat menu
Alt + Shift + SOption + Shift + SSheet menu
Alt + T (Chrome) / Alt + Shift + TCtrl + Option + TTools menu
Alt + V (Chrome) / Alt + Shift + VCtrl + Option + VView menu
Ctrl + Alt + –⌘ + Option + –Open delete menu
Ctrl + Alt + Shift + =⌘ + Option + =Open insert menu
Ctrl + Shift + \⌘ + Shift + \Context menu

Google Sheets Formulas Shortcuts

This is a great way to use google sheets formulas shortcuts for windows and mac. There are many ways that you can use these shortcuts to make your work easier and faster. The formula shortcuts are as follows:

WINDOWSMACACTION
Ctrl + ~Ctrl + ~Show all formulas
Ctrl + E⌘ + ECollapse an expanded array formula
Ctrl + Shift + Enter⌘ + Shift + EnterInsert array formula
Ctrl + Up / Ctrl + Down arrowCtrl + Option + Up / Ctrl + Option + Down arrowResize formula bar
F1Fn + F1Full/compact formula help
F4Fn + F4Absolute/relative references
F9Fn + F9Toggle formula result previews
Shift + F1Shift + Fn + F1Show/hide formula help

Google Sheets Rows and Columns Shortcuts

WINDOWSMACACTION
Alt + E, then D (Chrome) / Alt + Shift + E, then DCtrl + Option + E, then DDelete rows
Alt + E, then E (Chrome) / Alt + Shift + E, then ECtrl + Option + E, then EDelete columns
Alt + I, then C (Chrome) / Alt + Shift + I, then CCtrl + Option + I, then CInsert columns to the left
Alt + I, then O (Chrome) / Alt + Shift + I, then OCtrl + Option + I, then OInsert columns to the right
Alt + I, then R (Chrome) / Alt + Shift + I, then RCtrl + Option + I, then RInsert rows above
Alt + I, then W (Chrome) / Alt + Shift + I, then WCtrl + Option + I, then BInsert rows below
Alt + Shift + Down arrowOption + Shift + Down arrowExpand grouped rows or columns
Alt + Shift + Left arrowOption + Shift + Left arrowUngroup rows or columns
Alt + Shift + Right arrowOption + Shift + Right arrowGroup rows or columns
Alt + Shift + Up arrowOption + Shift + Up arrowCollapse grouped rows or columns
Ctrl + Alt + 0⌘ + Option + 0Hide column
Ctrl + Alt + 9⌘ + Option + 9Hide row
Ctrl + Shift + 0⌘ + Shift + 0Unhide column
Ctrl + Shift + 9⌘ + Shift + 9Unhide row

Google Sheets Notes and Comments Shortcuts

WINDOWSMACACTION
Ctrl + Alt + M⌘ + Option + MInsert/edit comment
Ctrl + Alt + Shift + A⌘ + Option + Shift + AOpen comment discussion thread
Holding Ctrl + Alt, press E then CHolding Ctrl + ⌘, press E then CEnter current comment
Holding Ctrl + Alt, press N then CHolding Ctrl + ⌘, press N then CMove to the next comment
Holding Ctrl + Alt, press P then CHolding Ctrl + ⌘, press P then CMove to the previous comment
Shift + F2Shift + F2Insert/edit note

Google Sheets Screen Readers Shortcuts

WINDOWSMACACTION
Ctrl + Alt + H⌘ + Option + HEnable braille support
Ctrl + Alt + Shift + C⌘ + Option + Shift + CRead Column
Ctrl + Alt + Shift + R⌘ + Option + Shift + RRead row
Ctrl + Alt + Z⌘ + Option + ZTurn on screen reader support

How to use Google Sheets?

Google Sheets is a free online spreadsheet application that allows you to create and format spreadsheets and simultaneously work with other people. You can also upload existing spreadsheets from Excel or other software. Here are some basics on how to use Google Sheets:

Creating a New Spreadsheet

To create a new spreadsheet, open Google Drive (drive.google.com) and click on the “New” button. Then, select “Google Sheets” from the drop-down menu. This will open up a new blank spreadsheet in your browser.

Formatting Your Spreadsheet

Once you have a blank spreadsheet open, you can start entering your data. You can format your data in a variety of ways, such as changing the font size or color, adding or removing cell borders, and more.

To format your data, select the cells that you want to format. Then, click on the “Format” option in the top menu. This will open up a sidebar on the right side of the screen with a variety of formatting options.

Inserting Images and Charts

In addition to data, you can also insert images and charts into your Google Sheet. To insert an image, click on the “Insert” option in the top menu. Then, select “Image” from the drop-down menu. This will open up a window where you can search for an image or upload one from your computer.

To insert a chart, click on the “Insert” option in the top menu. Then, select “Chart” from the drop-down menu. This will open up a window where you can select the type of chart you want to insert.

Working with Others

One of the great things about Google Sheets is that you can easily share your spreadsheet with others and work on it together in real-time. To share your spreadsheet, click on the “Share” button in the top-right corner of the screen. This will open up a window where you can enter the email addresses of the people you want to share the spreadsheet with.

Once you’ve shared your spreadsheet, you and the other people you’ve shared it with will be able to edit it simultaneously. You’ll see each other’s changes in real-time, and you can chat with each other using the chat box in the right sidebar.

Finally, I hope this article helps you to make your work faster on Google Sheets. As you can see, there is a large number of keyboard shortcuts available that can save you time and make working with spreadsheets a breeze. So, be sure to share with others to help them work with Google Sheets.