🎨 Category

Formatting Shortcuts for Google Sheets

Format cells, text, and numbers quickly with keyboard shortcuts. Browse all 24 shortcuts below.

Ctrl + B
BoldApply bold formatting to the selected cells to emphasize important data.
Ctrl + U
UnderlineApply underline formatting to the selected cells.
Ctrl + I
ItalicApply italic formatting to the selected cells.
Alt + Shift + 5
StrikethroughApply strikethrough formatting to cross out text in selected cells.
Ctrl + Shift + E
Center AlignCenter-align the content in the selected cells.
Ctrl + Shift + L
Left AlignLeft-align the content in the selected cells.
Ctrl + Shift + R
Right AlignRight-align the content in the selected cells.
Alt + Shift + 1
Apply Top BorderApply a border to the top edge of the selected cells.
Alt + Shift + 2
Apply Right BorderApply a border to the right edge of the selected cells.
Alt + Shift + 3
Apply Bottom BorderApply a border to the bottom edge of the selected cells.
Alt + Shift + 4
Apply Left BorderApply a border to the left edge of the selected cells.
Alt + Shift + 6
Remove BordersRemove all borders from the selected cells.
Alt + Shift + 7
Apply Outer BorderApply outer borders around the selected cell range.
Ctrl + K
Insert LinkInsert or edit a hyperlink in the selected cell.
Ctrl + Shift + ;
Insert TimeInsert the current time into the selected cell as a static value.
Ctrl + ;
Insert DateInsert today's date into the selected cell as a static value.
Ctrl + Alt + Shift + ;
Insert Date and TimeInsert both the current date and time into the selected cell.
Ctrl + Shift + 4
Format as CurrencyApply currency formatting with a dollar sign to the selected cells.
Ctrl + Shift + 5
Format as PercentageApply percentage formatting to the selected cells.
Ctrl + Shift + 6
Format as ExponentApply scientific notation (exponent) formatting to the selected cells.
Ctrl + Shift + 3
Format as DateApply date formatting to the selected cells.
Ctrl + Shift + 2
Format as TimeApply time formatting to the selected cells.
Ctrl + Shift + 1
Format as NumberApply decimal number formatting to the selected cells.
Ctrl + \
Clear FormattingRemove all formatting from the selected cells while keeping the data.

📚 Explore All Google Sheets Shortcuts

Discover all 111 keyboard shortcuts across 8 categories

View All Shortcuts ➜

Browse Other Categories

⚡

Common Actions

Essential everyday shortcuts for Google Sheets productivity.

25 shortcuts

🧭

Navigation

Navigate spreadsheets efficiently with keyboard shortcuts.

17 shortcuts

🔢

Formulas

Work with formulas and functions using keyboard shortcuts.

6 shortcuts

📊

Rows & Columns

Insert, delete, hide and manage rows and columns.

14 shortcuts

💬

Notes & Comments

Add notes, comments, and collaborate with your team.

6 shortcuts

📋

Menus

Open and navigate menus using keyboard shortcuts.

13 shortcuts

♿

Accessibility & Screen Readers

Accessibility shortcuts for screen readers and braille support.

6 shortcuts