How to change the font color, size, or type in Google Sheets

Updated: 07/06/2021 by Computer Hope
Google Sheets

In Google Sheets, a user can change the properties of text in any cell, including font type, size, color, and make it bold, italic, or underlined. A user can also change the color of a cell's background and the border around a cell. The following picture is a graphic illustration of the font and cell format bar in Google Sheets, with a description of each option.

Google Sheets font and cell format bar

Changing font type

To change the text font in a Google Sheets spreadsheet, follow the steps below.

  1. Select the cell containing the text you want to change.
  2. Click the font option on the format bar, as shown in the image. (If you want to change the text to bold or italic, click the B or I on the format bar. If you want to underline the text, press the Ctrl+U keyboard shortcut).
  3. Select a font type in the drop-down list. If you want more fonts to choose from, select the More fonts option (indicated by green arrow), select the desired fonts to add to the font type list, and click OK.

Google Sheets font type options

Note

If the selected cell does not contain any text, the font type changes as soon as you type new text in the cell.

Changing font size

To change the text size in a Google Sheets spreadsheet, follow the steps below.

  1. Select the cell containing the text you want to change.
  2. Click the size option on the format bar. Usually, the default size is 10, as shown in the image.
  3. Select a font size in the drop-down list. Some fonts may not scale properly, so they may have limited size options.

Google Sheets font size options

Note

If the selected cell does not contain any text, the font size changes as soon as you type text in the cell.

Changing font color

To change the text color in a Google Sheets spreadsheet, follow the steps below.

Note

If you want to change the font color based on a condition, see our conditional formatting page for further help.

  1. Select the cell containing the text you want to change.
  2. Click the text color option on the format bar. It is usually displayed as the letter "A" with a thick black underline, as shown in the image.
  3. Select the color you want to make the text in the cell. If you want a different color than is available in the drop-down menu, click the + (plus) symbol in the Custom section (indicated by green arrow). Select the desired color in the small pop-up window, and click OK.

Google Sheets font color options

Note

If the selected cell does not contain any text, the font color changes as soon as you type text in the cell.

Changing cell background color

To change the cell background color in a Google Sheets spreadsheet, follow the steps below.

Note

If you want to change the cell background color based on a condition, see our conditional formatting page for further help.

  1. Select the cell you want to change the background color.
  2. Click the cell color option on the format bar. It is usually displayed as a tipping paint can with a drop of paint coming out, as shown in the image.
  3. Select the color you want to make the cell background. If you want a different color than is available in the drop-down menu, click the + (plus) symbol in the Custom section (indicated by green arrow). Select the desired color in the small pop-up window, and click OK.

Google Sheets cell background color options

Changing cell border

By default, a cell does not have a border. To change the cell border in a Google Sheets spreadsheet, follow the steps below.

  1. Select the cell you want to add a border.
  2. Click the cell border option on the format bar. It is usually displayed as a four-pane window, as shown in the image.
  3. Select the border type you want to set for the cell.

Google Sheets cell border options

  1. To change the cell border color, click the border color option, as shown in the image.
  2. To change the cell border type, click the border type option, as shown in the image.