MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcut - Snap to Grid

August 28, 2017 - by Bill Jelen

Excel Shortcut - Snap to Grid

So you are drawing some shapes in Excel and you need them to line up with the Excel grid. Snap to Grid is the answer.

If you are drawing any shape, Alt will cause that shape to exactly line up with the borders of cells.

Thanks to Rickard Wärnelid for sending in this idea.

Watch Video

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast
  • episode 2140 hold down alt in order to
  • snap to grid while drawing shakes I'm
  • actually gonna give you two keyboard
  • shortcuts here so let's go to insert
  • illustrations shapes and choose the
  • circle all right so the circle here if
  • you just draw a circle you're going to
  • get some sort of an oval something like
  • that but if you hold down the shift key
  • while you're drawing that it will
  • constrain it to be a perfect circle like
  • that for the rectangle insert
  • illustrations shapes choose the
  • rectangle alright just draw and it's
  • going to be in any shape but if I hold
  • down the shift key it will force it to
  • be a perfect square so the first trick
  • is the shift key but if I needed to snap
  • to the grid to exactly fill a certain
  • range of cells we'll go to insert
  • illustrations shapes choose the
  • rectangle this time I'm going to hold
  • down the Alt key while I draw and it
  • will always be you know in this case 2
  • by 2 3 by 3 5 by 3 and will always
  • exactly exactly
  • fill a good all right couple of great
  • tricks there while you're using the
  • shapes to constrain the shapes to be a
  • perfect rectangle perfect circle perfect
  • what is it isosceles triangle no an
  • equilateral triangle or snap to grid
  • well thank you for stopping by we'll see
  • you next time for another net cast from
  • MrExcel

Title Photo: MichaelGaida / Pixabay

Bill Jelen is the author / co-author of
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.