ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to make the text inside Text Box upside down? (https://www.excelbanter.com/excel-discussion-misc-queries/61350-how-make-text-inside-text-box-upside-down.html)

Kataro

How to make the text inside Text Box upside down?
 
How can I turn the text inside the Text Box upside down?

Example, I want to put in text "ABCDEFG" into the text box, but I want to
rotate it to 180 degree, to make it upside down.

Dave Peterson

How to make the text inside Text Box upside down?
 
How about this....

You put your textbox in an out of the way spot (a different worksheet???)

Then put whatever you want in that textbox.

Option 1.
Select the text box
Edit|Copy
Select the real location
Shift-Edit|Paste Picture
Rotate the picture
This is a static picture of your textbox. If you change the textbox, the
picture doesn't change.

Option 2.
Make the cells surrounding the textbox very small (just barely noticeable)
Select those cells (that include the textbox)
Edit|copy
Select the new location
Shift-Edit|Paste Picture Link
Rotate the picture
This is a "hot" picture. If the textbox gets updated, so does the picture.

Kataro wrote:

How can I turn the text inside the Text Box upside down?

Example, I want to put in text "ABCDEFG" into the text box, but I want to
rotate it to 180 degree, to make it upside down.


--

Dave Peterson


All times are GMT +1. The time now is 09:29 PM.

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