Google Sheets: Partial Formatting Within a Cell

Posted on by Alice Keeler

google sheets partial formatting in a cell

If you have ever wanted to emphasize a word within a cell on a spreadsheet but were restricted to the same formatting for the entire block of text then you are going to really happy. Google Sheets can now allow you to bold, change font color or increase font size on selected text within the cell.

Edit formatting within a cell

 

Double Click

When you single click on a cell in a spreadsheet you are able to apply features to the cell from the toolbar, such as bolding all of the text in the cell. If you double click on a cell you are in edit mode of the cell.

Select Text

You can highlight a word or multiple words and apply text size, color, bolding, underlining or italics to the selected text. You are also able to change the font type for selected text within the cell.
Different Formatting in a cell

Related Alice Keeler Blog Posts:

  1. Google Forms: Trick for Listing a Lot of Dates
  2. Google Forms: Daily Sign In – Identifying Struggling Students
  3. Google Docs: Prompt Students to Make a Copy
  4. Google Sheets: Give Each Student Their Own Tab

3 thoughts on “Google Sheets: Partial Formatting Within a Cell”

  1. Pingback: Google Sheets: Partial Formatting Within a Cell |… | EducatorAl's Tweets
  2. Pingback: Google Sheets: Partial Formatting Within a Cell | Instructional Know-How

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: