Excel '03 - different font colors in one cell leaves gaps between text - TechRepublic
Question
April 16, 2008 at 12:53 PM
charliespencer

Excel ’03 – different font colors in one cell leaves gaps between text

by charliespencer . Updated 18 years, 3 months ago

I have a spreadsheet with a row of headings. In each cell I may have two to five different colors of text, with a comma, or slash between each different colored block of text. The separation between each block is much wider than it is when everything is a single color.

As a way to portray this here, I’m going to use underscores ( _ ) to indicate spacing. A string all in a single color may look like:

IE_6,_7,_8

but if I put the ‘6’, ‘7’, and ‘8’ each in a different color, I get

IE___6,_______7,_____8

The distance between color blocks appears to be random. If I change everything back to a single color, the spacing returns to normal. The text is rotated 90 degrees vertically with the first character at the bottom of the cell. Word wrap is turned on; This problem existed before I installed SP 3.

This discussion is locked

All Comments