Click here to Skip to main content
13,666,087 members
Click here to Skip to main content
Add your own
alternative version


8 bookmarked
Posted 12 Oct 2007
Licenced CPOL

Upside down text in MS Excel

, 12 Oct 2007
Rate this:
Please Sign up or sign in to vote.
A way to get upside down text with data from another cell.


Here is a different way of getting upside down text in Excel. It uses WordArt to show the text from any cell upside down.

Screenshot - upside_down_text_excel.gif


Some times at work, we get into situations where we need to get some peculiar things done. This was one such for me.

Using the Code

Create a WordArt in Excel and then right click it, select Format WordArt, and change it to look like almost simple plain text. Rotate it 180 degrees, and make it upside down.

Then, open the Visual Basic Editor in MS Excel by using Alt+F11, and enter in the code by double clicking the sheet in which you have the WordArt inserted.

Private Sub Worksheet_Change(ByVal Target As Range)
    Shapes(1).TextEffect.Text = Cells(1, 1)
    Shapes(1).Width = Len(Cells(1, 1)) * 6.5
End Sub


The code does two things:

  1. Take the text in the cell (Row 1, Column 1) and set the WordArt's text to be the same.
  2. Then, adjust the width of the WordArt according to the string length of the text.

The Width adjustment code presently works fine for numbers. I wanted to show only numbers upside down. Please change the multiplier accordingly for other fonts and letters.

Points of Interest

The Width adjustment part can be improved by analysing more and getting a more accurate width. This is just a newbie's way to solve peculiar problems :-)


  • First version submitted on 13/10/2007.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Web Developer
India India
Hi, I am a Developer in Bangalore India in the areas of .NET, VSTO, OpenGL, PHP, C++

I love blogging, web designing, game programming etc.

You may also be interested in...

Comments and Discussions - Flip text in excel Pin
Venkat Koduru14-Nov-09 10:14
memberVenkat Koduru14-Nov-09 10:14 
GeneralVertical dyslexic accountants Pin
Randor15-Oct-07 8:56
memberRandor15-Oct-07 8:56 
GeneralRe: Vertical dyslexic accountants Pin
quakeboy16-Oct-07 22:30
memberquakeboy16-Oct-07 22:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web01-2016 | 2.8.180810.1 | Last Updated 13 Oct 2007
Article Copyright 2007 by quakeboy
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid