This post contains some of the most useful Google Sheets keyboard shortcuts for popular browsers, such as Chrome, Edge, and Firefox, on Windows and Mac.

Advanced Excel users may notice some missing features in Google Sheets, such as formula auditing, goal seek, data consolidation, and row grouping and subtotal. Therefore, you may not find relevant shortcuts in Google Sheets.

But these features are available in one form or another in Google Sheets. You can use the QUERY function in Google Sheets for grouping and data consolidation. You can also use the Import functions to scrape content from the web.

Google Spreadsheets has almost everything that one can expect from a spreadsheet program. It’s free to use and a cloud-based solution, so you can access your spreadsheet from anywhere with an internet connection.

Pivot table, data validation, charts, formulas like SUMIF, SUMPRODUCT, VLOOKUP, and HLOOKUP, multiple spreadsheets, and all necessary features are available. Additionally, there are goodies like Regex, SPARKLINE function, etc.

Review the essential Google Sheets keyboard shortcuts below. If you use both Mac and PC, this can be a useful reference guide.

Google Sheets Keyboard Shortcuts for Accessing the Main Menu

The following (Table 1) are the Google Sheets keyboard shortcuts for accessing the main menus. The last key in the shortcut is the first letter of the menu. However, there are two exceptions, which I have highlighted.

Once you learn to access the main menus, you can select keyboard shortcuts for submenus, such as inserting rows, columns, slicers, data validation, and named ranges.

For example, you can open the Insert menu and press the letter “r” twice to insert a row above. Therefore, I will not include such Google Sheets keyboard shortcuts in this post.

Note: Those submenu shortcuts will only be visible if you open the menu using the shortcuts above. If you click on the menu, most of them may not be visible.

Google Sheets Keyboard Shortcuts for Editing

Here are the essential keyboard shortcuts for editing a Google Sheets file.

Google Sheets Keyboard Shortcuts for Navigation

To speed up your work, you must learn to use navigation shortcuts in Google Sheets. Here are the most essential ones.

Google Sheets Keyboard Shortcuts for Formatting

I usually use keyboard shortcuts for bold, italic, underline, and strikethrough. Other important shortcuts are applying borders. I like it in Excel, because there we can use the Format menu (Ctrl + 1) and do all of these in a flash.

Other Essential Shortcut Keys

Here are some miscellaneous Google Sheets keyboard shortcuts, including opening files, finding and replacing, and more. These are a must-learn if you want to speed up your work.

Conclusion

If you use both Excel and Sheets, you can toggle on compatible spreadsheet shortcuts in Google Sheets by going to Help > Keyboard shortcuts. You can also view them there.

This means that if you are already familiar with Excel keyboard shortcuts, you can use the same shortcuts in Google Sheets to perform the same actions.

Learn the shortcut keys for the tasks you do most often. This will help you save a lot of time.

You May Like: How to Insert a Static Timestamp in Google Sheets.