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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…