To flip words upside down in Excel, use upside-down Unicode characters in a formula or paste text from a Unicode converter; for a visual label, rotate a text box. Excel’s cell text orientation does not turn ordinary cell text 180 degrees, so choose a method based on whether you need editable cell contents or a rotated object.
The formula below works in Microsoft 365 on Windows and reverses and converts lowercase English letters in a cell. A converter is often quicker for mixed-case text, while a rotated text box is useful for signs and labels. The converted characters may look different depending on the font and device.
What You’ll Need
- Excel for Microsoft 365 on Windows for the formula method. Excel for the web can calculate the formula too, though its editing controls and fonts may differ.
- The text you want to flip, preferably in a cell such as A2 if you plan to use the formula.
- For the converter method, access to a Unicode upside-down text converter. Avoid pasting confidential or sensitive text into a third-party website; use the formula or a trusted offline tool instead.
- For the rotated-object method, a worksheet where you can insert a text box, and enough space to position it.
Step-by-Step
- Decide what “upside down” should mean for your result. A Unicode conversion replaces ordinary letters with similar-looking characters and reverses their order. It can appear upside down when rendered, but it is still a string of different characters, not a true rotation of the original text. Rotating a text box turns the whole object visually. If the result must remain in a cell for sorting, copying, or formula use, start with the formula or converter. If it only needs to look inverted on a worksheet, use a text box.
- Put the source text in a cell for the formula method. Enter a short lowercase example such as
helloin A2. Keep the original in that cell; the converted result will go elsewhere, so you can compare or revise it. The formula below assumes the source text is in A2 and the output will be placed in B2. It reverses the character order and maps lowercase a–z to common upside-down Unicode lookalikes. Uppercase letters, digits, spaces, and punctuation are left unchanged. - Enter the formula in B2. Select B2, paste the formula into the formula bar or the cell, and press Enter. In Excel for Windows, you can also press Ctrl+V to paste the formula. The formula uses LET, SEQUENCE, and XLOOKUP, which are available in Microsoft 365 and supported recent Excel versions. It returns
ollǝɥfor the source texthello. The display of some characters depends on the installed font.
With the source text in A2, this formula returns the reversed, converted text in B2:
=LET(txt,A2,chars,MID(txt,SEQUENCE(LEN(txt),,LEN(txt),-1),1),src,"abcdefghijklmnopqrstuvwxyz",dst,"ɐqɔpǝɟƃɥᴉɾʞןɯuodbɹsʇnʌʍxʎz",TEXTJOIN("",TRUE,XLOOKUP(chars,MID(src,SEQUENCE(LEN(src)),1),MID(dst,SEQUENCE(LEN(dst)),1),chars)))
- Fill the formula down if you have a list. Select B2 and drag its fill handle (the small square at the lower-right corner) down alongside your source entries. Excel adjusts the reference to A3, A4, and so on. Check a few rows, especially if the source cells contain capital letters, numbers, or punctuation, because those characters remain unchanged in this version of the formula.
- Use a Unicode converter when you need a quick result or broader character coverage. Open a reputable upside-down text converter, type or paste the text, and inspect the result before copying it. In Excel, select the destination cell and paste. If the destination should contain only the converted characters, use Paste Special > Values where available, or paste as plain text. Keep in mind that a converter’s handling of uppercase letters, accented characters, emoji, and punctuation varies, so verify the output rather than assuming every character has a perfect inverted counterpart.
- Rotate a text box for a genuinely visual 180-degree turn. In Excel for Windows, choose Insert > Text Box, drag to draw the box, and type the label. Click the text-box border so the object is selected, then open Shape Format > Rotate > Rotate Right 90 twice. The text and box turn together by 180 degrees. You can resize and reposition the object afterward. To rotate it back, use Rotate Left 90 twice. This changes the appearance of an object; it does not put rotated characters into a worksheet cell.
- Check how the result will be used and shared. For a Unicode result, test copying it into the target application and check that the font has the needed glyphs. For a text box, check the worksheet in Print Preview and after saving, especially if the label is close to a cell boundary. If another person needs to edit the actual wording, keep the original text in a separate cell instead of replacing it with the converted characters.
On Excel for Mac, the formula works in Microsoft 365 if those functions are available. The ribbon labels and object-rotation controls can differ by release; select the text-box border and look for the Shape Format rotation controls. In Excel for the web, formulas are supported, but text-box formatting and rotation options may be more limited than in the Windows desktop app. If a needed rotation control is missing, open the workbook in desktop Excel.
Common Mistakes
- Expecting cell orientation to flip text 180 degrees. Home > Alignment includes text-orientation controls for angled or vertical text, but those do not create a true upside-down 180-degree cell-text rotation. Use Unicode conversion or a rotated text box instead.
- Assuming the formula converts every character. The provided formula maps lowercase English letters only. It deliberately leaves capitals, numbers, punctuation, and unsupported characters as they are. A result containing unchanged characters can therefore look only partly inverted.
- Judging the result in just one font. Unicode lookalikes are separate characters, and some fonts may show a square, a substitute glyph, or a character that does not look convincingly inverted. Try another font or use a text box for a dependable visual rotation.
- Replacing the original text too soon. Conversion is not a reversible formatting toggle. Keep a copy of the original wording, particularly when applying the result to a list or a shared workbook.
- Rotating the text-box contents rather than selecting the object. If the cursor is active inside the text, the rotation control may not behave as expected. Click the box’s border first, then use the Shape Format rotation commands.
Tips
- Try the result with a short sample before converting a long paragraph. A phrase such as
hello worldshows how the reversed order and character substitutions work, including the unchanged space. - Keep the source and converted text in adjacent columns. This makes it easy to review errors, retain the normal spelling, and refresh results if the source changes.
- If you want the formula result to become fixed text, copy the result cells and use Paste Special > Values. Do this only after checking that the output is correct; the pasted characters will no longer update when the source changes.
- For a polished sign, use a text box and adjust its size after rotating it. A long, narrow box may occupy more worksheet space in its rotated position, so leave room around it and confirm the placement in Print Preview.
- For mixed-case or multilingual text, use a converter that clearly shows its character coverage, then inspect the copied result. There is no universal upside-down counterpart for every letter, language mark, symbol, or emoji.
Troubleshooting
The formula displays an error. Confirm that A2 contains text and that the formula was pasted with its initial equals sign and straight quotation marks. The formula requires LET, SEQUENCE, and XLOOKUP; if your Excel version does not recognize one of them, update to Microsoft 365 or use the converter or text-box method. If your regional settings expect semicolons instead of commas in formulas, replace the argument separators with the separator Excel requires.
The formula result is blank or not the expected word. Check that the source is actually in A2 and that the formula is in the intended output cell. For example, if you put the source in C2, change the formula’s A2 reference to C2. The formula converts lowercase English letters only, so uppercase input will remain uppercase and unchanged rather than being mapped.
Some characters appear as boxes or look ordinary. That indicates the selected font or the character itself may not support a suitable upside-down glyph. Try a font with broader Unicode support, or use a rotated text box if the goal is visual presentation rather than searchable converted text. For complex scripts and symbols, inspect the result in the program and on the device where it will be viewed.
The text box rotates but is hard to position. Select its border, rotate it, then resize or drag it into place. If the object is clipped, widen the worksheet area or move the box away from the edge of the print area. If rotation options are missing in the browser version, open the file in desktop Excel and make the change there.
Frequently Asked Questions
Can I flip text upside down directly inside an Excel cell?
Not by rotating the cell’s text a full 180 degrees using the standard orientation control. You can put upside-down Unicode characters in a cell, or rotate a separate text box over the worksheet.
Does the formula work with uppercase letters?
The formula provided maps lowercase a–z only. Uppercase letters are returned unchanged. A Unicode converter may handle capitals differently, but results vary because many capitals do not have direct upside-down equivalents.
Will the converted text work when I copy it to another program?
Usually, because the result is Unicode text, but its appearance depends on the receiving program’s font and character support. Test the pasted result in its final destination, especially before using it in a document, message, or printed label.
Can I sort or search converted words?
They are text characters, so Excel can store, copy, and search them as text. However, the converted spelling is different from the ordinary spelling. Keep a normal-text column if you need to sort, filter, or search using the original words.
Can I rotate an entire worksheet cell upside down?
Excel’s regular cell text-orientation settings do not rotate the cell contents 180 degrees. A rotated text box can sit over cells, but it remains a separate object and will not behave like cell data.
Which method should I choose?
Use the formula for repeatable lowercase English text in cells, a converter for a quick result or broader character mapping, and a rotated text box when you need an actual 180-degree visual turn for a label or sign.
Related
- Signature Line in Word Without the X Placeholder Symbol
- Insert a Square Checkbox in Word: Symbol or Clickable Box
- Insert a Personal Signature in Word for Mac: Steps & Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Freeze Specific Columns in Excel While ScrollingTo freeze columns in Excel, select the cell immediately to the right of the last column you want…
- Insert a Blank Checkbox in Word: Printable or ClickableTo insert a blank checkbox in Word, use Insert > Symbol > More Symbols and choose the ballot-box…
- Excel Drop-Down Lists with Named Ranges: Setup and TipsTo create an Excel drop-down list from a named range, define a name for the cells containing your…
- How to Split a Cell in Google Sheets: Text and DataTo split text in a Google Sheets cell into separate columns, select the cell or range, then choose…
- Superscript in Excel: How to Format Text and NumbersTo make text superscript in Excel for Microsoft 365 on Windows, select the characters in the cell, press…
- Outlook Signature: Create a Professional Email Sign-OffTo create a professional signature in Outlook, open the signature settings for your version of Outlook, create a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.