How to Mirror Image in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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 images in Excel. Stay tuned!


How to Mirror Image in Excel: 2 Simple Methods

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 of 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.

Download Practice Workbook

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


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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram, BSc, Industrial and Production Engineering, Ahsanullah University of Science & Technology, has been working with the ExcelDemy project for 10 months. Currently working as as Excel and VBA content developer who provides authentic solutions to different Excel-related problems and writes amazing content articles regularly. He published almost 150 articles and has many more coming. He is very passionate about learning new things about Microsoft office Suite and Data analysis.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo