To flip a picture in Excel, select it, open the Picture Format tab, choose Rotate in the Arrange group, then select Flip Horizontal or Flip Vertical. Horizontal makes a mirror image from left to right; vertical turns the image upside down. The steps below are for Microsoft 365 on Windows, with notes for Mac and Excel for the web.
What You’ll Need
- An Excel workbook and an image that you can select as a picture object. If you have not added the picture yet, use Insert > Pictures and choose its source.
- Excel for Microsoft 365 on Windows for the menu path in the main instructions. On Mac, use the corresponding Picture Format controls; Excel for the web may not show every picture-editing command.
- If the image is important, save a copy of the workbook first. Flipping is reversible, but a backup is useful if you are changing several images or editing a shared file.
Step-by-Step
- Open the workbook and find the picture. Go to the worksheet containing the image. Click once on the picture itself, not on the cell behind it. A selection border with sizing handles should appear around the image, and the ribbon should show a Picture Format tab. If the picture is partly covered or difficult to select, see Troubleshooting below.
- Check that you selected a picture object. The Picture Format tab is the useful clue. If you see a cell selection and no picture tools, click the image again or use Home > Find & Select > Selection Pane to locate and select it by name. The Selection Pane is especially helpful when several pictures overlap or sit close together.
- Open the picture rotation menu. On the ribbon, select Picture Format. In the Arrange group, choose Rotate. Depending on the width of the Excel window, Arrange commands may be compressed or shown as icons. Widen the window or expand the group if you cannot see the command.
- Choose the direction of the flip. Select Flip Horizontal to reverse the image from left to right, like a mirror. Select Flip Vertical to reverse it from top to bottom. The change should apply immediately. If you chose the wrong direction, open Rotate again and choose the other option, or undo the change with Ctrl+Z.
- Check the result at a useful zoom level. Look closely at text, logos, arrows, faces, and other details that reveal whether the image is mirrored or upside down. A horizontal flip can reverse lettering, which may be undesirable for a logo or sign. A vertical flip changes which parts appear at the top and bottom, but does not simply turn a picture sideways.
- Adjust the picture if needed. Flipping changes the picture’s orientation, not its intended size or placement. If the image now needs repositioning, drag it by its edge. To change its size while keeping its proportions, drag a corner sizing handle. Avoid dragging a middle handle unless you intend to stretch the image.
- Save the workbook and verify it. Press Ctrl+S on Windows, then click away from the picture to make sure the flipped result looks as expected in the worksheet. If you are sharing the file, reopen it or check it in the destination app to confirm that the image and its position display correctly.
On a Mac, select the picture and look for Picture Format > Arrange > Rotate, then choose the horizontal or vertical flip command. Ribbon labels and group placement can differ slightly between Mac releases and window sizes. If the ribbon is simplified, expand it or use Excel’s command search to look for Rotate. Excel for the web has fewer picture-formatting controls than the desktop app. If its picture ribbon does not offer Flip Horizontal or Flip Vertical, open the workbook in the desktop version of Excel, flip the image there, and save it.
Common Mistakes
- Rotating instead of flipping. Rotate commands such as Rotate Right 90° turn the picture around its center. They do not create a mirror image. For a mirror effect, choose Flip Horizontal or Flip Vertical from the Rotate menu.
- Clicking the cell instead of the picture. Clicking a cell behind an image selects the cell, so Picture Format does not appear. Click the image border, or use the Selection Pane to select the picture object.
- Picking the wrong flip direction. Horizontal reverses left and right; vertical reverses top and bottom. If the subject appears upside down when you wanted a mirror image, undo and choose Flip Horizontal instead.
- Forgetting that text will be reversed. A flip affects the complete picture, including any words baked into the image. Text typed in worksheet cells is separate and will not flip with the picture. If readable text matters, edit the original image or use a separate text box in Excel rather than mirroring the whole composite.
- Expecting an image in a cell to behave like a floating picture. Newer Microsoft 365 versions can place pictures in cells. These may not expose the same selection handles and picture commands as pictures placed over cells. If you cannot select the image as an object, check whether it is an in-cell picture and use the available picture options or move it to a floating position before editing.
- Dragging a sizing handle by accident. Clicking and dragging can resize or distort the picture instead of selecting a command. Use the Rotate menu for the flip, and use corner handles only when you deliberately want to resize.
Tips
- Choose the flip based on what you need to correct. Use horizontal flipping when a photo appears reversed like a selfie or when you need a subject facing the other direction. Use vertical flipping only when the top and bottom need to exchange places.
- Keep the original available. Before changing a picture that is hard to replace, duplicate it or save a separate copy of the workbook. You can duplicate a selected picture with Ctrl+C followed by Ctrl+V on Windows, then flip the copy and keep the original nearby for comparison.
- Use the Selection Pane for crowded sheets. Choose Home > Find & Select > Selection Pane. Select the picture’s entry in the pane to work with the right object, especially if several graphics overlap. You can also use the pane to hide an object temporarily while selecting another one.
- Use Undo promptly if the result is wrong. Ctrl+Z on Windows reverses the most recent action. On Mac, use Command+Z. Undo is useful immediately after an accidental flip, rotation, or resize; if you have performed many later actions, use the menu carefully because undoing can also reverse those actions.
- Remember that a flip changes the image, not worksheet data. It does not reverse cell values, formulas, or the order of columns. If your goal is to rearrange table data, use worksheet commands for that task instead of flipping a picture.
- Consider the printed or exported result. If the worksheet will be printed or saved as a PDF, check Print Preview after flipping. Pictures can look correctly oriented on screen but be clipped by print-area, scaling, or page-layout settings.
Troubleshooting
Picture Format does not appear
First, click directly on the image. If a cell is selected, the picture is not selected as an object. For an image behind another graphic, open Home > Find & Select > Selection Pane and select the relevant entry. If the image is inside a cell rather than floating over the worksheet, its editing controls may be different; use the cell-picture options available in your Excel version or place a copy over the cells to access the regular picture controls.
There is no Flip command in the menu
Confirm that you selected a picture rather than a shape, chart, or cell. The ribbon tab and commands vary depending on the selected object. If you are using Excel for the web, its editing options may be limited; open the workbook in Excel for Microsoft 365 on Windows or Mac and look under Picture Format > Arrange > Rotate. If you are on a small screen, maximize the window or expand the Arrange group so the full menu is visible.
The image rotated, but it did not mirror
Undo the rotation, reopen Picture Format > Arrange > Rotate, and select the specific Flip Horizontal or Flip Vertical option. A quarter-turn command changes the direction the picture faces, while a flip reverses it across an axis. Use the preview of the result and distinctive features in the image to confirm which operation you need.
The picture looks distorted or moved
A flip itself should not require you to stretch the image. If its proportions look wrong, undo any accidental resize and try again using the menu. If it moved, drag it back by its edge or use the picture’s position controls if you need a precise location. Check that the picture is not being constrained by worksheet layout or obscured by another object.
The command is unavailable or the workbook is protected
Some workbook or worksheet protection settings restrict changes to objects. If you are authorized to edit the file, check Review > Unprotect Sheet or ask the workbook owner for permission; a password may be required. Also check whether the file is read-only or opened with editing disabled. Do not remove protection from a workbook unless you have permission to do so.
Frequently Asked Questions
Can I flip an image in Excel without changing the cells?
Yes. The flip command applies to the selected picture object, not the cell contents. It will not change values or formulas. A floating picture may cover cells visually, but flipping it does not rearrange the worksheet grid.
What is the difference between Flip Horizontal and Flip Vertical?
Flip Horizontal reverses left and right, producing a mirror image. Flip Vertical reverses top and bottom. Neither command is the same as rotating an image 90 degrees.
Can I flip more than one picture at once?
You can select multiple picture objects and apply a flip if Excel allows them to be selected together. Use Ctrl-click on Windows or Command-click on Mac to select separate objects, then use the Rotate menu. If the command is unavailable for the combined selection, flip each picture individually.
Can I flip a picture in Excel for the web?
It depends on the picture controls available in your web version. Select the picture and check its ribbon options for a Rotate menu with flip commands. If those commands are missing, open the workbook in desktop Excel, make the change, and save it.
How do I undo a flip?
Immediately after flipping, press Ctrl+Z on Windows or Command+Z on Mac. You can also use the Undo button in the toolbar. If you have made other changes since then, undo carefully because Excel reverses actions in order.
Will the flipped image stay that way when I save or print?
Yes, the orientation is saved with the workbook. Still, check the worksheet and Print Preview before sharing or printing, particularly if the picture is close to a page edge or overlaps other content.
Related
- IFERROR Formula in Google Sheets: Syntax and Examples
- Make One Page Landscape in Word (Keep Others Portrait)
- IF Rules in Google Sheets: How Formulas and Rules Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Print Selected Area on One Page: Steps & TipsTo print a selected area on one page in Excel for Microsoft 365 on Windows, select the cells,…
- How to Make a Weekly Budget in Google Sheets EasilyTo make a weekly budget in Google Sheets, create columns for planned and actual income and expenses, then…
- Google Sheets for Expense Tracking: Setup and TipsYes—Google Sheets works well for expense tracking if you want a flexible, low-cost log you can update from…
- Excel Auto Merge Cells With the Same Value? Here’s HowNo—Excel for Microsoft 365 does not automatically merge cells just because they contain the same value. You can…
- How to Create a Word Template with Fillable FieldsTo create a fillable Word template, add content controls from the Developer tab, set their properties, then save…
- Schedule Recurring Emails in Outlook: Your OptionsOutlook can schedule a single email, but it does not have a built-in option to send the same…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.