🎨 Category

Formatting Shortcuts for Google Sheets

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

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

Explore All Google Sheets Shortcuts

Discover all 111 keyboard shortcuts to speed up your workflow and boost your productivity.

View All Shortcuts ➜