Google Sheets Keyboard Shortcuts

Google Sheets keeps the Excel navigation and selection keys almost intact, so if you know how to jump to the edge of a range in Excel you already know it here. The differences are in what Sheets adds: paste-values, array formulas and Smart Fill have their own bindings, and a few Excel habits collide with the browser. The table is the Windows/Chrome OS keymap; macOS uses Cmd for Ctrl.

Basic Editing12

Ctrl+C

Copy

Copy the selected cells.

Ctrl+X

Cut

Cut the selected cells.

Ctrl+V

Paste

Paste the copied content.

Ctrl+Shift+V

Paste Values Only

Paste values without formatting.

Ctrl+Z

Undo

Undo the last action.

Ctrl+Y

Redo

Redo the last undone action.

Ctrl+A

Select All

Select the entire sheet.

Ctrl+F

Find

Search cell contents.

Ctrl+H

Find & Replace

Find and replace content.

Delete

Delete Content

Delete the content of selected cells.

F2

Edit Cell

Enter edit mode for the selected cell.

Escape

Cancel Edit

Cancel the current edit.

Cell Navigation10

Ctrl+Home

Go to A1

Jump to the first cell of the spreadsheet.

Ctrl+End

Go to Last Cell

Jump to the last cell with data.

Ctrl+Right

Right Edge

Jump to the right edge of the data range.

Ctrl+Left

Left Edge

Jump to the left edge of the data range.

Ctrl+Down

Bottom Edge

Jump to the bottom edge of the data range.

Ctrl+Up

Top Edge

Jump to the top edge of the data range.

Ctrl+G

Go to Range

Navigate to a specific cell address or range.

Tab

Move Right

Move to the cell on the right.

Shift+Tab

Move Left

Move to the cell on the left.

Enter

Move Down

Move to the cell below after input.

Rows & Columns6

Ctrl+Shift++

Insert Row/Column

Insert a row or column at the selected position.

Ctrl+-

Delete Row/Column

Delete the selected row or column.

Ctrl+Space

Select Column

Select the entire current column.

Shift+Space

Select Row

Select the entire current row.

Ctrl+Alt+9

Hide Rows

Hide the selected rows.

Ctrl+Alt+0

Hide Columns

Hide the selected columns.

Formatting11

Ctrl+B

Bold

Apply or remove bold formatting.

Ctrl+I

Italic

Apply or remove italic formatting.

Ctrl+U

Underline

Apply or remove underline.

Alt+Shift+5

Strikethrough

Apply strikethrough to selected text.

Ctrl+Shift+1

Number Format

Apply number format with 2 decimal places.

Ctrl+Shift+3

Date Format

Apply date format.

Ctrl+Shift+4

Currency Format

Apply currency format.

Ctrl+Shift+5

Percent Format

Apply percentage format.

Ctrl+D

Fill Down

Copy the content of the top cell downward.

Ctrl+R

Fill Right

Copy the content of the left cell rightward.

Ctrl+E

Smart Fill

Auto-fill based on detected patterns.

Formulas5

F4

Toggle Absolute/Relative Reference

Cycle through $A$1 → A$1 → $A1 → A1.

Ctrl+`

Show Formulas

Toggle between showing values and formulas.

Ctrl+;

Insert Today's Date

Insert the current date into the cell.

Ctrl+Shift+:

Insert Current Time

Insert the current time into the cell.

Ctrl+Shift+Enter

Array Formula

Enter as an array formula.

📜 Source: Google Docs Editors Help — Keyboard shortcuts for Google Sheets. Bindings for the desktop browser version; the article lists Windows, Chrome OS and macOS columns. Checked 2026-09-04. How we verify ›

📄 View Printable Cheat Sheet — Download as PDF or print

Moving and selecting like Excel

Ctrl + Down, Ctrl + Up, Ctrl + Left and Ctrl + Right jump to the edge of the current data block, and adding Shift turns the jump into a selection — the same motion as Excel. Ctrl + Space and Shift + Space select a column and a row, Ctrl + Home returns to A1, and Ctrl + G opens a Go To Range box that accepts a cell reference or a named range.

Sheets-only shortcuts

Ctrl + Shift + V pastes values only, discarding formulas and formatting; it is the fix for pasting a calculated column somewhere it should be static. Ctrl + Shift + Enter wraps the formula you are typing in ARRAYFORMULA so it spills down a range. Ctrl + E is Smart Fill: after typing two or three examples of a pattern — splitting names, extracting a domain from an email — it fills the rest of the column. F4 cycles the reference under the cursor between relative and absolute forms exactly as in Excel.

Formatting and dates

Ctrl + Shift + 1, Ctrl + Shift + 3, Ctrl + Shift + 4 and Ctrl + Shift + 5 apply number, date, currency and percent formats. Today's date goes in as a fixed value with Ctrl + ;, and Ctrl + Shift + : stamps the current time the same way — neither updates later. Ctrl + ` toggles between showing values and showing formulas across the sheet, useful for auditing what is calculated and what is typed.

Frequently asked questions

How do I paste values only in Google Sheets?

Ctrl + Shift + V. It pastes the results without formulas or formatting.

What is the shortcut for an array formula?

Ctrl + Shift + Enter while editing a formula wraps it in ARRAYFORMULA.

Does F4 work for absolute references like in Excel?

Yes. Put the cursor on a reference in the formula bar and press F4 to step through A1, $A$1, A$1 and $A1.

Why do some Ctrl shortcuts open browser features instead?

If the sheet does not have keyboard focus the browser handles the key. Click a cell first; inside the grid Sheets captures its own bindings.

No shortcuts found