How to Flip a Picture in Excel: Horizontal or Vertical

How-to basics · Updated November 3, 2026

How to Flip a Picture in Excel: Horizontal or Vertical

To flip a picture in Excel, select it, open the Picture Format tab, then choose Arrange > Rotate > Flip Horizontal or Flip Vertical. Horizontal creates a left-to-right mirror image; vertical reverses the image from top to bottom. You do not need a formula, and the flip does not change the worksheet’s cell values.

What You’ll Need

  • A workbook open in the desktop version of Microsoft Excel for Microsoft 365 on Windows.
  • A picture inserted as a movable object on the worksheet. If you have not added one yet, use Insert > Pictures > This Device and select an image file.
  • Permission to edit the workbook. A protected sheet or restricted file can prevent picture changes.

The directions below are for Windows. Excel for Mac has similar picture-formatting controls, though the tab and ribbon layout can vary slightly. Excel for the web may not expose every picture command; if you cannot find a flip option there, open the workbook in the desktop app.

Step-by-Step

  1. Open the sheet and locate the picture. Click the worksheet tab containing the image. If the picture is difficult to see, zoom in with the zoom slider at the bottom-right of Excel. Make sure you are working with a picture object, not a cell that contains a value or a background image.
  2. Select the picture itself. Click once on the picture. A border and sizing handles should appear around it, and Excel should show the contextual Picture Format tab on the ribbon. If you see a cell cursor instead, click the image again or select it through Home > Find & Select > Selection Pane, then choose the picture’s entry in the pane. The name may be something generic, such as Picture 3.
  3. Open the rotation menu. With the picture selected, choose Picture Format > Arrange > Rotate. If the ribbon is narrow, Excel may collapse the Arrange commands into a smaller menu or show only icons. Widen the Excel window or expand the ribbon if necessary, then look for the Rotate command in the Arrange group.
  4. Choose the flip direction. Select Flip Horizontal to reverse left and right, as if the picture were reflected in a vertical mirror. Choose Flip Vertical to reverse top and bottom. The change should appear immediately on the worksheet. Select only one flip command at a time so you can check which result you need.
  5. Check the result at a useful zoom level. Look for directional details such as a person facing the other way, a logo, a sign, or text embedded in the picture. If the image now reads backward or the subject faces the wrong direction, repeat the flip action to toggle it back, or use Ctrl+Z to undo the most recent change. On Mac, use Command+Z.
  6. Adjust the picture’s position if needed. Flipping changes the image’s orientation, not its intended location in the worksheet. If the result appears to move, check whether you also dragged it or selected a handle. Drag the center of the picture to reposition it; drag a corner handle to resize it while keeping its proportions. Avoid dragging a side handle unless you intend to stretch the image.
  7. Save and verify the workbook. Press Ctrl+S on Windows or Command+S on Mac. If the picture will be printed or shared, check it in Print Preview or reopen the saved file to confirm that the orientation looks right. A flip normally applies to the picture in the workbook, so it should remain visible in the sheet and in a printout.

Choosing between the two commands: For a selfie or a camera image that needs to look like a mirror reflection, start with Flip Horizontal. For an image that is upside down, Flip Vertical may correct its top-to-bottom orientation, but it can make labels and other embedded text upside down too. A flip is a reflection, not a general-purpose rotation; use Rotate Right 90° or Rotate Left 90° from the same Rotate menu when the whole image needs to turn sideways.

Common Mistakes

  • Rotating instead of flipping: Rotate Right 90° turns the entire image. It does not create a mirror image. Use the specific Flip Horizontal or Flip Vertical command when you want a reflection.
  • Clicking the cell instead of the picture: If the Picture Format tab does not appear, Excel may have selected a cell. Click the picture’s visible area, or use the Selection Pane to choose the object.
  • Flipping the wrong object: A worksheet can contain several pictures, shapes, charts, or grouped objects. Confirm the selection outline is around the intended image before using Rotate.
  • Forgetting that text is part of the image: Excel flips the whole picture as one object. It does not recognize and preserve text, faces, or logos separately. Any text baked into the image will be mirrored or turned upside down along with everything else.
  • Dragging a resize handle while trying to select: Dragging a handle changes the size and can distort the image. Click in the center to select or move it; use a corner handle only when resizing.

Tips

  • Keep a source copy for important graphics. Before experimenting with a logo, diagram, or image that is difficult to replace, duplicate it with Ctrl+C and Ctrl+V (Mac: Command+C and Command+V). Move the copy aside or to another sheet so you can compare versions.
  • Use the Selection Pane for crowded sheets. Choose Home > Find & Select > Selection Pane to see and select listed objects. You can also use the pane to hide other objects temporarily, making it easier to work with the picture underneath or beside them.
  • Check the image’s purpose before mirroring it. A mirror effect can be useful for a directional photo, but it can make a product label, map, brand mark, or embedded writing inaccurate. Use a properly oriented source image when factual details must remain readable.
  • Remember the picture is separate from the cells. A floating picture sits over the worksheet grid; flipping it does not flip the cells, formulas, or values beneath it. If the image needs to stay aligned with nearby data, position it carefully after making the change.
  • Use undo immediately if the result is wrong. Ctrl+Z on Windows or Command+Z on Mac reverses the latest edit. If you have made several changes since flipping, use the Undo button’s history list carefully so you do not remove unrelated work.

Troubleshooting

The Picture Format tab is missing. First click the picture, not the cell behind it. If the image is covered by another object, open Home > Find & Select > Selection Pane and select the picture by name. If it still cannot be selected, the worksheet may be protected. Check Review > Unprotect Sheet; you may need the password or permission from the workbook owner.

Rotate is visible, but the flip commands are not. Expand the ribbon or the Rotate dropdown, and confirm the selected object is a picture. A shape, chart, or group can show a different contextual tab and different controls. If you are using Excel for the web and the command is unavailable in your current interface, choose Open in Desktop App and use the Windows steps above. On Mac, select the picture and look for the Rotate or Arrange controls on the Picture Format ribbon; labels and placement can differ by build.

The image looks backward after flipping. That is expected when the picture contains writing, a logo, a number, or a recognizable asymmetrical detail. Repeat the same flip command to restore the previous orientation, or press the undo shortcut immediately. If only one part of the image should be mirrored, edit that part in an image editor and insert the corrected image; Excel flips the selected picture as a whole.

The picture does not behave like a movable object. Some Excel versions support pictures placed inside cells, which behave differently from floating pictures. If the image is stored in a cell and the picture-format controls are unavailable, insert a separate floating copy with Insert > Pictures > This Device, then flip that object. You can remove the original only after checking that the replacement is correct and that the workbook still meets your needs.

The flip seems to disappear after saving or sharing. Save the workbook as an Excel file, such as .xlsx, rather than relying on a screenshot or a copied preview. Reopen the workbook and inspect the image. If another person is using an older or web-based version, ask them to open it in desktop Excel if their view does not show the picture controls; the saved image orientation itself should be part of the workbook.

Frequently Asked Questions

How do I mirror a picture left to right in Excel?
Select the picture, then choose Picture Format > Arrange > Rotate > Flip Horizontal. This reflects the image across a vertical axis, reversing left and right.

How do I turn a picture upside down?
Select it and choose Picture Format > Arrange > Rotate > Flip Vertical. This reverses the top and bottom of the image. If you mean turn it around by a half-turn, applying both horizontal and vertical flips has the same overall orientation effect as a 180-degree rotation, though the commands are still reflections.

Can I flip a picture without flipping its text?
Not when the words are part of the picture itself. Excel treats the image as one object, so the text mirrors along with it. Use an unmirrored source image or edit the image externally if the text must remain readable.

Can I flip a picture in Excel for Mac?
Yes, Excel for Mac generally provides picture flip controls after you select the image. Look on the Picture Format ribbon for Rotate or the Arrange controls, then choose the horizontal or vertical flip command. The layout can differ from Windows, so the command may be in a different place.

Does flipping a picture change the cells underneath it?
No. A floating picture is an object positioned over the grid. Flipping it changes the picture’s orientation only; it does not alter cell contents, formulas, or formatting.

How do I undo a flip?
Immediately press Ctrl+Z on Windows or Command+Z on Mac. You can also apply the same flip command again to toggle the picture back, provided you have not changed its orientation in another way since.

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.