To flip text completely upside down in Excel, put it in a text box, select the box, then choose Shape Format > Rotate > Rotate Right 90° twice. You can also set its rotation to 180°. Excel’s cell text-orientation controls do not rotate cell contents through 180°, so a text box is the practical option for a fully inverted label.
What You’ll Need
- Excel for Microsoft 365 on Windows, or a recent desktop version of Excel.
- The text you want to turn upside down and a worksheet where you can place a text box.
- Optional: a cell containing the text, if you want the text box to display that cell’s value and update when it changes.
A text box is a separate object placed on top of the worksheet, not a cell-formatting setting. You can position it over a cell to make it look like a cell label, but it will not become part of the cell itself. Keep that distinction in mind if you sort, filter, resize rows, or print the sheet.
Step-by-Step
- Choose where the upside-down text should appear. Decide whether the label belongs over a particular cell, in a diagram, or somewhere else on the sheet. If it should sit over a cell, note the cell’s location and make sure there is enough room for the text box to fit. You can adjust row height or column width later, but the text box remains a separate object.
- Insert a text box. On the Windows ribbon, select Insert > Text > Text Box. The pointer changes to a drawing cursor. Click and drag on the worksheet to draw a box approximately the size you need. Avoid dragging across a large range unless you want a large object; you can refine its dimensions after entering the text.
- Type or add the text. Click inside the new box and type the label. If you already have the text in a cell and want the box to show the cell’s value, select the box’s outer edge, click the formula bar, type a reference such as
=A1, and press Enter. Replace A1 with the cell that contains your text. The box then displays that cell’s contents; changing the source cell updates the displayed text. If the reference does not appear to take, make sure the box’s border is selected rather than the text-editing cursor being active inside it. - Select the whole text box. Click its border so the sizing handles appear around the object. If you see a text cursor inside the words, click the border again or press Esc once, then select the border. Rotation applies to the selected object; selecting and editing the text itself can make the rotation controls harder to find.
- Rotate the box by 180 degrees. Choose Shape Format > Rotate > Rotate Right 90°, then repeat the same command. The two quarter-turns make a half-turn, leaving the text upside down and reading in the opposite direction. Depending on the ribbon layout, Rotate is in the Arrange group on the Shape Format tab. You may instead choose Rotate > More Rotation Options and enter 180 in the Rotation field in the Format Shape pane. If your version shows a rotation field under Size & Properties, enter 180 there.
- Check the result and refine the layout. Confirm that the letters are upside down, not merely arranged vertically. Drag the box to position it, and use its corner handles to adjust its size. Use the Shape Format options to remove a border or fill if you want the text to sit visually on the worksheet without a box. For example, choose Shape Fill > No Fill and Shape Outline > No Outline if those options are available in your ribbon. If the text gets clipped, enlarge the box or reduce the font size.
- Check printing and placement. Open File > Print to preview the page before printing. Make sure the text box is within the print area and is not covering important cell contents. If the workbook will be shared, save it and reopen it in the intended version of Excel to confirm that the object remains in the expected position.
On Excel for Mac, the same basic method works: insert a text box, select its border, and use the Shape Format tab’s rotation controls. The ribbon arrangement can differ by version, so look for Rotate in the Arrange group, or open the formatting pane and enter 180 in its rotation setting. Excel for the web may have fewer or differently placed drawing controls; if you cannot find the rotation setting, open the workbook in the desktop app to set the angle.
Common Mistakes
Using cell orientation and expecting a 180-degree flip. Selecting a cell and changing its text orientation is useful for angled or vertical labels, but it does not provide a 180-degree cell-text rotation. In Format Cells > Alignment, the Orientation control can angle text within its available range, but it cannot turn ordinary cell contents completely upside down. Use a text box when the letters themselves must be inverted.
Choosing vertical text instead of rotating the object. Vertical text may stack characters or display them in a vertical direction. That is different from turning the complete word upside down. If the word should read with its top at the bottom of the page, select the text box and rotate it 180 degrees.
Rotating only 90 degrees. One click on Rotate Right 90° makes the text sideways, not upside down. Use the command twice, or enter 180 in the rotation setting. If it ends up upright but facing the opposite direction, check whether the selected angle is 0 rather than 180.
Resizing the box by a side handle. Side handles change one dimension and can squeeze the text. Corner handles are usually easier for resizing while keeping the box’s proportions. If the box seems to move instead of resize, confirm that the pointer is on a handle, not on the border between handles.
Forgetting that the box is a separate object. A text box placed over cell A1 is not stored in A1. Sorting rows, changing the layout, or moving cells may not move the box the way you expect. Do not rely on its visual position to mean that its text belongs to that cell.
Tips
For a clean label, format the text before fine-tuning its position. Choose a readable font size, alignment, and text color while the box is selected. Then rotate it and make the box large enough that the full text is visible. A little extra space around the lettering can make a rotated label easier to read, especially when the box is printed small.
If you want the upside-down label to appear as though it is inside a cell, set the text box’s fill and outline to none, then place it carefully over the cell. You may want to adjust the row height and column width first. Zooming in can make precise placement easier; return to a normal zoom level afterward to judge how the sheet will look at typical size.
Use the alignment guides that appear while dragging to line the object up with nearby cells or shapes. For repeat labels, duplicate a correctly formatted box and change its text rather than creating each one from scratch. This preserves the rotation and styling. If you need the text to change with a cell, link the box to that cell as described above, and keep the source cell in a predictable location.
Consider object placement settings if the worksheet layout will change. Right-click the box and choose Format Shape, then look in Size & Properties for the properties that control how the object behaves with cells. Depending on your version, you can choose whether the object moves or resizes with cells, moves without resizing, or stays independent. Pick the option that best matches how you expect the label to behave when rows or columns change.
Finally, keep a copy of the original cell text if it is important data. A text box can be moved or deleted independently, and a linked box depends on its source cell. For a worksheet others will edit, label the source cell clearly or add a short note so another person can find and update the text.
Troubleshooting
The Rotate command is missing or disabled: Select the outside border of the text box, not a cell or the text cursor inside the box. The Shape Format tab appears when a shape or text box is selected. If it still does not appear, click elsewhere and then click the box’s edge again. On a narrow window, some ribbon commands may be grouped or hidden; expand the ribbon or open the Arrange group.
The text is sideways, not upside down: Set the rotation to 180 degrees, or apply Rotate Right 90° a second time. Do not use the cell’s Orientation control for this result. Check the displayed angle in the Format Shape pane if you are unsure which turn was applied.
The text disappears after rotation: The text may be outside the visible part of a small box, obscured by another object, or displayed in a color that blends into the background. Enlarge the box with a corner handle, bring it forward using the Arrange controls if another shape covers it, and check the font color and fill. Also make sure the font size is not so large that the rotated words no longer fit.
The box moves when you change the worksheet: This is a placement setting issue, not a rotation failure. Right-click the box, open Format Shape, and review Size & Properties. Choose the move-and-size behavior that suits your sheet, or reposition the object after adjusting rows and columns. For a fixed-position visual label, an option that does not move or resize with cells may be more predictable, though it can become misaligned if the layout changes.
The label looks right on screen but is cut off in print: Use File > Print to inspect the preview. Check the print area, page orientation, scaling, and margins. Move the text box inside the printable region or adjust the page layout. If the box sits on a page boundary, a small on-screen margin may not be enough for the printer.
Frequently Asked Questions
Can I flip text upside down directly inside an Excel cell?
No. Excel’s standard cell alignment controls can rotate text within their supported angle range, but they do not turn cell contents through 180 degrees. Put the text in a text box and rotate the box instead.
Does rotating a text box also rotate the words?
Yes. Rotating the text box object by 180 degrees turns the text with it. The border and fill rotate too, which is why setting them to no fill and no outline can help the text look like it belongs directly on the sheet.
Can I rotate text 180 degrees without turning it upside down?
A 180-degree rotation is the upside-down orientation: the top of each letter faces down, and the text reads in the opposite direction. If you mean mirrored lettering rather than upside-down lettering, rotation alone is not the same effect. You may need to use a picture or another design tool for mirror-image text.
Will an upside-down text box stay aligned with its cell?
Not automatically in every situation. The text box is an independent object, and its behavior when cells move or resize depends on its object properties. Set the appropriate option in Format Shape > Size & Properties, then test by resizing the relevant row or column.
Can I make the box display text from a cell?
Yes. Select the text box border, enter a cell reference such as =A1 in the formula bar, and press Enter. The box displays the referenced cell’s value and updates when that value changes. This links the displayed content; it does not turn the text box into a cell.
Can I use this method in Excel for the web?
It depends on the drawing and formatting controls available in your web version. If you can insert and select a text box but cannot find a rotation field or Rotate command, open the workbook in Excel for Windows or Mac desktop to set the 180-degree rotation.
Related
- Insert a Checkbox in Word Without the Developer Tab
- Insert a Checkbox in Word: Shortcut and Options
- Insert a Blank Checkbox in Word: Printable or Clickable
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut Cheat Sheet for Windows and MacAn Excel shortcut cheat sheet is a quick reference to keyboard commands for editing cells, moving around worksheets,…
- Out of Office in Outlook: Set Up Automatic RepliesTo set an out-of-office message in Outlook, open Automatic replies, turn them on, write your message, and choose…
- How to Get Out of Replace Mode in Excel and Restore TypingTo get out of Overtype (replace) mode in Excel for Microsoft 365 on Windows, click inside the cell…
- How to Double Space in Word 365: Text and ParagraphsTo double-space text in Word 365 on Windows, select the text—or press Ctrl+A to select the document—then choose…
- How to Half Shade a Cell in Excel: Practical MethodsTo half shade a cell in Excel, place two colored triangle shapes over the cell and align them…
- How to Locate Duplicates in Google Sheets: A WalkthroughTo locate duplicates in Google Sheets, select the cells you want to check, choose Format > Conditional formatting,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.