Yes. In Excel for Microsoft 365 on Windows, protect the sheet and leave the relevant cells selectable; users can then copy them with Ctrl+C while the protection prevents edits to locked cells. Sheet protection is an editing control, not a reliable way to stop someone from copying or viewing information.
What sheet protection controls
Excel worksheet protection is designed to limit changes to a sheet. A protected sheet can still display its contents, and protection does not automatically disable copying. The options you choose determine which cells users can select and which actions they can perform, such as formatting cells or inserting rows.
By default, cells are marked as locked, but that setting has no effect until you protect the worksheet. When protection is on, Excel prevents edits to locked cells while permitting edits to unlocked cells. This makes it useful for a form, template, or report where people should enter information in designated places without changing headings or formulas.
Selection is the key to copying. In the Protect Sheet options, Select locked cells and Select unlocked cells control whether users can click or move to those types of cells. If users need to copy values from protected, locked cells, allow them to select locked cells. They can then copy selected cells using Ctrl+C or the context menu.
Choose the right selection settings
Decide which cells people should be able to select before protecting the worksheet. These choices offer different balances of convenience and protection:
- Allow Select locked cells: Users can select protected cells, including cells containing fixed labels, results, or formulas. They can generally copy the selected contents, but cannot edit the locked cells while protection is active.
- Allow Select unlocked cells: Users can select cells you have made editable. They can enter data in those cells and copy their contents.
- Allow both: Users can navigate around and copy from both locked and unlocked cells, while locked cells remain protected against editing.
- Allow neither: This can make navigation difficult and is usually not appropriate if users need to inspect or copy sheet contents.
The selection checkboxes are not separate “copy permission” switches. Excel does not provide a simple Protect Sheet option that says “allow copying” while preventing all other ways of obtaining visible information. If a person can see and select data, sheet protection should not be treated as a barrier to copying it.
Protect a sheet while keeping cells copyable
To let users copy protected cells but not change them, leave the cells locked and permit selection of locked cells. In Excel for Microsoft 365 on Windows:
- Open the worksheet and select Review > Protect Sheet.
- In the Protect Sheet dialog, leave Protect worksheet and contents of locked cells selected.
- Under the list of permitted actions, check Select locked cells. Check Select unlocked cells too if users need to work in input cells.
- Choose any other actions users should be allowed to perform, such as using an existing AutoFilter, if those actions are appropriate for the sheet.
- Enter a password if you want to restrict who can turn off protection, then confirm it. A password is optional; protection can be applied without one.
With protection active, select the cell or range and press Ctrl+C. Move to a permitted destination and press Ctrl+V, or use the paste options to choose a different paste format. Copying and pasting into a protected destination is a separate matter: the destination cells must allow the change, so paste into unlocked cells or an unprotected sheet.
On a Mac, the protection controls are available from the Review tab, typically through Protect Sheet; dialog wording and shortcuts can vary slightly by Excel version. The standard copy shortcut is Command+C on Mac, rather than Ctrl+C. In Excel for the web, look under Review for sheet-protection controls; if the web interface does not offer a setting you need, use the desktop app to configure the sheet.
Make only the intended cells editable
A common setup is to let people copy any visible information but edit only a few input cells. First identify the input cells, unlock them, and then protect the sheet. To unlock a range in Windows Excel, select it, open Home > Format > Format Cells, go to the Protection tab, clear Locked, and select OK. Then use Review > Protect Sheet.
For example, a weekly report might have department names in column A, calculated totals in column B, and a comment-entry area in column C. Keep the labels and totals locked, unlock the comment cells, and protect the sheet. Allow selection of locked and unlocked cells if staff need to copy the report figures as well as fill in comments. The totals remain protected from accidental edits, but they are still available to copy.
Before distributing the workbook, test the workflow as a user would: try selecting a locked cell, copying it, editing it, and entering data in an unlocked cell. If a particular action fails, revisit the protection options and verify that the intended cells are actually unlocked or selectable.
What sheet protection cannot prevent
Sheet protection is useful for preventing accidental edits and guiding users through a workbook. It is not encryption and should not be used to keep confidential data secret. A protected worksheet still shows its visible contents to someone who can open the workbook. If users can select and copy a value, they can often paste it into another workbook or application.
Turning off Select locked cells can make locked cells harder to select through ordinary worksheet interaction, but it does not turn protection into a dependable confidentiality feature. Nor does hiding a worksheet or hiding formulas make the underlying information secure. If the data must not be disclosed, do not include it in a workbook shared with people who should not see it. Use appropriate file access controls and, where confidentiality is required, a suitable file-level protection method.
There is also a practical distinction between protecting a sheet and protecting a workbook. Worksheet protection governs editing actions on one sheet. Workbook structure protection can restrict structural changes such as adding, deleting, moving, or renaming sheets. Neither option is a substitute for controlling who can access the file, and neither should be confused with encrypting a workbook so that opening it requires a password.
Why copying may seem to be blocked
If Ctrl+C does not appear to work, first check what is selected and where you are trying to paste. The source cells may not be selectable because Select locked cells is off. Alternatively, the copy may have succeeded, but Excel may reject the paste because the destination is locked or because the action would alter protected cells.
Other common causes include copying a range that contains merged cells, selecting an entire row or column when the destination layout differs, or trying to use a feature that protection restricts. For example, permissions for filtering and sorting are separate from cell selection. If users need to filter a protected list, enable the relevant permitted action when protecting the sheet and set up the filter beforehand. Some operations, including sorting, can still be limited by the arrangement and locked status of cells in the range.
- If users cannot click a locked source cell, check Select locked cells.
- If users can copy but cannot paste, check whether the destination cells are unlocked or on an unprotected sheet.
- If users can select a cell but cannot change it, that is expected when the cell is locked and sheet protection is on.
- If a feature such as sorting is unavailable, review its separate permission rather than changing copy settings.
When to use another approach
Use Protect Sheet when the goal is to reduce accidental changes, preserve formulas, or make a workbook easier to fill in. It is a good fit for shared templates and operational reports where users need visible information but should not alter the worksheet design. A password can deter casual changes to protection settings, but it does not make displayed data private.
If the main goal is to share information without giving people an editable workbook, consider distributing a PDF or a separate values-only copy. A PDF is convenient for reading and printing, though recipients may still copy visible text or use other methods to extract information. A values-only workbook avoids sharing formulas, but it still exposes the values it contains. For sensitive data, share only the information each recipient is authorized to see, and use file permissions appropriate to the organization.
Frequently Asked Questions
Can someone copy cells from a protected Excel sheet?
Usually, yes. If the cells are selectable, users can copy them with Ctrl+C on Windows or Command+C on Mac. Sheet protection mainly restricts editing; it does not provide a general block on copying visible cell contents.
Which option lets users copy locked cells?
When protecting the worksheet, allow Select locked cells. This lets users select locked cells, which remain protected from editing. Copying is not a separate checkbox in the Protect Sheet dialog.
Can I allow copying but prevent editing?
Yes, for ordinary worksheet use: keep the source cells locked, protect the sheet, and allow users to select them. They can copy the visible contents while Excel blocks direct edits to those locked cells. This is not a way to prevent them from keeping a copy.
Can users paste copied cells into a protected sheet?
They can paste only where the destination and the permitted actions allow the change. Unlock the intended input cells before protecting the sheet, or have users paste into an unprotected destination. A protected source does not automatically make every destination editable.
Does a password make sheet protection secure?
A sheet-protection password helps prevent casual changes to the protection settings, but worksheet protection is not file encryption. Do not use it to hide sensitive information from someone who can open and view the workbook.
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 Cell Return: Add a Line Break Within a CellTo put a return, or line break, inside one Excel cell, edit the cell and press Alt+Enter on…
- Day Count in Excel: Calculate Days Between DatesTo get the number of elapsed calendar days between two dates in Excel, subtract the earlier date from…
- Creating a Four-Quadrant Scatter Plot in Excel: StepsTo create a four-quadrant scatter plot in Excel, put each item’s X value and Y value in two…
- Excel Inventory List: How to Build and Manage StockTo create an Excel inventory list, make columns for each item’s SKU, description, location, quantity, reorder point, and…
- Excel Set Print Area to Fit on One Page: Steps and TipsTo set an Excel print area and fit it on one page, select the cells you want, choose…
- Excel Data Validation: Lists, Rules, and Common FixesIn Microsoft Excel for Microsoft 365 on Windows, data validation controls what users can enter in selected cells.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.