Click here to Skip to main content
Click here to Skip to main content
Go to top

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.

Introduction

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

Background

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

Explanation

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 Smile | :)

History

  • First version submitted on 13/10/2007.

License

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

Share

About the Author

quakeboy
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.

Comments and Discussions

 
GeneralUpsideDownText.com - Flip text in excel PinmemberVenkat Koduru14-Nov-09 10:14 
GeneralVertical dyslexic accountants PinmemberRandor15-Oct-07 8:56 
GeneralRe: Vertical dyslexic accountants Pinmemberquakeboy16-Oct-07 22:30 

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

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

| Advertise | Privacy | Mobile
Web01 | 2.8.140905.1 | Last Updated 13 Oct 2007
Article Copyright 2007 by quakeboy
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid