Yes. In Excel for Microsoft 365 on Windows, open Review > Protect Sheet and select Edit objects in the list of permissions before protecting the worksheet. Clear that option to prevent changes to locked objects such as shapes and charts; it is separate from the permissions for editing cells.
What the Edit objects permission controls
Excel worksheets can contain drawing objects as well as cells. Examples include charts, pictures, shapes, text boxes, SmartArt, and certain form controls. When you protect a sheet, the Edit objects permission determines whether users can make changes to objects that are protected by the sheet. The practical effect can include selecting, moving, resizing, formatting, or changing an object, depending on its type and settings.
This is a worksheet-level permission, not a switch for one particular chart or shape. If it is enabled, it grants broad object-editing permission on that sheet. If you need users to work with some objects but not others, you will need to configure the objects themselves carefully and test the result with sheet protection on. A locked object is normally protected when the sheet is protected; an object’s own protection settings can affect how it behaves.
The setting does not control whether a user can edit worksheet cells. A chart can remain protected while its source data cells are editable, for example. If a user changes those cells, the chart may update to reflect the new data even though the user cannot select or reformat the chart. Conversely, allowing object editing does not automatically unlock every cell.
How to protect a sheet and allow object editing
In Excel for Microsoft 365 on Windows, use these steps:
- Open the worksheet you want to protect and select the Review tab.
- Select Protect Sheet.
- In the protection dialog, optionally enter a password. You can also leave the password blank, but then anyone can remove protection without entering one.
- In the list under Allow all users of this worksheet to, select Edit objects. Leave or adjust the other permissions according to what users need to do.
- Select OK, confirm the password if Excel asks, and try the intended actions on the protected sheet.
The first checkbox in the dialog, Protect worksheet and contents of locked cells, must also be selected for worksheet protection to take effect. The permissions beneath it describe actions that remain allowed while the sheet is protected. If you are setting up a template, decide which cells users should fill in before protecting the sheet; cell locking and the object permission solve different problems.
To change the permission after protection is already on, select Review > Unprotect Sheet, provide the password if prompted, and protect the sheet again with the desired options. Excel does not provide a normal way to change the protection checklist while leaving that sheet protected.
What users can and cannot do with common objects
With object editing blocked, users generally cannot alter protected drawings on the sheet. For a chart, that may mean they cannot move or resize it, change its formatting, or edit chart elements. For a shape or text box, they may be unable to reposition it or change its text or appearance. The exact actions available can depend on object type and its individual settings, so check the actual workbook rather than assuming every object behaves identically.
With Edit objects allowed, users can make changes to objects that would otherwise be protected. That may be useful in a reporting sheet where people need to adjust a chart or add notes to a diagram. It is a poor fit if the object is part of a carefully controlled layout and should remain untouched.
Some objects are meant to be used, not redesigned. A button or other control may run an assigned action, and users may need to click it without being allowed to move or reformat it. Do not assume that the broad Edit objects permission is the best way to enable that interaction. The control’s own properties, its assigned action, and worksheet protection all matter. Configure and test the specific control in the version of Excel your users will use.
Object protection versus cell protection
Excel treats cells and drawing objects as separate parts of a worksheet. Cells have a Locked property, which is enabled by default for cells, but that property only has an effect after you protect the sheet. You can leave input cells unlocked, protect the worksheet, and allow users to edit those cells while keeping formulas locked. The Edit objects choice does not unlock cells or change their Locked properties.
For example, a monthly report might have unlocked cells for entering actual figures, locked formula cells for totals, and a protected chart showing the results. The sheet can allow users to select and edit the intended input cells while leaving Edit objects cleared. As figures change, Excel can recalculate formulas and refresh the chart from its data range; that does not mean the chart itself is editable.
There are other independent permissions in the protection dialog, including formatting cells, inserting rows, sorting, and using AutoFilter. Select only the actions needed for the workflow. Enabling a permission such as sorting does not automatically allow object editing, and allowing object editing does not grant permission to change locked cells.
Choosing the right setting for your worksheet
Start with the job users need to complete, rather than enabling every permission for convenience. If they only need to enter values into designated cells, leave object editing off. If they need to reposition a chart or revise a shape, allow object editing and consider whether they should also be able to change the underlying data or formulas.
- Data-entry form: Unlock the intended input cells, protect the sheet, and normally leave object editing off so labels and layout objects stay in place.
- Editable presentation sheet: Allow object editing if users are expected to adjust charts, pictures, or annotations. Keep sensitive formula cells locked.
- Dashboard with interactive controls: Test each control separately. A user’s ability to click or operate a control is not the same as permission to redesign it.
- Shared template: Keep a backup copy and test with a representative user account or a separate copy of the file before distributing it.
Protection is applied per worksheet. A workbook with several sheets can have different protection options on each one. Protecting one sheet does not automatically protect the others, and worksheet protection is distinct from protecting the workbook’s structure against adding, deleting, moving, or renaming sheets.
Common problems and how to troubleshoot them
If an object is still movable after you thought you protected the sheet, check that sheet protection is actually on and that Edit objects was cleared. Then unprotect and reprotect the sheet if necessary. Also inspect the object’s own protection properties: an object configured as unlocked may behave differently from one left locked. Do not use the appearance of a grayed-out ribbon command as the only test; try selecting and changing the object directly.
If users cannot edit a chart even though you selected Edit objects, confirm that you applied the setting to the correct worksheet and that you completed the protection dialog. Check whether the chart or related object has additional settings, and try a simple test shape on a copy of the sheet. A chart may also appear not to respond because its source cells are locked, even when the user can select the chart.
If someone can change values in cells but not move a shape, that is not contradictory: cell permissions and object permissions are independent. If someone can move a chart but cannot edit the numbers behind it, that can also be expected. Troubleshooting is easier when you test one task at a time: edit an input cell, change a locked cell, select the object, and try the specific change users need.
On Excel for Mac, worksheet protection is also available from the Review tab, though dialog layout and labels can vary by release. Excel for the web has a more limited set of protection controls than the Windows desktop application, and some object-specific editing tasks may require opening the workbook in desktop Excel. If a setting or object behaves differently in a browser, configure and verify the protection in the desktop app used to prepare the workbook.
Protection limits and safer alternatives
Worksheet protection is designed mainly to prevent accidental edits and guide normal use. It is not a strong security boundary for confidential information, and a worksheet password should not be treated as encryption. If the workbook contains information that people must not see, restrict access to the file or store only the information each person is authorized to access. For file-level password encryption in Windows desktop Excel, use File > Info > Protect Workbook > Encrypt with Password; keep in mind that this protects access to the workbook, not just editing of one object.
A password on sheet protection can stop casual unprotection, but forgetting it can make routine maintenance difficult. Keep a secure record of passwords and retain an unprotected source copy where appropriate. If you need users to edit an object while preventing changes to the rest of the sheet, first consider whether the object can be replaced by a more controlled input, such as a cell with data validation or a form designed for the task. The right choice depends on what users actually need to change.
Frequently Asked Questions
How do I stop users from moving a chart in Excel?
Protect the worksheet and leave Edit objects cleared. Check that the chart is not configured as an unlocked object, then test moving it while the sheet is protected.
Can I protect cells but still let users edit shapes?
Yes. Protect the worksheet, keep the relevant cells locked or unlocked as needed, and select Edit objects if users should be able to change protected drawing objects. Cell and object permissions are separate.
Does Edit objects let users change chart data?
Not by itself. It controls editing of the object. Whether users can change the chart’s source data depends on the cell permissions and where that data is stored. A chart may update when editable source cells change even if the chart object is protected.
Can I allow editing of only one shape?
The protection dialog’s Edit objects option applies broadly to the worksheet; it is not a per-object selector. Individual object settings may help shape behavior, but test the exact configuration with protection enabled before relying on it.
What if I forgot the worksheet protection password?
Excel does not provide a standard password-recovery option for worksheet protection. Look for an authorized unprotected copy or contact the workbook owner. Do not assume that a worksheet password is the same as the password used to encrypt a workbook file.
Related
- Excel Power Query Date Format: Types, Changes, and Fixes
- Train Inventory Spreadsheet: What to Track and How
- Tool Inventory Spreadsheet: Setup, Tracking, and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Analysis Extension: ToolPak Setup and UsesExcel’s “Data Analysis” extension usually means the Analysis ToolPak, a free add-in included with desktop Excel that adds…
- How to Clear the Outlook GAL CacheTo refresh the Global Address List (GAL) cache in classic Outlook for Microsoft 365 on Windows, select Send/Receive…
- Free Home Budget Spreadsheet: Set Up a Simple Excel PlanYes—you can make a free home budget spreadsheet in a blank Excel workbook, or adapt a free template…
- How to Freeze One Row in Excel: Keep Headers VisibleTo freeze one row in Excel, select View > Freeze Panes > Freeze Top Row. Excel keeps row…
- How to Insert a Signature Image in Word Without Blurry EdgesTo insert a signature image in Microsoft Word, place the cursor where the signature should appear, choose Insert…
- QuickBooks Excel and CSV Import Toolkit: What It DoesThe QuickBooks Excel and CSV Import Toolkit is an Intuit support resource for bringing certain list data from…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.