🎨 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 ➜