Vertical text WITHOUT merging?
Is there a way to type vertical text over several cells WITHOUT merging them?
In a regular, horizontally aligned cell you can type into the next cell without merging them. Is there a way to do this vertically without merging the cells together? In case you're curious, this comes about because my boss wants a spiffy new calendar with all the holidays on it. This is to track the leave time of everyone in the building so the days are expressed in the X axis while the names of the workers are expressed in the Y axis. I want to be able to write in the holiday name vertially, while still maintaining the ability to highlight and change the color of a row bisecting that column without changing the entire column. We change the color of the row to indicate what days someone is taking off. If there's another way to solve the problem, let me know. -- Humanity must not only survive, but thrive. |
Vertical text WITHOUT merging?
Try this:
Insert a blank column on the left side of the sheet, then draw a text box large enough to cover the afffected rows that is the width of the column. Format the text box alignment and font as needed. Regards... ChristopherTri "RexTalon" wrote: Is there a way to type vertical text over several cells WITHOUT merging them? In a regular, horizontally aligned cell you can type into the next cell without merging them. Is there a way to do this vertically without merging the cells together? In case you're curious, this comes about because my boss wants a spiffy new calendar with all the holidays on it. This is to track the leave time of everyone in the building so the days are expressed in the X axis while the names of the workers are expressed in the Y axis. I want to be able to write in the holiday name vertially, while still maintaining the ability to highlight and change the color of a row bisecting that column without changing the entire column. We change the color of the row to indicate what days someone is taking off. If there's another way to solve the problem, let me know. -- Humanity must not only survive, but thrive. |
Vertical text WITHOUT merging?
It's so simple! Why didn't I think of that? Thanks!
-- Humanity must not only survive, but thrive. "ChristopherTri" wrote: Try this: Insert a blank column on the left side of the sheet, then draw a text box large enough to cover the afffected rows that is the width of the column. Format the text box alignment and font as needed. Regards... ChristopherTri "RexTalon" wrote: Is there a way to type vertical text over several cells WITHOUT merging them? In a regular, horizontally aligned cell you can type into the next cell without merging them. Is there a way to do this vertically without merging the cells together? In case you're curious, this comes about because my boss wants a spiffy new calendar with all the holidays on it. This is to track the leave time of everyone in the building so the days are expressed in the X axis while the names of the workers are expressed in the Y axis. I want to be able to write in the holiday name vertially, while still maintaining the ability to highlight and change the color of a row bisecting that column without changing the entire column. We change the color of the row to indicate what days someone is taking off. If there's another way to solve the problem, let me know. -- Humanity must not only survive, but thrive. |
All times are GMT +1. The time now is 02:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com