Excel Shortcuts When Drawing Shapes: Circles, Squares, and Snap to Grid - Episode 2140

Microsoft Excel Tutorial for Drawing Shapes in Excel:
Inserting circles instead of ovals by using Shift while drawing.
Inserting squares instead of rectangles by using Shift while drawing.
Forcing shapes to snap to grid by using Alt.

Welcome to another episode of Learn Excel From MrExcel, where we bring you the best tips and tricks to master Microsoft Excel. In today's podcast, we will be discussing the handy shortcut of holding down the ALT key while drawing shapes to snap them to the grid. This simple trick can save you time and frustration when trying to align your shapes perfectly.

But that's not all, we also have a bonus shortcut for you. By holding down the SHIFT key while drawing a shape, you can constrain it to be a perfect circle or square. No more lopsided shapes or uneven edges. Just hold down that SHIFT key and watch your shapes transform into perfect geometric figures.

In this episode, we will be using the INSERT, ILLUSTRATIONS, SHAPES feature to demonstrate these shortcuts. Whether you're drawing circles, rectangles, or any other shape, these shortcuts will come in handy. And the best part? They work for any size or shape, so you can create custom shapes with ease.

So the next time you're working on a project in Excel and need to add some shapes, remember these shortcuts and save yourself some time and frustration. Thank you for tuning in to this episode of Learn Excel From MrExcel. Don't forget to subscribe to our channel for more helpful tips and tricks. We'll see you next time for another netcast from MrExcel. Happy Excel-ing!"

#excel
#microsoftexcel
#exceltips
#excelshortcut
#evergreen
#shortcutkey

This video answers these common search terms:
how do you draw in a circle in excel
how to draw a circle in excel
how to draw circle in excel
how to draw circles in excel
how to make a circle in excel
how to make circles in excel
excel snap to grid when drawing
how to draw equilateral triangle in excel
how to draw square shape in excel

Table of Contents:
(00:00) Excel shortcuts for drawing shapes
(00:10) First shortcut: hold down SHIFT while drawing a circle for a perfect shape
(00:20) Second shortcut: hold down SHIFT while drawing a rectangle for a perfect square
(00:45) Third shortcut: hold down ALT while drawing a rectangle to snap to grid
(01:14) Clicking Like really helps the algorithm

[tosomnic]

Love these quick tip videos!

Another one to add, if you hold CTRL while drawing the shape, it centers the shape on where you initially clicked (rather than making that a corner). Quite helpful if you want to draw your shape around something specific on your sheet.

You can also combine them (CTRL+ALT = centered square/circle, ALT+SHIFT = cell-bound square/circle, CTRL+ALT+SHIFT = centered cell-bound square/circle).

Very handy.

[JonathanExcels]

I didn't know the snap to grid trick. Thank you.

[joem]

I use Alt+N SH to get to the shapes and then the arrow key to select one.

[StoryTubekids]

How do you stop a line from auto-snapping to a shape?

[Cacatron]

I want to do something that seams very simple but I. Ant find a video for it anywhere. I just want to make a rectangle whit a square grind inside it . Wth?! Also the shapes selection dosent have a half circle… 😞, con I cut a cero le in half and create one?