Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
print cell upside down
Hi. I use Excel to make file tabs for our vertical file cabinet. I create
an entire sheet, which we then cut out. I type the label names in the second, fourth, sixth, etc row, and link to those labels in the first, third, fifth, etc row. (so that I don't need to type twice) I leave the two duplicated labels attached, and fold it over, to have the text printed on both sides (so that you can read the labels no matter which side you approach the cabinet from). The only problem is that the text on one side is now upside down. The text rotation option will only let you rotate 90° in either direction - how do I rotate 180°? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
print cell upside down
Shelly,
You may add text boxes and have the type appear upside down, however, you will need to enter the item in both cells (not just the one cell to be copied). OR, maybe a macro to "redo" all the top ones from the bottom selection. -- Lori DeMoss HP Administrator "Shelly Faye" wrote: Hi. I use Excel to make file tabs for our vertical file cabinet. I create an entire sheet, which we then cut out. I type the label names in the second, fourth, sixth, etc row, and link to those labels in the first, third, fifth, etc row. (so that I don't need to type twice) I leave the two duplicated labels attached, and fold it over, to have the text printed on both sides (so that you can read the labels no matter which side you approach the cabinet from). The only problem is that the text on one side is now upside down. The text rotation option will only let you rotate 90° in either direction - how do I rotate 180°? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
print cell upside down
Hi Lorena - I added a text box, but the flip option is grayed out - and then
I added a shape to which I added text - but when I flipped it - the text stayed right side up!!??! What am I doing wrong? "Lorena" wrote: Shelly, You may add text boxes and have the type appear upside down, however, you will need to enter the item in both cells (not just the one cell to be copied). OR, maybe a macro to "redo" all the top ones from the bottom selection. -- Lori DeMoss HP Administrator "Shelly Faye" wrote: Hi. I use Excel to make file tabs for our vertical file cabinet. I create an entire sheet, which we then cut out. I type the label names in the second, fourth, sixth, etc row, and link to those labels in the first, third, fifth, etc row. (so that I don't need to type twice) I leave the two duplicated labels attached, and fold it over, to have the text printed on both sides (so that you can read the labels no matter which side you approach the cabinet from). The only problem is that the text on one side is now upside down. The text rotation option will only let you rotate 90° in either direction - how do I rotate 180°? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
print cell upside down
I would format the orientation in two adjacent columns to oposite 90° This
will allow you to fold the two cells over and have both readable -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Shelly Faye" wrote in message ... Hi. I use Excel to make file tabs for our vertical file cabinet. I create an entire sheet, which we then cut out. I type the label names in the second, fourth, sixth, etc row, and link to those labels in the first, third, fifth, etc row. (so that I don't need to type twice) I leave the two duplicated labels attached, and fold it over, to have the text printed on both sides (so that you can read the labels no matter which side you approach the cabinet from). The only problem is that the text on one side is now upside down. The text rotation option will only let you rotate 90° in either direction - how do I rotate 180°? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
print cell upside down
A couple of more options.
You could insert a WordArt drawing object and manipulate that the way you want. Insert|Picture|WordArt Or You can type what you want in a range then select that range edit|copy select the new location shift-edit|paste picture link Then rotate that picture the way you want. Shelly Faye wrote: Hi. I use Excel to make file tabs for our vertical file cabinet. I create an entire sheet, which we then cut out. I type the label names in the second, fourth, sixth, etc row, and link to those labels in the first, third, fifth, etc row. (so that I don't need to type twice) I leave the two duplicated labels attached, and fold it over, to have the text printed on both sides (so that you can read the labels no matter which side you approach the cabinet from). The only problem is that the text on one side is now upside down. The text rotation option will only let you rotate 90° in either direction - how do I rotate 180°? -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
print cell upside down
Thank you, Dave - this is too much work for a sheet of thirty labels - but is
worth while for other applications. Thank you for your help. "Dave Peterson" wrote: A couple of more options. You could insert a WordArt drawing object and manipulate that the way you want. Insert|Picture|WordArt Or You can type what you want in a range then select that range edit|copy select the new location shift-edit|paste picture link Then rotate that picture the way you want. Shelly Faye wrote: Hi. I use Excel to make file tabs for our vertical file cabinet. I create an entire sheet, which we then cut out. I type the label names in the second, fourth, sixth, etc row, and link to those labels in the first, third, fifth, etc row. (so that I don't need to type twice) I leave the two duplicated labels attached, and fold it over, to have the text printed on both sides (so that you can read the labels no matter which side you approach the cabinet from). The only problem is that the text on one side is now upside down. The text rotation option will only let you rotate 90° in either direction - how do I rotate 180°? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) | |||
Excel cell looks good in print preview but doesn't print??? | Excel Discussion (Misc queries) | |||
A cell in an excel spreadsheet that does not print but shows in pr | Excel Discussion (Misc queries) | |||
One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) |