Column of images

%3CLINGO-SUB%20id%3D%22lingo-sub-2358750%22%20slang%3D%22en-US%22%3EColumn%20of%20images%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2358750%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20of%20images%20that%20I%20have%20set%20to%20%22Snap%20to%20Grid%22%20and%20have%20to%20select%20and%20nudge%20to%20top%20left%20corner%20with%20my%20mouse.%20I%20have%20to%20individually%20click%20on%20and%20move%20toward%20top%20left%20and%20when%20I%20release%20they%20%22snap%20to%20grid%22.%20Is%20there%20a%20way%20to%20select%20all%20and%20have%20them%20do%20the%20same%20if%20inserted%20before%20selecting%20%22snap%20to%20grid%22.%20I've%20tried%20and%20they%20all%20move%20same%20distance%20instead%20of%20%22snapping%20to%20grid%22.%20The%20images%20are%20a%201%2F4%20size%20of%20the%20cell%20they%20reside%20in.%20Most%20Images%20were%20placed%20in%20cell%20before%20I%20discovered%20the%20%22snap%20to%20grid%22%20feature.%20New%20Images%20added%20after%20%22snap%20to%20grid%22%20move%20to%20top%20left%20corner%20as%20needed.%20PS%20I%20have%20added%20the%20word%20Image%20in%20cells%20for%20sorting%20purposes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2358750%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2358776%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20of%20images%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2358776%22%20slang%3D%22en-US%22%3EThe%20file%20currently%20has%2013k%20rows%20and%20I%20will%20be%20changing%20text%20%22images%22%20to%20white%20after%20sorting.%20This%20effort%20is%20an%20evolving%20and%20long%20term%20reference%20project%20so%20no%20deadline%20hanging%20over%20my%20head.%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a column of images that I have set to "Snap to Grid" and have to select and nudge to top left corner with my mouse. I have to individually click on and move toward top left and when I release they "snap to grid". Is there a way to select all and have them do the same if inserted before selecting "snap to grid". I've tried and they all move same distance instead of "snapping to grid". The images are a 1/4 size of the cell they reside in. Most Images were placed in cell before I discovered the "snap to grid" feature. New Images added after "snap to grid" move to top left corner as needed. PS I have added the word Image in cells for sorting purposes.

 

1 Reply
The file currently has 13k rows and I will be changing text "images" to white after sorting. This effort is an evolving and long term reference project so no deadline hanging over my head.