"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Format Only Part Of The Text Within A Cell

Everyone knows how to apply formatting to text in cells using color, bold, italics, font size, etc... You may not be aware of this little trick that will give you new options for formatting your Excel worksheets.

Did you know that you can apply specific formatting to just part of the text within a cell. For example, you could apply a different color to each word in a string of text within a cell.

Here's how...

  1. Select the cell.
  2. Highlight the text within the cell that you want to apply the formatting to.
  3. Apply the formatting as you normally do. Don't press Enter yet!
  4. Select and apply formatting to other parts of the text.
  5. When you're done just press Enter.

    Why not print (CTRL+P) this tip and share it with your friends and associates?

    Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
    You'll be amazed how much time you'll save just by learning a few of these tips.

    Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.