Teacher Tech

Paperless Is Not A Pedagogy

Menu
  • Teacher
    • Blog Posts
    • Teacher Tech Facebook Group
  • Google Certified Innovator
    • CoffeeEDU
    • Tour of Google Classroom
    • Back to Classroom
  • Author
    • Alice Keeler Books on Amazon
    • Bulk Order Books
  • Developer
    • Schoolytics
    • Google Developer Expert
    • Add-ons By Alice Keeler
      • Doc to Slides by Alice Keeler
      • Roster Extras by Schoolytics
      • TemplateTab
      • toTabs
      • Form Printer
      • Quiz Helper
      • Dice Slides by Alice Keeler
      • Scheduler by Alice Keeler
      • Document Outline by Alice Keeler
      • Missing From (Google Forms™)
      • Randomize Slides by Alice Keeler
      • Speaker Notes by Alice Keeler
      • sheetPusher
      • Seating Chart Slides
      • Hyperlink Slides Choice Board
      • Add-a-Date
      • QuickShare Screenshot
      • Anyone Can View
      • Drive 20
    • Apps Script Tutorials
    • Templates
  • EdTech Coach
    • Premium Membership
    • Free Newsletter
  • Hire Alice
Menu

Google Sheets: Partial Formatting Within a Cell

Posted on September 6, 2015May 29, 2018 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

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

Continue Reading

Next Post:
Voice Typing Comes to Google Docs
Previous Post:
Convert Your PDF’s to Google Docs

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
  3. doughpat says:
    September 6, 2015 at 4:43 pm

    Yaaaaaaay! Have been shocked that this doesn’t exist ever since I started using Google Sheets….thanks for pointing it out!

    Log in to Reply

Leave a Reply Cancel reply

You must be logged in to post a comment.

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

Alice Keeler is a mom of 5. Current High School math teacher. Developer for Schoolytics.com. Google Certified Innovator, Microsoft Innovative Educator, Google Cloud Innovator Champion, and Google Developer Expert. Founder of #coffeeEDU
Teaching with Google Jamboard
Developer Schoolytics
Schoolytics is FREE for teachers.

Find ALL My Blog Posts


Link to List

Google Classroom Books

Alice Keeler: Mom of 5. Current High School math teacher. Developer for Schoolytics. Founder #coffeeEDU. Google Certified Innovator. Microsoft Innovative Educator. Google Developer Expert. EdTech Specialist.

My Referral Links


Custom Stickers, Die Cut Stickers, Bumper Stickers - Sticker Mule

 

©2022 Teacher Tech | Theme by SuperbThemes