Font and text styling in Google Sheets - Step-by-Step Guide

Introduction

Font and text styling in Google Sheets lets you change how your text looks. You can make text bold, italic, change its color, size, or font style. This helps make your data easier to read and highlights important information.

When you want to make headers stand out in your spreadsheet.

When you need to highlight totals or important numbers in a report.

When you want to change the font color to match your company colors.

When you want to make text easier to read by increasing the font size.

When you want to italicize or underline text for emphasis.

Steps

Step 1: Select the cells with the text you want to style

- Google Sheets grid

The selected cells are highlighted with a blue border

Step 2: Click the Font dropdown

- Toolbar at the top

A list of available fonts appears

💡 Try fonts like Arial or Comic Sans MS for different looks

Step 3: Select a font from the dropdown

- Font dropdown in the toolbar

The text in the selected cells changes to the chosen font

Step 4: Click the Font size dropdown

- Toolbar at the top

A list of font sizes appears

Step 5: Choose a font size

- Font size dropdown

The text size in the selected cells changes accordingly

Step 6: Click the Bold (B), Italic (I), or Underline (U) buttons

- Toolbar at the top

The selected text becomes bold, italic, or underlined

Step 7: Click the Text color button (A with underline)

- Toolbar at the top

A color palette appears

💡 Choose a color to change the text color

Step 8: Select a color from the palette

- Text color palette

The text color in the selected cells changes to the chosen color

Before vs After

Before

Cells show plain black text in default Arial font, size 10, no bold or color

After

Selected cells show text in Comic Sans MS font, size 14, bold, and red color

Settings Reference

Font

📍 Toolbar at the top, Font dropdown

Changes the style of the text

Default: Arial

Font size

📍 Toolbar at the top, Font size dropdown

Changes the size of the text

Default: 10

Bold, Italic, Underline

📍 Toolbar at the top, buttons labeled B, I, U

Adds emphasis by changing text style

Default: Off

Text color

📍 Toolbar at the top, Text color button (A with underline)

Changes the color of the text

Default: Automatic (black)

Common Mistakes

Trying to change font style without selecting any cells

Google Sheets needs you to select cells first to know which text to change

Always select the cells you want to style before applying font or text changes

Using too many different fonts and colors in one sheet

This makes the sheet look messy and hard to read

Use font and color changes sparingly to highlight only important parts

Summary

Font and text styling lets you change how text looks to make data clearer and more attractive.

You can change font type, size, color, and add bold, italic, or underline styles.

Always select the cells first before applying any style changes.

Practice

1. Which toolbar button in Google Sheets would you use to make text bold?

easy

A. The button with a paint bucket icon

B. The button with an I icon

C. The button with a B icon

D. The button with a U icon

Solution

1. Step 1: Identify the bold icon in the toolbar

   The bold button is represented by a capital letter B in bold style.

2. Step 2: Match the icon to the correct function

   Clicking the B icon makes selected text bold.

3. Final Answer:

   The button with a B icon -> Option C

4. Quick Check:

   Bold text = B icon [OK]

Hint: Bold text uses the B icon on the toolbar [OK]

Common Mistakes:

• Confusing italic (I) with bold (B)
• Choosing underline (U) instead of bold
• Selecting paint bucket which changes background color

2. Which of these is the correct way to change the font color of a cell's text in Google Sheets using the toolbar?

easy

A. Right-click the cell and select 'Font Color'

B. Click the paint bucket icon and select a color

C. Click the bold button and choose a color

D. Click the letter A with a color bar underneath and pick a color

Solution

1. Step 1: Identify the font color button on the toolbar

   The font color button shows a letter A with a colored bar below it.

2. Step 2: Understand the paint bucket icon function

   The paint bucket changes the cell background color, not text color.

3. Final Answer:

   Click the letter A with a color bar underneath and pick a color -> Option D

4. Quick Check:

   Font color = A with color bar [OK]

Hint: Font color uses the A icon with a color bar [OK]

Common Mistakes:

• Choosing paint bucket which changes background color
• Thinking bold button changes color
• Right-click menu does not have 'Font Color' option

3. If cell A1 contains the text "Hello" and you apply the formula =UPPER(A1) in cell B1, what will be the font style and text in B1?

medium

A. "HELLO" in uppercase letters, font style unchanged

B. "hello" in lowercase letters, font style bold

C. "Hello" unchanged, font style italic

D. Error because UPPER changes font style

Solution

1. Step 1: Understand the UPPER function effect on text

   The UPPER function converts all letters to uppercase but does not change font style.

2. Step 2: Check the output in cell B1

   Cell B1 will show "HELLO" in uppercase with the default font style (no bold or italic applied).

3. Final Answer:

   "HELLO" in uppercase letters, font style unchanged -> Option A

4. Quick Check:

   UPPER changes text case only [OK]

Hint: UPPER changes text case, not font style [OK]

Common Mistakes:

• Thinking UPPER makes text bold or italic
• Confusing UPPER with formatting tools
• Expecting an error from UPPER function

4. You want to automatically make text red in cells with values less than 50. Which step fixes this conditional formatting rule that is not working?

Rule set: Format cells if "Less than" 50, but text color stays black.

medium

A. Change the rule to "Greater than" 50

B. Set the text color in formatting style to red

C. Remove the conditional formatting rule

D. Change the cell format to bold instead of color

Solution

1. Step 1: Check the conditional formatting rule setup

   The rule "Less than 50" is correct to target cells with values under 50.

2. Step 2: Verify the formatting style applied

   If text color stays black, the formatting style likely does not have text color set to red.

3. Final Answer:

   Set the text color in formatting style to red -> Option B

4. Quick Check:

   Conditional formatting needs style set [OK]

Hint: Set text color in conditional formatting style [OK]

Common Mistakes:

• Changing rule condition instead of style
• Removing rule instead of fixing style
• Changing format to bold does not fix color issue

5. You want to highlight all cells in column B that contain the word "urgent" (case insensitive) by making the text bold and red automatically. Which conditional formatting custom formula should you use?

hard

A. =SEARCH("urgent", B1)

B. =EXACT(B1, "urgent")

C. =REGEXMATCH(B1, "urgent")

D. =LOWER(B1) = "urgent"

Solution

1. Step 1: Understand the need for case-insensitive substring matching

   SEARCH("urgent", B1) finds "urgent" anywhere in the cell ignoring case, returns a number if found (truthy in conditional formatting), or #VALUE! if not (falsy).

2. Step 2: Compare other formulas

   REGEXMATCH is case-sensitive by default; EXACT is case-sensitive exact match; LOWER(B1) = "urgent" requires the entire cell to match exactly after lowering.

3. Final Answer:

   =SEARCH("urgent", B1) -> Option A

4. Quick Check:

   SEARCH for case-insensitive substring [OK]

Hint: SEARCH for case-insensitive substring search [OK]

Common Mistakes:

• Using REGEXMATCH which is case-sensitive
• Using EXACT which is case-sensitive exact match
• Using LOWER(B1) = "urgent" which matches exact cell content only