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. |
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. |
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. |
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