| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rotate column headings - ???
Welcome, Geebee
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Geebee" wrote in message ... Perfect! Thanks Max! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
| In Excel can I rotate a column from vertical to horizontal. | Excel Discussion (Misc queries) | |||
| How do I take information in 1 column to make column headings? | Excel Discussion (Misc queries) | |||
| Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
| How I do I rotate text in an excel cell? The rotate commands is g. | Excel Discussion (Misc queries) | |||
Linear Mode
