Are you tired of constantly switching between your mouse and keyboard while working in Google Sheets? Do you want to increase your productivity and save time? Look no further, because we have compiled a list of all the best Google Sheets keyboard shortcuts for you to use.
Why Use Keyboard Shortcuts?
Keyboard shortcuts, also known as keyboard hacks, are combinations of keys that perform a specific action in a software or program. They are designed to make tasks quicker and easier, as they eliminate the need to navigate through menus and options with a mouse.
Using keyboard shortcuts can significantly increase your productivity, as you can perform tasks faster and more efficiently. They also reduce the strain on your wrist and hand from constantly using a mouse.
How to Use Keyboard Shortcuts in Google Sheets
To use keyboard shortcuts in Google Sheets, you must first enable them in your settings. Here’s how:
- Open Google Sheets and click on the “Tools” tab in the menu bar.
- Select “Preferences” from the drop-down menu.
- In the “General” tab, check the box next to “Use keyboard shortcuts”.
- Click “Save”.
Now you’re ready to start using keyboard shortcuts in Google Sheets.
Basic Keyboard Shortcuts
Navigation
| Shortcut | Action | | — | — | | Ctrl + N | Create a new spreadsheet | | Ctrl + O | Open an existing spreadsheet | | Ctrl + S | Save the current spreadsheet | | Ctrl + P | Print the current spreadsheet | | Ctrl + F | Open the “Find and Replace” dialog box | | Ctrl + H | Open the “Find and Replace” dialog box with the “Replace” tab selected | | Ctrl + G | Open the “Go to cell” dialog box | | Ctrl + Z | Undo the last action | | Ctrl + Y | Redo the last action | | Ctrl + X | Cut the selected cells | | Ctrl + C | Copy the selected cells | | Ctrl + V | Paste the copied or cut cells | | Ctrl + A | Select all cells in the spreadsheet | | Ctrl + F1 | Show or hide the menu bar | | Ctrl + F2 | Show or hide the formula bar | | Ctrl + F3 | Open the “Define named ranges” dialog box | | Ctrl + F4 | Close the current spreadsheet | | Ctrl + F5 | Refresh the current spreadsheet | | Ctrl + F6 | Switch between open spreadsheets |
Formatting
| Shortcut | Action | | — | — | | Ctrl + B | Bold the selected cells | | Ctrl + I | Italicize the selected cells | | Ctrl + U | Underline the selected cells | | Ctrl + 1 | Open the “Format cells” dialog box | | Ctrl + Shift + 1 | Apply the “Number” format to the selected cells | | Ctrl + Shift + 2 | Apply the “Time” format to the selected cells | | Ctrl + Shift + 3 | Apply the “Date” format to the selected cells | | Ctrl + Shift + 4 | Apply the “Currency” format to the selected cells | | Ctrl + Shift + 5 | Apply the “Percentage” format to the selected cells | | Ctrl + Shift + 6 | Apply the “Exponential” format to the selected cells | | Ctrl + Shift + 7 | Apply the “Text” format to the selected cells | | Ctrl + Shift + 8 | Apply the “Number” format to the selected cells | | Ctrl + Shift + 9 | Apply the “Date” format to the selected cells | | Ctrl + Shift + 0 | Apply the “Time” format to the selected cells | | Ctrl + Shift + – | Apply the “Currency” format to the selected cells | | Ctrl + Shift + + | Apply the “Percentage” format to the selected cells | | Ctrl + Shift + ~ | Apply the “General” format to the selected cells | | Ctrl + Shift + $ | Apply the “Currency” format to the selected cells | | Ctrl + Shift + % | Apply the “Percentage” format to the selected cells | | Ctrl + Shift + ^ | Apply the “Exponential” format to the selected cells | | Ctrl + Shift + & | Apply the “Border” format to the selected cells | | Ctrl + Shift + _ | Remove the border from the selected cells | | Ctrl + Shift + * | Select the current region around the active cell | | Ctrl + Shift + ( | Unhide any hidden rows within the selection | | Ctrl + Shift + ) | Unhide any hidden columns within the selection | | Ctrl + Shift + { | Select all cells directly referenced by formulas in the selection | | Ctrl + Shift + } | Select all cells that directly or indirectly reference the active cell | | Ctrl + Shift + | Select all cells that contain formulas that reference the active cell | | Ctrl + Shift + | Select all cells that the active cell references | | Ctrl + Shift + : | Insert the current time | | Ctrl + Shift + ; | Insert the current date | | Ctrl + Shift + ~ | Show all formulas in the spreadsheet | | Ctrl + Shift + # | Change the date format to the default date format | | Ctrl + Shift + @ | Change the time format to the default time format | | Ctrl + Shift + ! | Apply the “Number” format with two decimal places, thousands separator, and minus sign for negative values | | Ctrl + Shift + $ | Apply the “Currency” format with two decimal places, thousands separator, and minus sign for negative values | | Ctrl + Shift + % | Apply the “Percentage” format with no decimal places | | Ctrl + Shift + ^ | Apply the “Exponential” format with two decimal places | | Ctrl + Shift + & | Apply the “Border” format to the selected cells | | Ctrl + Shift + _ | Remove the border from the selected cells | | Ctrl + Shift + * | Select the current region around the active cell | | Ctrl + Shift + ( | Unhide any hidden rows within the selection | | Ctrl + Shift + ) | Unhide any hidden columns within the selection | | Ctrl + Shift + { | Select all cells directly referenced by formulas in the selection | | Ctrl + Shift + } | Select all cells that directly or indirectly reference the active cell | | Ctrl + Shift + | Select all cells that contain formulas that reference the active cell | | Ctrl + Shift + | Select all cells that the active cell references | | Ctrl + Shift + : | Insert the current time | | Ctrl + Shift + ; | Insert the current date | | Ctrl + Shift + ~ | Show all formulas in the spreadsheet | | Ctrl + Shift + # | Change the date format to the default date format | | Ctrl + Shift + @ | Change the time format to the default time format | | Ctrl + Shift + ! | Apply the “Number” format with two decimal places, thousands separator, and minus sign for negative values | | Ctrl + Shift + $ | Apply the “Currency” format with two decimal places, thousands separator, and minus sign for negative values | | Ctrl + Shift + % | Apply the “Percentage” format with no decimal places | | Ctrl + Shift + ^ | Apply the “Exponential” format with two decimal places | | Ctrl + Shift + & | Apply the “Border” format to the selected cells | | Ctrl + Shift + _ | Remove the border from the selected cells | | Ctrl + Shift + * | Select the current region around the active cell | | Ctrl + Shift + ( | Unhide any hidden rows within the selection | | Ctrl + Shift + ) | Unhide any hidden columns within the selection | | Ctrl + Shift + { | Select all cells directly referenced by formulas in the selection | | Ctrl + Shift + } | Select all cells that directly or indirectly reference the active cell | | Ctrl + Shift + | Select all cells that contain formulas that reference the active cell | | Ctrl + Shift + | Select all cells that the active cell references | | Ctrl + Shift + : | Insert the current time | | Ctrl + Shift + ; | Insert the current date | | Ctrl + Shift + ~ | Show all formulas in the spreadsheet | | Ctrl + Shift + # | Change the date format to the default date format | | Ctrl + Shift + @ | Change the time format to the default time format | | Ctrl + Shift + ! | Apply the “Number” format with two decimal places, thousands separator, and minus sign for negative values | | Ctrl + Shift + $ | Apply the “Currency” format with two decimal places, thousands separator, and minus sign for negative values | | Ctrl + Shift + % | Apply the “Percentage” format with no decimal places | | Ctrl + Shift + ^ | Apply the “Exponential” format with two decimal places | | Ctrl + Shift + & | Apply the “Border” format to the selected cells | | Ctrl + Shift + _ | Remove the border from the selected cells | | Ctrl + Shift + * | Select the current region around the active cell | | Ctrl + Shift + ( | Unhide any hidden rows within the selection | | Ctrl + Shift + ) | Unhide any hidden columns within the selection | | Ctrl + Shift + { | Select all cells directly referenced by formulas in the selection | | Ctrl + Shift + } | Select all cells that directly or indirectly reference the active cell | | Ctrl + Shift + | Select all cells that contain formulas that reference the active cell | | Ctrl + Shift + | Select all cells that the active cell references | | Ctrl + Shift + : | Insert the current time | | Ctrl + Shift + ; | Insert the current date | | Ctrl + Shift + ~ | Show all formulas in the spreadsheet | | Ctrl + Shift + # | Change the date format to the default date format | | Ctrl + Shift + @ | Change the time format to the default time format | | Ctrl + Shift + ! | Apply the “Number”
