Excel cell 'headings'

  Scoundrel 14:59 08 Mar 2004
Locked

Is it possible to type headings on a sheet so that it occupies 2 lines?

For example if I make cell A1, B1, C1 etc double the normal height and keep the font size the same can I change the text from:

b/fin

to:

Best
Final

So far I have found no way to do this, the text always sits at the bottom of the cell regardless of font size.

Regards - DEANE

  Big Elf 15:00 08 Mar 2004

Try Format, Cells, Alignment, Wrap Text.

  stlucia 15:01 08 Mar 2004

Try Format/Cells/Alignment and check the 'Wrap text' button.

  Big Elf 15:01 08 Mar 2004

Or enter the 1st word then hold down Alt and press enter then enter the next word.

  Big Elf 15:02 08 Mar 2004

'Or' should have been 'And'.

  scotty 15:02 08 Mar 2004

Goto Format, select Cell, select the Alignment tab and tick Wrap text.

  Scoundrel 15:06 08 Mar 2004

Thanks guys!!!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Illustrator of witty, relatable Instagram comics Julia Bernhard touches on our humble moments

iMac Pro review

Quelle est la meilleure application de podcast pour Android (2018) ?