How to Lock Shapes in Excel

Hey! Welcome to HOWZA channel! In today's lesson, we will teach you how to lock shapes in Microsoft Excel.
Working with large and complex Excel workbooks, especially when entering large amounts of data, no one is protected from accidental changes in formulas, formats, and other spreadsheet elements. But you can protect yourself from too much work on finding and eliminating such errors by protecting the individual spreadsheet elements.
Open Microsoft Excel or the Excel Document that you need.
Go to Insert tab at the top tools bar. Click on Shapes and choose the shape that you need. Draw a shape in the file.
Select the shape. Go to Review tab at the top tools bar. Click on Protect Sheet. A new window will open. Check Select locked cells and Select unlocked cells options. Click Ok. The shape is locked.

[bonavconsolidate]

I love the straight forwardness and simplicity. Thanks

[Darioq]

The only problem is that when you lock shapes, the macros attached, will not work.

[chevydavidson]

my whole sheet is locked now, not just the highlighted cells???

[EDRISSALEXIS]

Excellent. And the video could've even been 30 seconds shorter! Thank you.

[seyahchin]

Not so much drama your step❤ some is making ✌️✌️💖💖

[JNineBar]

The commentry and description is misleading, but the video shows the correct procedure. You need to untick "edit objects" to lock the shape.