Mirror Image Flip in Excel: What Works and How

How-to basics · Updated November 20, 2026

To mirror a picture in Excel for Microsoft 365 on Windows, select it and choose Picture Format > Rotate > Flip Horizontal. Excel does not provide a direct command to mirror live text or a worksheet range, but you can copy cells as a picture and flip that image, or rearrange the data if you need a reversed column order.

What Excel means by a mirror image

A horizontal flip reflects an object from left to right: its left and right sides switch places. A vertical flip reflects it from top to bottom. In Excel, these commands apply to visual objects such as pictures and many shapes, rather than changing the way ordinary cell contents are rendered. The distinction matters because a picture of a table can be mirrored, while the original cells remain normal and editable.

People often ask about mirror images for different reasons. They might need to correct a selfie or logo, make a graphic face the other direction, prepare a design for transfer paper, or reverse the visual order of a set of columns. Those are related tasks, but they do not all call for the same method. First decide whether you need to flip an image, rearrange data, or reverse characters.

Flip a picture horizontally or vertically

Use this method for a photo, logo, screenshot, or other image already inserted in the worksheet. The flip changes the picture object, not the source file on your computer.

  1. Select the picture. If the contextual tab is not visible, make sure the picture itself—not a cell beside it—is selected.
  2. Open the Picture Format tab on the ribbon.
  3. Choose Rotate in the Arrange group.
  4. Select Flip Horizontal to swap left and right, or Flip Vertical to swap top and bottom.

To undo the change immediately, press Ctrl+Z on Windows. On Mac, use Command+Z. You can also repeat the same flip command to reverse the orientation. If the picture is positioned in a group with other objects, select the individual picture first or ungroup the objects if Excel does not expose the picture-specific tab.

Rotating by 180 degrees is not always the same practical choice as a horizontal flip: a 180-degree rotation swaps both the top and bottom and the left and right. A horizontal flip changes only the left-right orientation. Use the command that matches the intended result.

Mirror a selected cell range as an image

If you want a table or a portion of a worksheet to look mirrored, make a picture of the cells and flip that picture. This preserves the appearance of the selected range, including visible formatting, but the result is an image rather than a live copy of the cell values.

  1. Select the cells you want to include. Adjust column widths, row heights, number formats, and borders first, because the copied picture reflects the range’s displayed appearance.
  2. On the Home tab, open the arrow beside Copy in the Clipboard group and choose Copy as Picture.
  3. In the dialog, choose whether to copy the range as it appears on screen or as it would appear when printed, then choose the picture option and confirm.
  4. Click a suitable destination cell and paste. Select the pasted picture, then choose Picture Format > Rotate > Flip Horizontal or Flip Vertical.

Use the on-screen option when the worksheet display is the appearance you want to reproduce. The printed option is useful when print formatting is the priority, but check the result before relying on it: page scaling and print settings can affect what is shown. A pasted range-picture does not update like a formula-driven range, so make a new picture if the source values or formatting change.

Reverse the order of columns without making an image

If the goal is to put the rightmost column first while keeping the data editable, rearrange or reference the values rather than flipping a picture. For a small table, you can copy its columns into a new area in reverse order. For a larger table, a formula can return the original rows while reversing the source columns.

For example, suppose the source table is in A1:D2, with headings Q1, Q2, Q3, and Q4 in A1:D1 and values 10, 20, 30, and 40 in A2:D2. Enter this formula in F1, then fill it right through I1 and down through I2:

With the source table in A1:D2 and the reversed output beginning in F1, enter =INDEX($A$1:$D$2,ROWS($A$1:A1),COLUMNS($A$1:$D$1)-COLUMNS($A$1:A1)+1) in F1 and fill across and down. The first output row is Q4, Q3, Q2, Q1, and the second is 40, 30, 20, 10.

This formula changes the order of the columns in a separate output area; it does not mirror the shapes of letters or flip the table as a graphic. The references point to the source cells, so the output reflects later source-value changes. If you need a fixed result, copy the output and use Paste Special > Values. Check formulas, merged cells, and relative references in the original data before replacing or moving source columns.

Reverse characters in a cell

Reversing the character sequence is another distinct operation. For example, turning EXCEL into LECXE changes the order of the characters; it does not create mirror-image letterforms. In Microsoft 365, a formula can reverse a text string this way.

With the text in A2, enter =TEXTJOIN("",TRUE,MID(A2,SEQUENCE(LEN(A2),,LEN(A2),-1),1)) in another cell. If A2 contains EXCEL, the result is LECXE. This uses TEXTJOIN and SEQUENCE, available in Microsoft 365 and Excel 2021 or later. The formula returns text in reverse character order, and it may not handle every complex Unicode character as a single visual unit.

To make letters themselves appear reflected, a text formula is not enough. The practical workaround is to render the text as a picture—by copying a cell range as a picture, for example—and flip that picture. This makes the result less accessible and no longer editable as normal text, so keep an editable source alongside it.

What happens to text, charts, and shapes?

Pictures are the most predictable objects to flip. Shapes also have flip commands under the contextual Shape Format > Rotate menu when a shape is selected. However, a shape that contains text is not the same as a text cell, and the resulting visual treatment can depend on the object and its contents. Check the flipped result carefully if legibility or text orientation matters.

A chart is made up of multiple chart elements and is not simply a picture of the plotted data. If you need a mirrored chart appearance, a dependable workaround is to copy the chart as a picture and flip the resulting image. That image will not respond to changes in the chart’s source data. If the aim is to reverse the category order or change which values appear on an axis, use the chart’s axis formatting options instead of mirroring the whole chart; flipping the graphic can make labels and text appear backward.

For live worksheet text, ordinary cell formatting does not include a general mirror-text control. Text orientation and rotation settings can angle or rotate text, but they are not a substitute for reflecting its letterforms.

Choose the method that fits the job

  • Flip a photo or logo: Select the picture and use Picture Format > Rotate > Flip Horizontal or Flip Vertical.
  • Show a worksheet range as a mirrored visual: Copy the range as a picture, paste it, and flip the pasted image.
  • Reverse the order of data columns: Reorder the columns or create a formula-based output. Keep the result as cells if it needs to remain usable in calculations.
  • Reverse letters in a string: Use a text formula such as the Microsoft 365 example above, while remembering that reversed characters are not reflected characters.
  • Prepare something for printing or transfer: Confirm which side needs to be reversed and test with a small print first. A mirror flip may be necessary for some transfer processes, but ordinary documents should generally remain readable.

Think about future edits as well as appearance. An image is convenient for a fixed visual, but it cannot be sorted, searched, or recalculated like cell data. A reversed formula result stays connected to its source, but it changes data order rather than the appearance of the characters.

Common problems and checks

  • The Rotate option is missing: Check that a picture or shape is selected. Selecting a cell only shows the regular worksheet tabs.
  • The picture flips, but the worksheet does not: That is expected. The command affects the selected object, not the cells behind it.
  • The text looks backward: A mirrored image reflects its text too. Use the flip only when that is intended, or keep the text outside the image.
  • The copied picture looks different from the source: Recheck column widths, hidden rows or columns, zoom, print scaling, and the Copy as Picture option you chose.
  • The picture will not stay aligned with the cells: Move or resize it as an object. If it must track worksheet cells, inspect the picture’s size and properties options, and test the behavior when rows or columns change.

For a design that must be printed, inspect a print preview or make a test print. A flip on screen does not guarantee that the final printed item will be oriented as intended, especially if the printer driver or another design application also applies a mirror setting. Avoid applying a second flip accidentally.

Frequently Asked Questions

Can I mirror text directly in an Excel cell?
No general mirror-text command is available for ordinary cell contents. You can rotate or change the orientation of text, reverse the character order with a formula, or convert the displayed text to an image and flip that image. Only the image method reflects the letterforms.

How do I flip a picture in Excel on a Mac?
Select the picture and look for the Picture Format tab and its Rotate menu, then choose the horizontal or vertical flip command if shown in your Excel version. Ribbon organization can differ by Mac release. On Excel for the web, picture-formatting options can also differ from desktop Excel, so use the desktop app if the flip command is unavailable.

Can I mirror a range and keep it editable?
Not as one flipped, live range object. Copy as Picture creates a visual snapshot. To keep values editable, rearrange columns or use formulas to create a reversed output range; that changes the order of the data rather than reflecting its appearance.

Does Flip Horizontal change the original picture file?
No. It changes the orientation of the picture object in the workbook. The image file on your computer is not edited by flipping the object in Excel.

How do I make a mirror image for transfer paper?
Flip the picture or copied range horizontally if the transfer instructions call for a mirrored design, then verify the instructions for the specific material and printer. Make a small test print when possible, since some software or printer settings may already mirror the output.

Bottom line

Excel can flip pictures and other visual objects, but it does not directly mirror live cell text or a regular worksheet range. Use Picture Format > Rotate > Flip Horizontal for an image, copy cells as a picture when you need a fixed mirrored table, and rearrange or reference cells when the data itself must remain editable.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.