excel-stacking type within a cell-HOW??

[Guest]

In an Excel spreadsheet how do I stack the type in the heading of a column?
Example....
Stacking
Excel
Type

Anyone out there that can give me an easy answer?

 

[Steve R]

Pressing Alt/Enter between words should do the trick.

 

[Gord Dibben]

1. Set the cell to Wrap Text then manually manipulate the column width the
get the result.

2. Type Stacking then hit ALT + ENTER then Excel and ALT + Enter then Type
then ENTER.

The ALT + ENTER creates a carriage-return in the cell.

Also set wrap text and column to Autofit.


Gord Dibben Excel MVP