Mixed Font Size in Same Cell Fails

Dear Experts,
I am trying to format an Excel 2007 column heading with a title and subtitle in the same cell. I use Alt+Enter to put the sub-title on its own line, and then I highlight the subtitle and make the font-size smaller. This looks fine in edit mode (F2), but when I save the change, the title and sub-title both display the original font-size. If I press F2 again, I see the changes made to the sub-title font size, but it disappears again once I save the cell.
Any help on this would be greatly appreciated.
MCallas
MCallasAsked:
Who is Participating?
 
MCallasAuthor Commented:
I figured it out. The cell must me formatted as General. I had it formatted as Accounting. Works great now!
MCallas
0
 
DALSOMCommented:
Hi,
Check if you are saving in xlsx or excel document format!

Works flawlessly with excel 2007, but when I use CSV format, cell's format just go!

Not all features from 2007 or 2010 works fine in a lower version of excel.

I hope this help.
0
 
MCallasAuthor Commented:
DALSOM,
Thanks for the thought. I am saving in in the XML format (using .xlsm, though I tried .xlsx and I get the same results).
MCallas
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
DALSOMCommented:
Hi, I just do it!

Save in xml 2003 format. It worked for me.

But remember the excel advice, that not all your features will be available!!

Hope this help :)
0
 
MCallasAuthor Commented:
DALSOM,
All due respect, saving an Excel 2007 file to an Excel 2003 format is not a solution. My workbook is filled with code-behind and links to other worksheets, so I can't take any chances that "something" may not work. For what it's worth, I saved a copy to .xlt just to test it, and it did not fix the issue either. I suspect a setting somewhere, I just don't know where to look.
Thank you, though, for your input.
Michael
0
 
MCallasAuthor Commented:
I kept trying different things and when I formatted the cell as General, the mixed font sizes displayed properly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.