ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   stacked column headings? (https://www.excelbanter.com/excel-discussion-misc-queries/61995-stacked-column-headings.html)

Dale

stacked column headings?
 
Is there a way to stack column headings i.e. "Monthly Balance" becomes
"Monthly" over Balance"?

Ron Coderre

stacked column headings?
 
Try this:
Edit the cell
Place the insertion point after Monthly
Hold down the [Alt] key and press [Enter]
Release the [Alt] key
Press [Enter]

[Alt]+[Enter] puts a "carriage return" into the cell

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Dale" wrote:

Is there a way to stack column headings i.e. "Monthly Balance" becomes
"Monthly" over Balance"?


Dale

stacked column headings?
 
Thank You Ron, that worked great.

"Ron Coderre" wrote:

Try this:
Edit the cell
Place the insertion point after Monthly
Hold down the [Alt] key and press [Enter]
Release the [Alt] key
Press [Enter]

[Alt]+[Enter] puts a "carriage return" into the cell

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Dale" wrote:

Is there a way to stack column headings i.e. "Monthly Balance" becomes
"Monthly" over Balance"?



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

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