Excel Snap to Grid Not Working Properly

When I have 'snap to grid' enabled in excel, it sometimes still does not place shapes exactly on the grid lines.

Is there a way to fix this?
Because it is messy, and will cause problems when moving multiple shapes in one go around.

Here is an example:

enter image description here

2

1 Answer

The simplest(?) solution:

Hold ALT as you're about to (before you) release the mouse button while moving objects.

Note that the snapping at that point may be at ANY of the corners of the object, the difference may be very subtle; more so if the grid and object sizes are not exactly the same (i.e. differ only slightly).

3

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like