All of the Greatest Google Sheets Keyboard Shortcuts

The Google Sheets logo.

Nobody likes to do issues the onerous manner, which is why now we have keyboard shortcuts! We’re going to have a look at the shortcuts you should utilize in Google Sheets to avoid wasting your self a while.

Not at all is that this an entire listing of all keyboard shortcuts out there in Google Sheets. We’ve restricted our listing to those who are extra usually helpful. There are loads extra you may discover in the event you can’t discover what you’re searching for on this information.

To open an inventory of keyboard shortcuts in Google Sheets, press Ctrl + / (Home windows and Chrome OS), Cmd + / (macOS) If you wish to see the whole listing, take a look at the Google Sheets help web page.

Common Program Actions

These keyboard shortcuts make it simpler to carry out widespread actions, like copying cells or choosing rows or columns:

  • Ctrl+C (Home windows/Chrome OS) or Cmd+C (macOS): Copy the chosen cells to the Clipboard.
  • Ctrl+X (Home windows/Chrome OS) or Cmd+X (macOS): Reduce the chosen cells to the Clipboard.
  • Ctrl+V (Home windows/Chrome OS) or Cmd+V (macOS): Paste the contents of the Clipboard to the sheet.
  • Ctrl+Shift+V (Home windows/Chrome OS) or Cmd+Shift+V (macOS): Paste solely the values of the Clipboard.
  • Ctrl+Area (Home windows/Chrome OS) or Cmd+Area (macOS): Choose the entire column.
  • Shift+Area (Home windows/Chrome OS) or Shift+Area (macOS): Choose the entire row.
  • Ctrl+A (Home windows/Chrome OS) or Cmd+A (macOS): Choose all the cells.
  • Ctrl+Z (Home windows/Chrome OS) or Cmd+Z (macOS): Undo an motion.
  • Ctrl+Y (Home windows/Chrome OS) or Cmd+Y (macOS): Redo an motion.
  • Ctrl+F (Home windows/Chrome OS) or Cmd+F (macOS): Discover within the sheet.
  • Ctrl+H (Home windows/Chrome OS) or Cmd+H (macOS): Discover and change within the sheet.
  • Shift+F11 (Home windows Solely): Insert a brand new sheet.
  • Ctrl+Alt+Shift+H (Home windows/Chrome OS) or Cmd+Possibility+Shift+H (macOS): Open the spreadsheet’s revision historical past.

Format Cells

Google Sheets has heaps of shortcuts you should utilize to format cells. These are the shortcuts you employ to do issues like italicize or daring textual content, or format cell information to exponents:

  • Ctrl+B (Home windows/Chrome OS) or Cmd+B (macOS): Daring.
  • Ctrl+I (Home windows/Chrome OS) or Cmd+I (macOS): Italicize.
  • Ctrl+U (Home windows/Chrome OS) or Cmd+U (macOS): Underline.
  • Ctrl+Shift+E (Home windows/Chrome OS) or Cmd+Shift+E (macOS): Middle align a cell.
  • Ctrl+Shift+L (Home windows/Chrome OS) or Cmd+Shift+L (macOS): Left align a cell
  • Ctrl+Shift+R (Home windows/Chrome OS) or Cmd+Shift+R (macOS): Proper align a cell.
  • Ctrl+; (Home windows/Chrome OS) or Cmd+; (macOS): Insert the present date.
  • Alt+Shift+7 (Home windows/Chrome OS) or Cmd+Shift+7 (macOS): Apply an outer border to the chosen cells.
  • Alt+Shift+6 (Home windows/Chrome OS) or Possibility+Shift+6 (macOS): Take away a border from the chosen cells.
  • Ctrl+Shift+1 (Home windows/Chrome OS/macOS): Format as a decimal.
  • Ctrl+Shift+2 (Home windows/Chrome OS/macOS): Format as time.
  • Ctrl+Shift+3 (Home windows/Chrome OS/macOS): Format as a date.
  • Ctrl+Shift+4 (Home windows/Chrome OS/macOS): Format as forex.
  • Ctrl+Shift+5 (Home windows/Chrome OS/macOS): Format as a share.
  • Ctrl+Shift+6 (Home windows/Chrome OS/macOS): Format as an exponent.
  • Ctrl+ (Home windows/Chrome OS) or Cmd+ (macOS): Clear all formatting from the chosen cells.

Transfer Round a Spreadsheet

You may transfer round your spreadsheet rapidly with out touching your mouse! With these useful shortcuts, you may zip between rows and columns:

  • Left/Proper/Up/Down Arrow: Transfer one cell to the left, proper, up, or down.
  • Ctrl+Left/Proper Arrow (Home windows/Chrome OS) or Ctrl+Possibility+Left/Proper Arrow (macOS): Transfer to the primary or final cell with information in a row.
  • Ctrl+Up/Down Arrow (Home windows/Chrome OS) or Ctrl+Possibility+Up/Down Arrow (macOS): Transfer to the primary or final cell with information in a column.
  • House (Home windows), Search+Left Arrow (Chrome OS), or Fn+Left Arrow (macOS): Transfer to the start of a row.
  • Finish (Home windows), Search+Proper Arrow (Chrome OS), or Fn+Proper Arrow (macOS): Transfer to the top of a row.
  • Ctrl+House (Home windows), Ctrl+Search+Left Arrow (Chrome OS), or Cmd+Fn+Left Arrow (macOS): Transfer to the start of the sheet (A1).
  • Ctrl+Finish (Home windows), Ctrl+Search+Proper Arrow (Chrome OS), or Cmd+Fn+Proper Arrow (macOS): Transfer to the top of the sheet.
  • Ctrl+Backspace (Home windows/Chrome OS) or Cmd+Backspace (macOS): Scroll again to the lively cell.
  • Alt+Down/Up Arrow (Home windows/Chrome OS) or Possibility+Down/Up Arrow (macOS): If you’ve gotten multiple sheet within the present file, use this shortcut to maneuver to the subsequent or earlier sheet.
  • Alt+Shift+Okay (Home windows/Chrome OS) or Possibility+Shift+Okay (macOS): Show an inventory of all sheets.
  • Ctrl+Alt+Shift+M (Home windows/Chrome OS) or Ctrl+Cmd+Shift+M (macOS): Transfer focus out of the spreadsheet.

Use Formulation

These shortcuts turn out to be useful while you kind formulation in your spreadsheet:

  • Ctrl+~: Present all formulation within the sheet.
  • Ctrl+Shift+Enter (Home windows/Chrome OS) or Cmd+Shift+Enter (macOS): Insert an array system (while you enter a system, kind “=” first).
  • F1 (Home windows) or Fn+F1 (macOS): Full or compact system assist (while you kind a system).
  • F9 (Home windows) or Fn+F9 (macOS): Toggle system end result previews (while you kind a system).

Add or Change Rows and Columns on a PC

If you wish to duplicate a cell’s information into a particular vary, conceal or delete columns or rows, comply with the shortcuts under.

As a result of Google likes to make issues sophisticated, there are some browser-specific instructions for these keyboard shortcuts in the event you use Chrome. In case you are, simply comply with the instructions, after which add the “Chrome” shortcut to finish the browser-specific instructions:

  • Ctrl+D: Duplicate the info from the primary column of the chosen vary down.
  • Ctrl+R: Duplicate the info from the primary row of the chosen vary to the best.
  • Ctrl+Enter: Duplicate the info from the primary cell of the chosen vary into the opposite cells.
  • Ctrl+Alt+9: Disguise rows.
  • Ctrl+Shift+9: Unhide rows.
  • Ctrl+Alt+0: Disguise columns.
  • Ctrl+Shift+0: Unhide columns.
  • Alt+I, then R (Chrome) or Alt+Shift+I, then R (Different browsers): Insert rows above.
  • Alt+I, then W (Chrome) or Alt+Shift+I, then W (Different browsers): Insert rows under.
  • Alt+I, then C (Chrome) or Alt+Shift+I, then C (Different browsers): Insert columns to the left.
  • Alt+I, then O (Chrome) or Alt+Shift+I, then O (Different browsers): Insert columns to the best.
  • Alt+E, then D (Chrome) or Alt+Shift+E, then D (Different browsers): Delete rows.
  • Alt+E, then E (Chrome) or Alt+Shift+E, then E (Different browsers): Delete columns.

Add or Change Rows and Columns on macOS

Should you use a Mac, comply with these shortcuts so as to add, take away, or change rows and columns in Google Sheets:

  • Cmd+D: Duplicate the info from the primary column of the chosen vary down.
  • Cmd+R: Duplicate the info from the primary row of chosen vary to the best.
  • Cmd+Enter: Duplicate the info from the primary cell of the chosen vary into the opposite cells.
  • Cmd+Possibility+9: Disguise a row.
  • Cmd+Shift+9: Unhide a row.
  • Cmd+Possibility+0: Disguise a column.
  • Cmd+Shift+0: Unhide a column.
  • Ctrl+Possibility+I, then R: Insert rows above.
  • Ctrl+Possibility+I, then W: Insert rows under.
  • Ctrl+Possibility+I, then C: Insert columns to the left.
  • Ctrl+Possibility+I, then O: Insert columns to the best.
  • Ctrl+Possibility+E, then D: Delete rows.
  • Ctrl+Possibility+E, then E: Delete columns.

Entry the Menus on a PC

You need to use the next shortcuts on a PC to entry every menu merchandise. Notice that almost all are barely totally different in Chrome:

  • Alt+F (Chrome) or Alt+Shift+F (Different browsers): Entry the File menu.
  • Alt+E (Chrome) or Alt+Shift+E (Different browsers): Entry the Edit menu.
  • Alt+V (Chrome) or Alt+Shift+V (Different browsers): Entry the View menu.
  • Alt+I (Chrome) or Alt+Shift+I (Different browsers): Entry the Insert menu.
  • Alt+O (Chrome) or Alt+Shift+O (Different browsers): Entry the Format menu.
  • Alt+T (Chrome) or Alt+Shift+T (Different browsers): Entry the Instruments menu.
  • Alt+H (Chrome) or Alt+Shift+H (Different browsers): Entry the Assist menu.
  • Alt+A (Chrome) or Alt+Shift+A (Different browsers): Entry the Accessibility menu (current when display reader help is enabled).
  • Shift+Proper-click: Present your browser’s context menu (by default, Google Sheets overrides your browser’s context menu with its personal).
  • Ctrl+Shift+F: Swap to Compact mode (conceal the menus).

Entry the Menus on macOS

You need to use the next shortcuts on a Mac to entry every menu merchandise:

  • Ctrl+Possibility+F: Open the File menu.
  • Ctrl+Possibility+E: Open the Edit menu.
  • Ctrl+Possibility+V: Open the View menu.
  • Ctrl+Possibility+I: Open the Insert menu.
  • Ctrl+Possibility+O: Open the Format menu.
  • Ctrl+Possibility+T: Open the Instruments menu.
  • Ctrl+Possibility+H: Open the Assist menu.
  • Ctrl+Possibility+A: Open the Accessibility menu (current when display reader help is enabled).
  • Cmd+Possibility+Shift+Okay: Open the Enter Instruments menu (out there in all paperwork that include non-Latin languages).
  • Cmd+Shift+F: Swap to Compact mode (conceal the menus).
  • Shift+Proper-click: Present the browser’s context menu (by default, Google Sheets overrides your browser’s context menu with its personal).

Entry Microsoft Excel Keyboard Shortcuts

Example of Google Sheets compatible shortcuts.

As of Might 2019, Google means that you can use acquainted keyboard shortcuts from different well-known spreadsheet applications. You do must allow this selection, however right here’s how:

Out of your Google Sheets spreadsheet, click on Assist > Keyboard shortcuts. Alternatively, press Ctrl+/ (Home windows/Chrome OS) or Cmd+/ (macOS).

Click Help, and then select Keyboard shortcuts.

On the backside of the window, toggle-on “Allow suitable spreadsheet shortcuts.”

Click the toggle next to "Enable compatible spreadsheet keyboard shortcuts" to on.

That’s all there may be to it! All of the shortcuts you’ve discovered at the moment are out there in Google Sheets. To see an entire listing, click on “View suitable shortcuts” subsequent to the toggle change.

Click "View compatible shortcuts."

Hopefully, all these shortcuts will make your work lots simpler! Should you didn’t discover the one you want, head over to the Google help web page for extra.

Leave a Reply

Your email address will not be published. Required fields are marked *