Google Sheets Shortcuts
Comprehensive list of keyboard shortcuts for Google Sheets, organized by function across PC, Mac, and Chrome OS platforms. Categories include common actions, editing commands, copy and paste functions, and sheet management, providing users with quick access to essential commands like "Undo" (Ctrl+Z) and "Insert a new sheet" (Shift+F11). This resource aims to enhance productivity and streamline workflow for users of all skill levels.
Content article
Google Sheets shortcuts encompass a wide range of commands across different operating systems, including PC, Mac, and Chrome OS, allowing users to enhance their productivity while working with spreadsheets.
In the "PC vs. Mac vs. Chrome OS" tab, common actions are detailed with specific keyboard shortcuts. For selecting a column, users can press Ctrl+Space on PC, while Mac users use Ctrl+Space as well, and Chrome OS users also utilize Ctrl+Space. Selecting a row is done with Shift+Space across all platforms. To select all, the shortcuts vary slightly: PC users can press Ctrl+A or Ctrl+Shift+Space, Mac users use ⌘+A or ⌘+Shift+Space, and Chrome OS users can simply use Ctrl+A. Undoing an action is performed with Ctrl+Z on PC, ⌘+Z on Mac, and Ctrl+Z on Chrome OS, while redoing an action can be accomplished with Ctrl+Y or Ctrl+Shift+Z on PC, ⌘+Y or ⌘+Shift+Z on Mac, and Ctrl+Y or Ctrl+Shift+Z on Chrome OS.
The tab also covers formatting shortcuts, such as making text bold with Ctrl+B for PC and ⌘+B for Mac, and italicizing text with Ctrl+I on PC and ⌘+I on Mac. For inserting a new sheet, PC users can press Shift+F11, while Mac users use Shift+Fn+F11.
In the "Review and select commands shortcuts" tab, inserting a comment can be done with Ctrl+Alt+M on PC, while Mac users can use Alt+R, C, and Alt+I, M. The shortcut for opening comment history is Ctrl+Alt+Shift+A on PC, and Mac users can access it with Alt+A, C, O. For spell check, the shortcut is F7 on PC, while Mac users can use Alt+R, S.
The "Copy and paste commands shortcuts" tab provides various methods for copying and pasting. Copying is done with Ctrl+C on PC and ⌘+C on Mac, while filling down can be achieved with Ctrl+D on PC and Alt+H, F, I, D on Mac. To paste values only, PC users can use Ctrl+Shift+V, while Mac users employ Alt+H, V, V.
In the "Edit commands shortcuts" section, editing the selected cell can be accomplished by pressing F2. To insert a row, users can use Ctrl+Alt+Shift+= on PC or Alt+H, I, R on Mac. Deleting the current row can be done with Alt+H, D, R on PC, while Mac users can use Alt+E, D.
The "Sheet commands shortcuts" tab includes shortcuts for accessing the sheet menu with Alt+Shift+S and inserting a new sheet with Shift+F11 or Alt+Shift+F1. Deleting the current sheet can be done with Alt+H, D, S on PC or Alt+E, L on Mac.
For menu access, the "Menus access shortcuts" tab lists shortcuts for various menus. The context menu can be accessed with Ctrl+Shift+\ on PC and Ctrl+Shift+X on Mac. The File menu can be opened with Alt+Shift+F on PC and Alt+F on Mac, while the Edit menu is accessed with Alt+Shift+E on PC and Alt+E on Mac.
In the "View commands shortcuts" tab, hiding selected columns can be done with Ctrl+Alt+0 on PC, while un-hiding columns is achieved with Ctrl+Shift+0. To show all formulas, users can press Ctrl+` on PC, while displaying the formula bar is done with Ctrl+Shift+U.
The "Data commands shortcuts" section provides shortcuts for inserting a chart with Alt+F1 and sorting ranges with Alt+H, S, S for top to bottom sorting. Creating a filter can be done with Alt+H, S, F, while defining a named range is achieved with Alt+M, N.
In the "Formatting commands shortcuts" tab, aligning text can be done with Ctrl+Shift+E for center alignment, Ctrl+Shift+L for left alignment, and Ctrl+Shift+R for right alignment. Applying borders can be achieved with Alt+Shift+1 for top borders and Alt+Shift+6 for removing borders.
The "Navigation commands shortcuts" tab includes shortcuts for finding in the sheet with Ctrl+F and moving to the next sheet with Ctrl+Shift+PageDown. To scroll to the active cell, users can press Ctrl+Backspace.
In the "Number format shortcuts" section, applying automatic number format is done with Ctrl+Shift+`, while setting the format to currency can be accomplished with Ctrl+Shift+4.
The "File commands shortcuts" tab outlines how to open a file with Ctrl+O and print with Ctrl+P. Sharing the spreadsheet can be done with Alt+F, H.
Lastly, the "Function commands shortcuts" tab mentions inserting functions such as the AVERAGE function with Alt+H, U, A, and the SUM function with Alt+H, U, S. Grouping columns or rows can be achieved with Alt+Shift+ArrowRight, while ungrouping is done with Alt+Shift+ArrowLeft.
Screen reader support shortcuts include speaking a comment with Ctrl+Alt+A and toggling screen reader support with Ctrl+Alt+Z.