Skip to main content

🏞️ How to reformat images in Excel

Don't want to lose the visuals while you are in Excel? Check out the step-by-step in this article!

Updated this week

πŸ’‘In this article, we will look at:

  • How to reformat cells in Excel to fit your images nicely

  • How to sort by images in Excel


✨ How-Tos ✨

  1. Export your report in Style Arcade via Excel with images (only metrics in view or all metrics)

  2. Click Copy to the clipboard

  3. Paste the data in a blank Excel sheet

  4. Select all images, and move them to the side

  5. Adjust the cells' width & height

    • We recommend width = 18, height = 150

  6. Back to the images, click on the top image, then press Ctrl + A on your keyboard to select all images

  7. Double-click on the images, then navigate to the Picture Format to bulk adjust their width & height

  8. Once you've adjusted the images to the desired width & height, then move them to Column A to fit and align the images to the centre

  9. While still having all the images selected, right-click to access Size and Properties

  10. Under Properties, select Move and Size with cells

  11. Add sorting to the headers and you're done!


Got any questions? Feel free to reach out to our in-app chat for assistance! 😊

Did this answer your question?