Upside down text

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
You can use a text box and then make the text box upside down and the text will be upside down.

You could also use word art and use the rotate options under format.
 
Upvote 0
I've never been able to do this - The last time I needed to do this I used a Text Book formatted to look like the rest of my text and flipped that upside down.

Interested to know if there is a better way though?
 
Upvote 0
As far as I know, the cell formatting limits you to +-90 degrees. So not totally inverted.

You CAN invert a text box. You can have the text in the text box be from a cell.
The text box can be positioned over a cell and the properties should be "Move and size with cells".
Then, if you make the "Line Color" to be "No line" it will appear as a cell.... sort of.
 
Upvote 0
This won't display correctly for many. These forums don't tell your browser to use Unicode.

For Firefox , go to View on the menu Alt+V > Text Encoding > Unicode.


<colgroup><col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> <col style="mso-width-source:userset;mso-width-alt:621;width:13pt" width="17"> <col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> </colgroup><tbody>
[TD="class: xl66, width: 26"]ɐ
[/TD]
[TD="class: xl67, width: 47, align: right"]592[/TD]
[TD="class: xl67, width: 17"] [/TD]
[TD="class: xl66, width: 26"]u[/TD]
[TD="class: xl67, width: 47, align: right"]117[/TD]

[TD="class: xl66"]q[/TD]
[TD="class: xl67, align: right"]113[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]o[/TD]
[TD="class: xl67, align: right"]111[/TD]

[TD="class: xl66"]ɔ[/TD]
[TD="class: xl67, align: right"]596[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]d[/TD]
[TD="class: xl67, align: right"]100[/TD]

[TD="class: xl66"]p[/TD]
[TD="class: xl67, align: right"]112[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]b[/TD]
[TD="class: xl67, align: right"]98[/TD]

[TD="class: xl66"]ǝ[/TD]
[TD="class: xl67, align: right"]477[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ɹ[/TD]
[TD="class: xl67, align: right"]633[/TD]

[TD="class: xl66"]ɟ[/TD]
[TD="class: xl67, align: right"]607[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]s[/TD]
[TD="class: xl67, align: right"]115[/TD]

[TD="class: xl66"]ɓ[/TD]
[TD="class: xl67, align: right"]595[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ʇ[/TD]
[TD="class: xl67, align: right"]647[/TD]

[TD="class: xl66"]ɥ[/TD]
[TD="class: xl67, align: right"]613[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]n[/TD]
[TD="class: xl67, align: right"]110[/TD]

[TD="class: xl66"]ᴉ[/TD]
[TD="class: xl67, align: right"]7433[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ʌ[/TD]
[TD="class: xl67, align: right"]652[/TD]

[TD="class: xl66"]ɾ[/TD]
[TD="class: xl67, align: right"]638[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ʍ[/TD]
[TD="class: xl67, align: right"]653
[/TD]

[TD="class: xl66"]ʞ[/TD]
[TD="class: xl67, align: right"]670[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]x[/TD]
[TD="class: xl67, align: right"]120[/TD]

[TD="class: xl66"]l[/TD]
[TD="class: xl67, align: right"]108[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ʎ[/TD]
[TD="class: xl67, align: right"]654[/TD]

[TD="class: xl66"]ɯ[/TD]
[TD="class: xl67, align: right"]623[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]z[/TD]
[TD="class: xl67, align: right"]122[/TD]

</tbody>


<colgroup><col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> <col style="mso-width-source:userset;mso-width-alt:621;width:13pt" width="17"> <col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> </colgroup><tbody>
[TD="class: xl66, width: 26"]Ɐ[/TD]
[TD="class: xl67, width: 47, align: right"]11375[/TD]
[TD="class: xl67, width: 17"] [/TD]
[TD="class: xl66, width: 26"]N[/TD]
[TD="class: xl67, width: 47, align: right"]78[/TD]

[TD="class: xl66"]ᗺ[/TD]
[TD="class: xl67, align: right"]5626[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]O[/TD]
[TD="class: xl67, align: right"]79[/TD]

[TD="class: xl66"]Ɔ[/TD]
[TD="class: xl67, align: right"]390[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]Ԁ[/TD]
[TD="class: xl67, align: right"]1280[/TD]

[TD="class: xl66"]ᗡ[/TD]
[TD="class: xl67, align: right"]5601[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]Ό[/TD]
[TD="class: xl67, align: right"]908[/TD]

[TD="class: xl66"]Ǝ[/TD]
[TD="class: xl67, align: right"]398[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ᴚ[/TD]
[TD="class: xl67, align: right"]7450[/TD]

[TD="class: xl66"]Ⅎ[/TD]
[TD="class: xl67, align: right"]8498[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]S[/TD]
[TD="class: xl67, align: right"]83[/TD]

[TD="class: xl66"]⅁[/TD]
[TD="class: xl67, align: right"]8513[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]⊥[/TD]
[TD="class: xl67, align: right"]8869[/TD]

[TD="class: xl66"]H[/TD]
[TD="class: xl67, align: right"]72[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]∩[/TD]
[TD="class: xl67, align: right"]8745[/TD]

[TD="class: xl66"]I[/TD]
[TD="class: xl67, align: right"]73[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]Λ[/TD]
[TD="class: xl67, align: right"]923[/TD]

[TD="class: xl66"]ſ[/TD]
[TD="class: xl67, align: right"]383[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]M[/TD]
[TD="class: xl67, align: right"]77[/TD]

[TD="class: xl66"]ꓘ[/TD]
[TD="class: xl67, align: right"]42200[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]X[/TD]
[TD="class: xl67, align: right"]88[/TD]

[TD="class: xl66"]⅂[/TD]
[TD="class: xl67, align: right"]8514[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]⅄[/TD]
[TD="class: xl67, align: right"]8516[/TD]

[TD="class: xl66"]W[/TD]
[TD="class: xl67, align: right"]87[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]Z[/TD]
[TD="class: xl67, align: right"]90[/TD]

</tbody>


<colgroup><col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> <col style="mso-width-source:userset;mso-width-alt:621;width:13pt" width="17"> <col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> </colgroup><tbody>
[TD="class: xl66, width: 26"]0[/TD]
[TD="class: xl67, width: 47, align: right"]48[/TD]
[TD="class: xl68, width: 17"] [/TD]
[TD="class: xl66, width: 26"]⅋[/TD]
[TD="class: xl67, width: 47, align: right"]8523[/TD]

[TD="class: xl66"]6[/TD]
[TD="class: xl67, align: right"]54[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]‾[/TD]
[TD="class: xl67, align: right"]8254[/TD]

[TD="class: xl66"]8[/TD]
[TD="class: xl67, align: right"]56[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]¿[/TD]
[TD="class: xl67, align: right"]191[/TD]

[TD="class: xl66"]ㄥ[/TD]
[TD="class: xl67, align: right"]12581[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]¡[/TD]
[TD="class: xl67, align: right"]161[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl67, align: right"]57[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]„[/TD]
[TD="class: xl67, align: right"]8222[/TD]

[TD="class: xl66"]5[/TD]
[TD="class: xl67, align: right"]53[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"],[/TD]
[TD="class: xl67, align: right"]44[/TD]

[TD="class: xl66"]߈[/TD]
[TD="class: xl67, align: right"]1992[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]˙[/TD]
[TD="class: xl67, align: right"]729[/TD]

[TD="class: xl66"]Ɛ[/TD]
[TD="class: xl67, align: right"]400[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]'[/TD]
[TD="class: xl67, align: right"]39[/TD]

[TD="class: xl66"]ᘔ[/TD]
[TD="class: xl67, align: right"]5652[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]؛[/TD]
[TD="class: xl67, align: right"]1563[/TD]

[TD="class: xl66"]⇂[/TD]
[TD="class: xl67, align: right"]8642[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]

</tbody>

The left hand side is the glyph. The right hand side is the Unicode decimal number. To display the glyph, use the UNICHAR function, =UNICHAR(8513) shows an inverted G.

Have fun.
uɐɯplosᴉɥʇ --
 
Upvote 1
I looked into browser encoding and neither MS Edge nor Google Chrome will let you force the encoding to UTF-8 or some other encoding that allows Unicode. I can only get the page to display correctly in Firefox, and I have to manually set it.

And, among other features these forums don't specify UTF-8 as the encoding. Drat!

Here's a picture:

7pkagLb.png
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question Question
Problems Printing Multiple Tabs with One Tab upside down and Backwards
Replies
5
Views
418
mdmilner
M
PhBarreto
  • Solved
Bar chart is disproportionate to the actual value
Replies
2
Views
230
PhBarreto
PhBarreto
M
  • Question Question
Count number of Occurrences of Name in list
Replies
5
Views
600
alansidman
A
A
  • Question Question
Values based on different scenarios
Replies
1
Views
359
Muhammad_Usman
Muhammad_Usman
J
  • Question Question
Increase negative % or decrease positive %
Replies
1
Views
294
Snakehips
Snakehips

Forum statistics

Threads
1,223,238
Messages
6,170,939
Members
452,368
Latest member
jayp2104

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top