ExcelBanter

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

Geebee

Rotate column headings - ???
 
I'm setting up a spreadsheet with only about a dozen columns, but I want each
column to be quite narrow - only wide enough to put an "X" in each cell to
show whether an action was done, or not done. Each column will represent one
department in a hospital, like "Anesthesia".

Is there a way to rotate the column headings 90 degrees, so that each column
heading reads sideways (vertically)? If so, I can get the spreadsheet to
print out on only one page (wide), whereas it would be quite wide if I have
to spell out the department names horizontally - even if I abbreviate them.

Max

Rotate column headings - ???
 
Think the options are available in the Alignment tab
Click FormatCellsAlignment tab
Under Orientation, click to taste OK
(You might need to play with the Text alignment options as well)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Geebee" wrote:
I'm setting up a spreadsheet with only about a dozen columns, but I want each
column to be quite narrow - only wide enough to put an "X" in each cell to
show whether an action was done, or not done. Each column will represent one
department in a hospital, like "Anesthesia".

Is there a way to rotate the column headings 90 degrees, so that each column
heading reads sideways (vertically)? If so, I can get the spreadsheet to
print out on only one page (wide), whereas it would be quite wide if I have
to spell out the department names horizontally - even if I abbreviate them.


Geebee

Rotate column headings - ???
 
Perfect! Thanks Max!

"Max" wrote:

Think the options are available in the Alignment tab
Click FormatCellsAlignment tab
Under Orientation, click to taste OK
(You might need to play with the Text alignment options as well)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Geebee" wrote:
I'm setting up a spreadsheet with only about a dozen columns, but I want each
column to be quite narrow - only wide enough to put an "X" in each cell to
show whether an action was done, or not done. Each column will represent one
department in a hospital, like "Anesthesia".

Is there a way to rotate the column headings 90 degrees, so that each column
heading reads sideways (vertically)? If so, I can get the spreadsheet to
print out on only one page (wide), whereas it would be quite wide if I have
to spell out the department names horizontally - even if I abbreviate them.


Max

Rotate column headings - ???
 
Welcome, Geebee
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Geebee" wrote in message
...
Perfect! Thanks Max!





All times are GMT +1. The time now is 01:02 AM.

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