Excel cell 'headings'

  Scoundrel 14:59 08 Mar 04

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:




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 04

Try Format, Cells, Alignment, Wrap Text.

  stlucia 15:01 08 Mar 04

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

  Big Elf 15:01 08 Mar 04

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

  Big Elf 15:02 08 Mar 04

'Or' should have been 'And'.

  scotty 15:02 08 Mar 04

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

  Scoundrel 15:06 08 Mar 04

Thanks guys!!!

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

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now