Google Sheets Shortcut Keys: A Practical Guide for Work

Google Sheets shortcut keys help you edit cells, move around a spreadsheet, format data, and work faster in a web browser. On Windows, common examples include Ctrl+C to copy, Ctrl+Shift+V to paste values only, Ctrl+; to insert today’s date, and Ctrl+/ to open the shortcut list; on Mac, many Ctrl shortcuts use Command instead.

Google Sheets shortcuts are not Excel shortcuts

People sometimes search for “Google Excel shortcut keys” when they mean keyboard shortcuts in Google Sheets. They are related spreadsheet tools, but they are different products: Google Sheets runs in a browser and saves work in Google Drive, while Microsoft Excel is a separate application with its own shortcut behavior. A familiar key combination may work in both, but not every shortcut does.

The examples here are for Google Sheets in a web browser. Unless noted, Windows instructions use the Ctrl key. On Mac, use Command (⌘) for many common editing actions such as copy, paste, undo, and find. Some Sheets shortcuts still use Control or another key on Mac, so the operating system’s key mapping is not always a simple Ctrl-to-Command swap.

Shortcuts can also depend on the browser, keyboard layout, and whether a system-level command intercepts a key. If a combination does something unexpected, open Sheets’ own shortcut reference with Ctrl+/ on Windows or ⌘+/ on Mac and check the current listing.

Everyday editing shortcuts

These combinations cover the actions most people repeat while entering or revising spreadsheet data. On Mac, the common editing shortcuts in the first list generally use Command in place of Ctrl.

Copy: Ctrl+C; on Mac, ⌘+C.
Cut: Ctrl+X; on Mac, ⌘+X.
Paste: Ctrl+V; on Mac, ⌘+V.
Undo and redo: Ctrl+Z and Ctrl+Y; on Mac, ⌘+Z and ⌘+Y.
Find text: Ctrl+F; on Mac, ⌘+F.
Open Find and replace: Ctrl+H; on Mac, ⌘+Shift+H.
Insert or edit a link: Ctrl+K; on Mac, ⌘+K.
Paste values only: Ctrl+Shift+V; on Mac, ⌘+Shift+V.

Paste values only is especially useful when copying a formula but wanting to keep just its displayed result. For example, if a cell contains a formula that calculates a total, copying it normally may bring the formula into the destination. Paste values only places the calculated value instead, without carrying over the formula. It is also handy when transferring data that should not retain the original formatting.

Find and replace can update repeated text across a sheet, but check the options in its dialog before replacing. A broad replacement may change more cells than intended; search for a distinctive value first and review the matches before applying a change.

Navigation and selecting cells

Keyboard navigation becomes more valuable as a sheet grows. The arrow keys move one cell at a time. Ctrl+an arrow key on Windows moves toward the edge of a continuous data region in that direction; on Mac, the equivalent commonly uses ⌘+an arrow key. This is useful for jumping through a long column, but a blank cell can interrupt the region and affect where the cursor lands.

Go to the beginning or end of the sheet: Ctrl+Home or Ctrl+End on Windows. On Mac, use ⌘+Fn+Left Arrow for the beginning and ⌘+Fn+Right Arrow for the end on many keyboards; laptop function-key settings can affect the exact keys.
Select a whole column: Ctrl+Space. On Mac, Control+Space is used, though macOS may reserve this combination for changing input sources.
Select a whole row: Shift+Space.
Move between sheet tabs: Alt+Down Arrow for the next sheet and Alt+Up Arrow for the previous sheet on Windows. On Mac, use Option+Down Arrow and Option+Up Arrow.

To select a column, first place the active cell in that column, then use the column-selection shortcut. The same principle applies to selecting a row. If the Mac Control+Space shortcut triggers an operating-system feature instead, use the column letter at the top of the grid or change the conflicting macOS keyboard setting.

Entering data and filling patterns

When a value should be repeated down or across a range, fill shortcuts can avoid repeated copying. Select the cells that contain the source and the destination cells, then press Ctrl+D to fill down or Ctrl+R to fill right. The selected range matters: if only one cell is selected, there is no larger destination range to fill.

For example, suppose a formula is in B2 and should be copied through B20. Select B2:B20 and press Ctrl+D. Sheets fills the selected cells downward using the top cell as the source, adjusting relative references as appropriate. Review the first and last filled formulas if the calculation depends on cell references, especially when the range includes blank rows or mixed absolute and relative references.

To put a date in the active cell, press Ctrl+; on Windows or ⌘+; on Mac. To insert the current time, use Ctrl+Shift+; on Windows or ⌘+Shift+; on Mac. These shortcuts enter a value at the time of the keystroke; they are not live formulas that update automatically as time passes.

Formatting numbers and working with menus

Number formats change how a value appears, not the underlying value. A percentage format, for instance, displays a stored decimal as a percentage. Keyboard formatting shortcuts can be convenient, but the toolbar or the Format menu is a sensible alternative when a shortcut conflicts with your keyboard.

Format as a number with decimals: Ctrl+Shift+1 on Windows.
Format as a time: Ctrl+Shift+2 on Windows.
Format as a date: Ctrl+Shift+3 on Windows.
Format as currency: Ctrl+Shift+4 on Windows.
Format as a percentage: Ctrl+Shift+5 on Windows.
Format in scientific notation: Ctrl+Shift+6 on Windows.

Mac keyboards and regional layouts may handle these number-format combinations differently. If a shortcut does not work, use Format > Number and choose the relevant format. That menu is also useful for distinguishing a display problem from a value problem: a date may be stored as a number, for example, and changing its number format changes how it is shown.

To find an unfamiliar command without hunting through menus, press Alt+/ on Windows or Option+/ on Mac to search Sheets menus. This menu search is different from searching cell contents with Ctrl+F or ⌘+F. The shortcut reference, opened with Ctrl+/ or ⌘+/, is the better place to look up keyboard combinations themselves.

How to discover and learn the right shortcuts

It is usually more useful to learn shortcuts by task than to memorize a long list. Start with the actions you repeat: selecting ranges, copying values, finding entries, and moving between tabs. Add a few at a time, and keep the shortcut reference close until they become familiar.

Open a spreadsheet in Google Sheets in your browser.
Press Ctrl+/ on Windows or ⌘+/ on Mac to display the keyboard shortcuts window.
Search or scan the list for a task, and note whether the shown keys match your operating system and keyboard.
Try the shortcut on a small, safe selection before using it across a large range.

A shortcut list can show commands that are unavailable or behave differently in a particular browser or keyboard layout. Sheets may also display a shortcut window with platform-specific information. If a command is not listed or a key is intercepted by the browser, use the corresponding menu or toolbar command rather than assuming the spreadsheet is broken.

Common shortcut problems and safe workarounds

The most common source of confusion is using instructions written for Excel. For example, an Excel guide may describe a ribbon key sequence or a shortcut for a desktop-only feature; that does not make it a Google Sheets command. Confirm that a guide specifically covers Sheets in a browser before relying on it.

A shortcut opens a browser feature: Some browser or operating-system combinations reserve keys. Use the Sheets menu command, or consult the shortcut window for an alternative.
The wrong cells change: Check the selected range and active cell before using fill or formatting shortcuts. Undo with Ctrl+Z or ⌘+Z if the result is incorrect.
The displayed value looks different: A number-format shortcut may change appearance without changing the stored value. Check the formula bar and use Format > Number to choose a suitable display.
Mac keys do not match a Windows guide: Check whether the shortcut uses Command, Control, Option, or a function key. Mac keyboard settings and compact keyboards can affect what must be pressed.

Undo is helpful for many recent edits, but it is not a replacement for checking a large operation before carrying it out. Before filling or changing the format of a large range, confirm the selection. For changes that affect important shared data, consider making a copy of the sheet or using version history as an additional recovery option.

Google Sheets versus Microsoft Excel shortcuts

Both programs share familiar conventions such as copy, paste, undo, find, and selecting rows or columns. That overlap makes it easy to move between them for basic work. Differences become more noticeable in advanced commands, application navigation, and browser-related behavior. Excel for Microsoft 365 on Windows is a desktop application with its own ribbon and shortcut system; Google Sheets is accessed through a browser and has a menu-search shortcut and online collaboration features.

If a keyboard sequence from an Excel tutorial fails in Sheets, look for the equivalent command in the Sheets menus or the keyboard shortcut reference. The reverse is true as well: a Sheets shortcut should not be assumed to work in Excel. For a team that uses both, label instructions by application and operating system—for example, “Google Sheets in Chrome on Windows”—instead of sharing an unlabeled shortcut list.

Frequently Asked Questions

What is the shortcut to see all Google Sheets shortcuts?
Press Ctrl+/ on Windows or ⌘+/ on Mac while Google Sheets is open. The shortcut window shows available commands for the current environment.

How do I paste values only in Google Sheets?
Use Ctrl+Shift+V on Windows or ⌘+Shift+V on Mac. This pastes cell values without the original formulas and formatting.

What is the shortcut to insert today’s date in Google Sheets?
Press Ctrl+; on Windows or ⌘+; on Mac. The shortcut inserts the current date as a fixed value rather than a date that automatically updates.

Do Google Sheets shortcuts work in Excel?
Some common shortcuts are shared, but many commands differ. Check the shortcut reference for the application you are using instead of assuming a Sheets combination will work in Excel.

Why does Ctrl+Space not select a column on my Mac?
macOS can reserve Control+Space for switching input sources. Use the column heading in Sheets or adjust the conflicting system shortcut, then try the Sheets shortcut again.

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.