How to Mirror Image in Excel (2 Easy Methods)

While working in Microsoft Excel, we often use images to make our reports more lucrative. But sometimes we need to rotate or flip the image according to the row and column arrangement. Then we mirror the image to set it up according to the dataset. In this article, I will share with you how to mirror image in excel. Stay tuned!


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Simple Methods to Mirror Image in Excel

In the following article, I have shared 2 simple and easy methods to mirror images in excel.

Suppose we have an image inserted in our excel workbook. Now with the help of excel’s built-in features, I will mirror images in excel.

Mirror Image in Excel


1. Use Format Picture Option to Mirror Image in Excel

Sometimes, you need to work with a lot of images inside a report. For proper orientation of pictures “Format Picture” is the best solution. Simply, you can use the format picture option to mirror images in excel. Follow the steps below-

Steps:

  • First, select the image and click the right button on the mouse to appear the options.

  • Second, choose “Format Picture” from the options.

Mirror Image in Excel

  • After that, from the right pane choose “3-D Rotation” and change the “Degree” of “X Rotation” to “180” degrees.

Mirror Image in Excel

  • Finally, you will get a mirror image for the selected picture. Simple isn’t it?


2. Utilize Picture Format Feature to Mirror Image

In Excel, picture formatting is a normal and easy task. You can use the “Picture Format” feature to mirror images in excel. In order to do so just follow the steps below-

Steps:

  • While the image is selected choose “Picture Format” from the home ribbon.

Mirror Image in Excel

  • Then, select “Rotate” from the “Arrange” feature.

  • Hence, from the drop-down list, click “Flip Horizontal”.

  • In conclusion, your chosen image is mirrored with some simple clicks. Enjoy!

Mirror Image in Excel


Things to Remember

  • If you want you can also reshape or rotate the picture in various directions using the “Picture Format” feature.

Conclusion

In this article, I have tried to cover all the methods to mirror image in excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo