Google Sheets Shortcut Keys for Faster Everyday Work

Google Sheets shortcut keys let you edit, format, navigate, and manage a spreadsheet without reaching for menus. In a browser on Windows or ChromeOS, common keys include Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to undo, and Ctrl+/ to open the full shortcut list; on a Mac, use Command instead of Ctrl for many everyday commands.

How Google Sheets shortcuts work

Sheets runs in a browser, so its shortcuts can depend on your operating system, browser, keyboard layout, and whether a browser command takes priority. The lists below are for Google Sheets in a web browser. Windows and ChromeOS generally use Ctrl, while macOS generally uses Command for editing actions. Some navigation and formatting commands do not follow that simple substitution, so check the built-in shortcut list if a key combination behaves differently on your device.

To see the shortcuts available in your current setup, open a spreadsheet and press Ctrl+/ on Windows or ChromeOS, or Command+/ on Mac. You can also open Help > Keyboard shortcuts. This is the best reference when a shortcut is missing, conflicts with a browser command, or differs because of your keyboard layout. The dialog may offer an option for compatible spreadsheet shortcuts; if you use it, review the updated list rather than assuming every Excel shortcut will work.

A shortcut acts on the current focus. For example, Ctrl+B applies bold while a cell or text is selected, but a browser may interpret some keys when focus is in the address bar or another browser control. Click a cell first when a command seems to do nothing.

Everyday editing and clipboard shortcuts

These commands cover the actions most people repeat while entering or revising data. On Mac, use Command for the standard copy, cut, paste, undo, and find commands where applicable.

Ctrl+C / Ctrl+X / Ctrl+V: Copy, cut, and paste selected cells or content.
Ctrl+Shift+V: Paste values only. This is useful when copying a calculated result but not its formula or formatting.
Ctrl+Z: Undo the most recent spreadsheet action. Use Ctrl+Y to redo on Windows or ChromeOS; on Mac, Command+Shift+Z is the usual redo shortcut.
Ctrl+F: Find text or values in the sheet. Ctrl+H opens Find and replace in Sheets.
Ctrl+K: Insert or edit a link for selected content.
Ctrl+Enter: Enter the same content in all selected cells. Select the target range first, type the entry, and use the shortcut to apply it to the selection.

Paste values is especially helpful when a copied cell contains a formula. Ordinary paste may carry the formula and formatting into the destination, while paste values transfers the displayed results. If you need only formatting, use the paint format tool in the toolbar rather than expecting paste values to preserve it.

Moving around and selecting data

Navigation shortcuts are most useful in long tables. The arrow keys move one cell at a time. Ctrl plus an arrow key moves to the edge of a contiguous block of data in that direction; adding Shift selects the cells along the way. For instance, click a cell in a filled column and press Ctrl+Shift+Down to extend a selection toward the end of its data block. A blank cell inside the block can change where the movement stops.

Ctrl+Home: Move to the beginning of the sheet.
Ctrl+End: Move toward the end of the sheet’s used area. The precise endpoint can depend on what has been entered or formatted.
Ctrl+Arrow: Jump to the edge of a data region.
Ctrl+Shift+Arrow: Extend the selection to the edge of a data region.
Ctrl+Space: Select a column; Shift+Space selects a row.

To select a whole column or row, first click a cell in it, then use the relevant selection shortcut. These shortcuts can save time when applying a format or clearing a range, but check the highlighted selection before deleting or overwriting anything. When a table has gaps, use the mouse or the name box to select a precise range instead of assuming one keypress will capture every record.

Entering and editing cell contents

Press Enter after typing to commit an entry and move to another cell. Double-click a cell, or select it and begin typing, to replace its content. To edit the existing text or formula without replacing it, press F2 on many Windows keyboards; on some laptops you may need Fn+F2. The formula bar is another dependable way to inspect or edit a long entry.

Sheets also has shortcuts for inserting the current date and time. In many Windows and ChromeOS browser setups, Ctrl+; inserts the date, and Ctrl+Shift+; inserts the time. These shortcuts can vary with keyboard layout and operating system, so confirm them in Help > Keyboard shortcuts if the punctuation key combination is awkward on your keyboard. A timestamp entered this way is a value, not a live clock that updates every moment.

While editing a formula, F4 can cycle through reference styles for a selected cell reference, such as relative and absolute references. Laptop function-key settings may require Fn+F4, and behavior can differ on Mac. If the key changes screen brightness or another device setting instead, use the function-key modifier or consult the shortcut dialog.

Formatting shortcuts and number formats

Basic text formatting has familiar shortcuts: Ctrl+B for bold, Ctrl+I for italics, and Ctrl+U for underline. On Mac, the corresponding common combinations use Command. Select a cell or a portion of text in the cell before applying a style. Pressing the same shortcut again generally removes the style from the selected content.

Google Sheets also provides number-format shortcuts on many Windows and ChromeOS keyboards. The Ctrl+Shift+number combinations apply common formats: 1 for a decimal format, 2 for time, 3 for date, 4 for currency, 5 for percentage, and 6 for scientific notation. Exact display details, such as decimal places or currency symbol, can depend on the spreadsheet’s locale and existing format. These shortcuts change how a value is displayed; they do not necessarily change the underlying value.

If a format shortcut is unavailable or produces a browser action, use the menus instead. For example, select cells and choose Format > Number to choose a number format. Use Format > Text wrapping for wrapping choices, or the toolbar for common text styles. Menu commands are a useful fallback and help clarify which cells or options are affected.

Comments, menus, and spreadsheet tools

Keyboard access is not limited to typing into cells. Ctrl+Alt+M opens a comment on Windows or ChromeOS in supported browser setups; on Mac, the corresponding shortcut is commonly Command+Option+M. If it conflicts with the system or browser, use Insert > Comment. Comments are useful for questions or review notes that should remain attached to a cell without becoming part of its value.

Press Alt+/ on Windows or ChromeOS, or Option+/ on Mac, to open the tool finder in Sheets. Type a command such as conditional formatting or freeze to find a related menu action. This is particularly helpful when you know what you want to do but cannot remember whether it is under Format, Data, or another menu. The tool finder searches Sheets tools, rather than replacing the browser’s address bar or general web search.

For example, to highlight values that meet a rule, select the range and choose Format > Conditional formatting. To review earlier edits, choose File > Version history > See version history. Shortcuts can speed up frequent tasks, but menus remain useful for discovering settings and confirming the command’s scope.

Google Sheets shortcuts versus Excel

Many basic editing shortcuts are shared by Google Sheets and Microsoft Excel, especially Ctrl+C, Ctrl+V, Ctrl+Z, and Ctrl+B on Windows. That overlap makes it easier to move between spreadsheet programs, but it does not mean their full shortcut systems are identical. Some combinations open different tools, and browser-based Sheets must also coexist with browser and operating-system commands.

Do not assume an Excel shortcut will work in Sheets just because it seems familiar. In particular, ribbon key sequences, application-specific navigation, and shortcuts for advanced features can differ. If you switch between the programs, verify an unfamiliar combination in Sheets’ own shortcut dialog. You can also use the menu path shown in the interface; that gives you the actual Sheets command even when a shortcut is different.

Common shortcut problems and fixes

A shortcut that appears not to work usually has a practical explanation. Check the cell selection, focus, keyboard, and browser before concluding the feature is unavailable.

The browser intercepts the key: Commands such as opening a tab or closing a window belong to the browser. Sheets cannot always override them. Use the menu or tool finder for the spreadsheet action you need.
The wrong cell changes: A shortcut applies to the active selection, which may be a range or an edited cell. Look at the highlighted cells before using paste, delete, or formatting commands.
A key produces a device action: On laptops, function keys may control brightness or volume. Try holding Fn, or use the menu equivalent.
Mac keys differ: Command replaces Ctrl for many editing shortcuts, but not every shortcut is a direct swap. Check Help > Keyboard shortcuts on the Mac itself.
A shortcut differs by locale: Punctuation-based combinations may be difficult on some keyboard layouts. Search the shortcut dialog and use the menu if necessary.

For a shared or important spreadsheet, undo is useful but not a substitute for caution. Before a large paste or deletion, confirm the selected range. For collaborative changes, version history can help identify earlier versions if you need to review how a sheet changed.

How to learn the shortcuts you will actually use

Rather than memorizing a long list, begin with a small set tied to your regular work: copy and paste, undo, find, move through data, select a row or column, and apply a common format. Use each combination in a low-risk sheet until it becomes familiar. Then add a specialized shortcut only when you repeat that task often enough to benefit.

A sensible practice sequence is to select a sample table, move through its filled cells with Ctrl+Arrow, extend a selection with Ctrl+Shift+Arrow, and copy a cell using paste values into a test area. Check each result before moving on. If a shortcut does not match your setup, open the shortcut dialog and learn the listed alternative rather than repeatedly trying combinations from an unrelated spreadsheet program.

Frequently Asked Questions

What is the shortcut to see all Google Sheets shortcuts?
Press Ctrl+/ on Windows or ChromeOS, or Command+/ on Mac. You can also open Help > Keyboard shortcuts while a spreadsheet is open.

Is there a Google Sheets shortcut to paste values only?
Yes. Use Ctrl+Shift+V on Windows or ChromeOS. On Mac, shortcut behavior can vary with the browser and keyboard setup, so confirm the paste-values command in the shortcut dialog or use the Edit menu.

How do I find and replace text in Google Sheets?
Press Ctrl+H on Windows or ChromeOS to open Find and replace. On Mac, check the shortcut dialog for the current combination, or use Edit > Find and replace.

Do Google Sheets shortcuts work on a phone?
The shortcuts in this guide are for a physical keyboard in the browser version. The Sheets mobile app uses touch controls, though an attached keyboard may support some commands. Consult the app’s available controls rather than assuming desktop shortcuts all apply.

Can I use Excel shortcut keys in Google Sheets?
Some common shortcuts are shared, but the two programs are not identical. Use the built-in Sheets shortcut list or its menus to confirm any command that matters to your workflow.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.