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

Fujitsu Lifebook P727 laptop review

Best of the Grad Shows 2017: University of the West of England (UWE)

Best value Mac: Which is the best £1249 Mac to buy

Les meilleures GoPro 2017