Aligning hundreds of photos

Hi I want to add about 150 photos into an excel spreadsheet. If I go to insert I can insert all the photos I’m on go however it then stacks them one above the other. I’ve tried to then go Format->Align->Distribute vertically however this doesn’t do much and they still all overlap each other.

Any ideas.

Cheers

Dave

Hi Dave
Format > align > distribute should work if you move one of the pictures a long way down in the spreadsheet, far enough that the other pictures don't overlap when they are distributed evenly between the top and bottom picture.
If that doesn't work try this macro

Please Login or Register  to view this content.