[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Google Sheets is a versatile and powerful spreadsheet program with many built-in features and tools, as well as the possibility to extend them using the Google Sheets API<\/a>, Google Apps Script<\/a>, and a growing list of add-ons. In other words, there are many, many things you can do in Google Sheets.<\/p>\n However, no matter what you use it for, there are some basic actions that you need to repeat frequently. Many of these are related to editing, formatting, and navigating your Sheets. Google Sheets keyboard shortcuts are combinations of keys that allow you to perform tasks without having to search through menus for the right button.<\/p>\n In this guide, you will learn about Google Sheets keyboard shortcuts that can save you time and effort. You have a selection of 39 must-know shortcuts in different categories, each with the relevant combination of keys for use on Windows or Mac. You will also learn that while Google Sheets shortcuts are different from those of Microsoft Excel, you can easily enable compatible spreadsheet shortcuts. By enabling these, you will get 130+ familiar Excel shortcuts if you use Windows and 20 if you use Mac.<\/p>\n [\/et_pb_text][et_pb_text module_id=”are-google-sheets-shortcuts-the-same-as” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you\u2019re used to Microsoft Excel shortcuts, you\u2019ll be happy to learn that you can use most of them in Google Sheets. You can \u201cEnable compatible shortcuts\u201d to add them to the existing shortcuts. However, keep in mind that some of these might not work for specific keyboard and language settings.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-do-i-add-compatible-shortcuts-in-goo” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To use Microsoft Excel shortcuts in Google Sheets, go to Help > Keyboard shortcuts. Alternatively, you can use a shortcut to get there: Ctrl + \/ (Windows) or Cmd + \/ (Mac). Toggle the button to \u201cEnable compatible spreadsheet shortcuts\u201d and use familiar spreadsheet shortcuts in Google Sheets: 130+ on Windows and 20 on Mac.<\/p>\n 1. <\/strong>Open a spreadsheet in Google Sheets and go to Help > Keyboard shortcuts, or use the shortcut: Ctrl + \/ (Windows) or Cmd + \/ (Mac).<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-shortcuts-help-menu-keyboard-shortcuts.webp” alt=”Google Sheets keyboard shortcuts \u2014 Help menu open with Keyboard shortcuts highlighted at the bottom” title_text=”Help menu open with Keyboard shortcuts highlighted at the bottom” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong>Click the button to \u201cEnable compatible spreadsheet shortcuts\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-shortcuts-enable-compatible-toggle.webp” alt=”Google Sheets keyboard shortcuts \u2014 Keyboard shortcuts dialog with the Enable compatible spreadsheet shortcuts toggle on” title_text=”Keyboard shortcuts dialog with the Enable compatible spreadsheet shortcuts toggle on” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3. <\/strong>Click \u201cView compatible shortcuts\u201d to see the list.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-delete-row-shortcut-compatible-list.webp” alt=”Google Sheets delete row shortcut \u2014 Compatible spreadsheet shortcuts (20) list with the delete rows or columns shortcut” title_text=”Compatible spreadsheet shortcuts (20) list with the delete rows or columns shortcut” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-delete-a-row-in-google-sheets-wit” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The Google Sheets delete row shortcut is Ctrl + Alt + – on Windows and Cmd + Option + – on Mac. To use it:<\/p>\n If you press the shortcut with only a cell selected, Google Sheets opens a delete menu where you can choose to delete the row or the column. With compatible spreadsheet shortcuts turned on, Ctrl + – (Windows) or Cmd + – (Mac) also works, as it does in Excel.<\/p>\n To delete rows that sit next to each other, click a cell in the first row, hold Shift, and press the Down Arrow until you reach the last row. Press Shift + Space to extend the selection to the full rows, then press Ctrl + Alt + – (Windows) or Cmd + Option + – (Mac).<\/p>\n For rows that aren’t next to each other, hold Ctrl (Windows) or Cmd (Mac) and click each row number. Then right-click one of the selected row numbers and choose “Delete selected rows”.<\/p>\n [\/et_pb_text][et_pb_text module_id=”keyboard-shortcuts-for-google-sheets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Below, you have a selection of must-know Google Sheets shortcuts by category for both Windows and Mac.<\/p>\n [\/et_pb_text][et_pb_text module_id=”basic-editing” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The shortcuts below include common actions related to editing and selection in Google Sheets.<\/p>\n Select the cells you want and use the shortcut below to copy them.<\/p>\n Select the cells you want to cut and use the shortcut below.<\/p>\n Use the shortcut below to paste copied cells with their values, formatting, and formulas.<\/p>\n Using the shortcut below will only paste the values of copied cells without formatting or formulas.<\/p>\n Use the shortcut below to open the ‘Find and replace’<\/a> window.<\/p>\n Use the shortcut below to repeat your last action.<\/p>\n Use the shortcut below to undo your last action.<\/p>\n If you select a cell within a range, the shortcut below will select the whole range. If you select an empty cell somewhere in your spreadsheet, this shortcut will select all the cells in your spreadsheet.<\/p>\n [\/et_pb_text][et_pb_text module_id=”format” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There are many shortcuts related to formatting, just as there are many formatting options in Google Sheets. The selection below includes some of the most common tasks related to formatting cell contents.<\/p>\n [\/et_pb_text][et_pb_text module_id=”formulas” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There are very few shortcuts related to formulas; however, the ones included below are almost certain to be useful.<\/p>\n You can show the formulas in your cells, rather than the result of the calculations, by using the shortcut below.<\/p>\n When you finish typing your formula, use the shortcut below to add the ARRAYFORMULA function<\/a>.<\/p>\nAre Google Sheets shortcuts the same as Excel?<\/h2>\n
How do I add compatible shortcuts in Google Sheets?<\/h2>\n
How to delete a row in Google Sheets with a keyboard shortcut<\/h2>\n
\n
Shortcut to delete multiple rows in Google Sheets<\/h3>\n
Keyboard shortcuts for Google Sheets<\/h2>\n
Basic editing<\/h2>\n
1. Copy<\/h3>\n
\n
2. Cut<\/h3>\n
\n
3. Paste<\/h3>\n
\n
4. Paste values only<\/h3>\n
\n
5. Find & replace<\/h3>\n
\n
6. Redo<\/h3>\n
\n
7. Undo<\/h3>\n
\n
8. Select all<\/h3>\n
\n
Format<\/h2>\n
1. Clear formatting<\/h3>\n
\n
2. Bold<\/h3>\n
\n
3. Italic<\/h3>\n
\n
4. Underline<\/h3>\n
\n
5. Insert link<\/h3>\n
\n
6. Insert date & time<\/h3>\n
\n
7. Format as decimal<\/h3>\n
\n
8. Format as time<\/h3>\n
\n
9. Format as date<\/h3>\n
\n
10. Format as currency<\/h3>\n
\n
11. Format as percentage<\/h3>\n
\n
Formulas<\/h2>\n
1. Show formulas<\/h3>\n
\n
2. Insert ARRAYFORMULA function<\/h3>\n