← Back to Applications List

Ctrl+Space

Select column

Selects the current column.

💡 Hint: Column

Shift+Space

Select row

Selects the current row.

💡 Hint: Row

Ctrl+A → Ctrl+Shift+Space

Select all

Selects all cells in the sheet.

💡 Hint: All

Ctrl+Z

Undo

Reverts the last action.

💡 Hint: Z

Ctrl+Y → Ctrl+Shift+Z → F4

Redo

Reapplies the last reverted action.

💡 Hint: Redo

Ctrl+F

Find

Finds text in the sheet.

💡 Hint: Find

Ctrl+H

Find and replace

Finds and replaces text in the sheet.

💡 Hint: H

Ctrl+Enter

Fill range

Copies the current cell's contents into the selected range.

💡 Hint: Range

Ctrl+D

Fill down

Copies the cell above into the cell below.

💡 Hint: Down

Ctrl+R

Fill right

Copies the cell on the left into the cell on the right.

💡 Hint: Right

Ctrl+S

Save

All changes are automatically saved to Google Drive.

💡 Hint: Save

Ctrl+O

Open

Opens a file.

💡 Hint: Open

Ctrl+P

Displays the print dialog.

💡 Hint: Print

Ctrl+C

Copy

Copies the selected cells.

💡 Hint: Copy

Ctrl+X

Cut

Cuts the selected cells.

💡 Hint: X

Ctrl+V

Paste

Pastes the clipboard contents.

💡 Hint: V

Ctrl+Shift+V

Paste values only

Pastes only values without formatting.

💡 Hint: Values

Ctrl+/

Show keyboard shortcuts

Displays the list of keyboard shortcuts.

💡 Hint: / = shortcuts

Shift+F11

Insert new sheet

Inserts a new worksheet.

💡 Hint: Sheet

Ctrl+Shift+F

Toggle compact controls

Toggles compact mode for the toolbar.

💡 Hint: Compact

Ctrl+Shift+K

Toggle input tools

Toggles input tools for non-Latin languages.

💡 Hint: Input

Ctrl+Alt+Shift+K

Select input tool

Selects the input tool to use.

💡 Hint: Tool

Alt+/

Search menus

Searches menus and tools.

💡 Hint: / = search

Alt+1

Rename sheet

Renames the active sheet.

💡 Hint: 1

Ctrl+Alt+T

Convert range to table

Converts the selected range into a table.

💡 Hint: Table

Ctrl+B

Bold

Toggles bold formatting for selected cells.

💡 Hint: Bold

Ctrl+U

Underline

Toggles underline for selected cells.

💡 Hint: Underline

Ctrl+I

Italic

Toggles italic formatting for selected cells.

💡 Hint: Italic

Alt+Shift+5

Strikethrough

Applies strikethrough to selected cells.

💡 Hint: Strike

Ctrl+Shift+E

Center align

Centers the content of selected cells.

💡 Hint: Center

Ctrl+Shift+L

Left align

Aligns the content of selected cells to the left.

💡 Hint: Left

Ctrl+Shift+R

Right align

Aligns the content of selected cells to the right.

💡 Hint: Right

Alt+Shift+1

Apply top border

Applies a top border to selected cells.

💡 Hint: 1

Alt+Shift+2

Apply right border

Applies a right border to selected cells.

💡 Hint: 2

Alt+Shift+3

Apply bottom border

Applies a bottom border to selected cells.

💡 Hint: 3

Alt+Shift+4

Apply left border

Applies a left border to selected cells.

💡 Hint: 4

Alt+Shift+6

Remove borders

Removes all borders from selected cells.

💡 Hint: 6

Alt+Shift+7 → Ctrl+Shift+7

Apply outer border

Applies an outer border to selected cells.

💡 Hint: 7

Ctrl+K

Insert link

Inserts a hyperlink into the cell.

💡 Hint: K

Ctrl+Shift+;

Insert time

Inserts the current time into the cell.

💡 Hint: ; time

Ctrl+;

Insert date

Inserts the current date into the cell.

💡 Hint: ; date

Ctrl+Alt+Shift+;

Insert date and time

Inserts the current date and time into the cell.

💡 Hint: ; date/time

Ctrl+Shift+1

Format as number

Formats selected cells as numbers.

💡 Hint: 1

Ctrl+Shift+2

Format as time

Formats selected cells as time.

💡 Hint: 2

Ctrl+Shift+3

Format as date

Formats selected cells as date.

💡 Hint: 3

Ctrl+Shift+4

Format as currency

Formats selected cells as currency.

💡 Hint: 4

Ctrl+Shift+5

Format as percent

Formats selected cells as percent.

💡 Hint: 5

Ctrl+Shift+6

Format as scientific

Formats selected cells in scientific notation.

💡 Hint: 6

Ctrl+\

Clear formatting

Clears formatting from selected cells.

💡 Hint: \

Home

Go to start of row

Moves the cursor to the beginning of the current row.

💡 Hint: Home = beginning

Ctrl+Home

Go to start of sheet

Moves the cursor to the beginning of the sheet.

💡 Hint: Ctrl + Home = sheet start

End

Go to end of row

Moves the cursor to the end of the current row.

💡 Hint: End = end

Ctrl+End

Go to end of sheet

Moves the cursor to the end of the sheet.

💡 Hint: Ctrl + End = sheet end

Ctrl+Backspace

Scroll to active cell

Scrolls so the active cell is in view.

💡 Hint: Backspace = active cell

Alt+↓

Go to next sheet

Moves to the next sheet.

💡 Hint: ↓ = next

Alt+↑

Go to previous sheet

Moves to the previous sheet.

💡 Hint: ↑ = previous

Alt+Shift+K

Show sheet list

Displays the list of sheets.

💡 Hint: Kist

Alt+Enter

Open hyperlink

Opens a hyperlink in the cell.

💡 Hint: Enter = open

Ctrl+Alt+Shift+I

Open Explore

Opens the Explore data side panel.

💡 Hint: Investigate

Ctrl+Alt+. → Ctrl+Alt+,

Move focus to side panel

Moves focus to the side panel.

💡 Hint: ., moves panel focus

Ctrl+Alt+Shift+M

Exit sheet focus

Removes focus from the sheet.

💡 Hint: Move out

Alt+Shift+Q

Go to Sum function

Moves focus to the Sum function.

💡 Hint: Quick sum

Ctrl+Alt+E+P

Move focus to pop-ups

Moves focus to pop-ups like links, bookmarks, or images.

💡 Hint: Pop-ups

Ctrl+Alt+R

Open filter menu

Opens the filter dropdown menu for filtered cells.

💡 Hint: Refine

Ctrl+Alt+Shift+H

Open version history

Opens the version history pane.

💡 Hint: History

Shift+Esc

Close drawing editor

Closes the drawing editor.

💡 Hint: Esc = close

Shift+F2

Insert/edit note

Inserts or edits a note in the sheet.

💡 Hint: F2 note

Ctrl+Alt+M

Insert/edit comment

Inserts or edits a comment in the sheet.

💡 Hint: Momment

Ctrl+Alt+Shift+A

Open comment discussion

Opens the comment discussion thread.

💡 Hint: All discussion

Ctrl+Alt+E+C

Type current comment

Types a reply in the current comment.

💡 Hint: Comment

Ctrl+Alt+N+C

Go to next comment

Moves to the next comment.

💡 Hint: Next comment

Ctrl+Alt+P+C

Go to previous comment

Moves to the previous comment.

💡 Hint: Previous comment

Reply to current comment

Replies to the current comment.

💡 Hint: Reply

Go to next comment (in thread)

Moves to the next comment within the thread.

💡 Hint: Jump

Go to previous comment (in thread)

Moves to the previous comment within the thread.

💡 Hint: Kick back

Resolve current comment

Resolves the current comment.

💡 Hint: Exit

Close current comment

Closes the current comment.

💡 Hint: Undo

Alt+F

[File] menu

Opens the File menu.

💡 Hint: File

Alt+E

[Edit] menu

Opens the Edit menu.

💡 Hint: Edit

Alt+V

[View] menu

Opens the View menu.

💡 Hint: View

Alt+I

[Insert] menu

Opens the Insert menu.

💡 Hint: Insert

Alt+O

[Format] menu

Opens the Format menu.

💡 Hint: Oformat

Alt+D

[Data] menu

Opens the Data menu.

💡 Hint: Data

Alt+T

[Tools] menu

Opens the Tools menu.

💡 Hint: Tools

Alt+M

[Form] menu

Opens the Form menu.

💡 Hint: M Form

Alt+N

[Add-ons] menu

Opens the Add-ons menu.

💡 Hint: N

Alt+H

[Help] menu

Opens the Help menu.

💡 Hint: Help

Alt+A

[Accessibility] menu

Opens the Accessibility menu.

💡 Hint: Accessibility

Ctrl+Alt+=

Open insert menu

Opens the insert menu when a cell is selected.

💡 Hint: = insert

Ctrl+Alt+-

Open delete menu

Opens the delete menu when a cell is selected.

💡 Hint: - delete

Ctrl+Shift+\ → Shift+F10

Context menu

Opens the context menu.

💡 Hint: Menu

Ctrl+Alt+\

Table column menu

Opens the column menu in tables.

💡 Hint: Column menu

Ctrl+Alt+=

Insert row above

Inserts a new row above the selected row.

💡 Hint: = above

Alt+I+R+B

Insert row below

Inserts a new row below the selected row.

💡 Hint: Below

Ctrl+Alt+=

Insert column left

Inserts a new column to the left of the selected column.

💡 Hint: Left

Alt+I+C+O

Insert column right

Inserts a new column to the right of the selected column.

💡 Hint: Right

Ctrl+Alt+-

Delete row

Deletes the selected row.

💡 Hint: - row

Ctrl+Alt+-

Delete column

Deletes the selected column.

💡 Hint: - column

Ctrl+Alt+9

Hide row

Hides the selected row.

💡 Hint: 9

Ctrl+Shift+9

Unhide row

Unhides hidden rows.

💡 Hint: 9

Ctrl+Alt+0

Hide column

Hides the selected column.

💡 Hint: 0

Ctrl+Shift+0

Unhide column

Unhides hidden columns.

💡 Hint: 0

Alt+Shift+→

Group rows or columns

Groups the selected rows or columns.

💡 Hint: → = group

Alt+Shift+←

Ungroup rows or columns

Ungroups selected rows or columns.

💡 Hint: ← = ungroup

Alt+Shift+↓

Expand group

Expands grouped rows or columns.

💡 Hint: ↓ = expand

Alt+Shift+↑

Collapse group

Collapses grouped rows or columns.

💡 Hint: ↑ = collapse

Ctrl+~

Show formulas

Displays all formulas in cells.

💡 Hint: ~

Ctrl+Shift+Enter

Insert array formula

Enters an array formula.

💡 Hint: Enter

Ctrl+E

Toggle expanded array formula

Toggles expansion of array formulas.

💡 Hint: Expand

Shift+F1 → F1

Toggle formula help

Shows or hides formula help while editing.

💡 Hint: F1

Toggle absolute/relative reference

Toggles between absolute and relative references while editing.

💡 Hint: F4

Toggle formula result preview

Toggles formula result preview while editing.

💡 Hint: F9

Ctrl+↑ → Ctrl+↓

Resize formula bar

Moves and resizes the formula bar vertically.

💡 Hint: Ctrl + ↑/↓ (resize)

F2 → Ctrl+E

Toggle formula range selection

Toggles range selection while entering formulas.

💡 Hint: F2

Ctrl+Alt+Z

Enable screen reader support

Enables screen reader support.

💡 Hint: Z

Ctrl+Alt+H

Enable braille support

Enables braille support.

💡 Hint: H

Ctrl+Alt+Shift+C

Read column

Reads out the contents of the current column.

💡 Hint: Column

Ctrl+Alt+Shift+R

Read row

Reads out the contents of the current row.

💡 Hint: Row

Google Sheets