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.
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-
- First, select the image and click the right button on the mouse to appear the options.
- Second, choose “Format Picture” from the options.
- After that, from the right pane choose “3-D Rotation” and change the “Degree” of “X Rotation” to “180” degrees.
- 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-
- While the image is selected choose “Picture Format” from the home ribbon.
- 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!
Things to Remember
- If you want you can also reshape or rotate the picture in various directions using the “Picture Format” feature.
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.