Format Text

How to Format Text in Google Sheets

Google Sheets Training

Google Sheets Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Format Text

A quick way to change the appearance of your spreadsheet is to change the font of the text. A font is a set of letters, numbers, and punctuation symbols designed around a shared appearance. A font will have variations for size and styles, such as bold and italics.

Change Font

  1. Select the cell(s) you want to format.
  2. Click the Font list arrow.
  3. Select a font.
    How to change font in Google Sheets.

The font is changed.

Change Font Size

  1. Select the cell(s) you want to format.
  2. Click the Font Size list arrow.
  3. Select a font size.
    How to change font size in Google Sheets.

The font size is changed.

Apply Font Effects

You can also apply effects to your cells text, such as make it bold, italicized, or underlined, and change its color.

  1. Select the cell(s) you want to format.
  2. Use any of these formatting commands:
    • Click the Bold, Italic, or Strikethrough buttons to emphasize text.
    • Click the Text color button to change the font color.
    How to apply font effects in Google Sheets.

The effect is applied.

Clear Text Formatting

If you went a little overboard, you can remove all formatting from a cell and start over.

  1. Select the cell(s) where you want to clear formatting.
  2. Click Format on the menu bar.
  3. Select Clear formatting.
    How to clear text formatting in Google Sheets.

The formatting is cleared from the cell.