Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I just receive a spreadsheet that was converted from a PDF file. Due to the poor conversion, the cells contain a mixture of fonts and font sizes. For example in:

Future Insurance

The first character F is in Liberation Sans, size 10 but the rest of the characters are in Arial, size 5.

This is what I have tried so far:

  • Select the entire spreadsheet and set the font to Liberation Sans, size 10. No visible change.
  • Reduce the font size to 8 and then increase it back to 10. Only the first character in all cells react to the change in font size.
  • Select one cell at a time and set the font size. Yes, this works, but is too tedious.
  • Use the format painter. No, it doesn't work.

Any better ideas?

share|improve this question
  1. select all cells
  2. right click on mouse
  3. click on clear direct formatting
share|improve this answer
    
Ah, yes, this does work. A side effect is that all other formatting is lost. But if no better option, then I am willing to take it. – Question Overflow Jul 27 '13 at 13:56

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .