ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   excel-stacking type within a cell-HOW?? (https://www.excelbanter.com/excel-worksheet-functions/25603-excel-stacking-type-within-cell-how.html)

TheParaclete

excel-stacking type within a cell-HOW??
 
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.

"TheParaclete" wrote in message
...
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?




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


On Tue, 10 May 2005 15:50:02 -0700, TheParaclete
wrote:

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?




All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com