How to Copy a Protected Excel Sheet

If a protected sheet still lets you select cells, you can copy its data straight into a new sheet with Ctrl + C and Ctrl + V, or duplicate the entire tab by right-clicking it and choosing Move or Copy → Create a copy. If protection blocks selection or copying altogether, the only legitimate route is to ask the file’s owner for an unprotected copy or unprotect the sheet using the password you already have.

This guide covers the honest ways to copy a protected worksheet you are entitled to use. It does not cover cracking, guessing, or bypassing a password you were never given — that can break copyright, intellectual-property, or computer-misuse rules, and we don’t recommend it.

First, Check What the Protection Actually Blocks

“Protected” can mean very different things in Excel, and that determines which method works:

• Sheet protection that still allows selecting cells. Many sheets are protected only to stop edits, not to stop you reading or selecting. If you can highlight a range, you can copy it.
• Sheet protection that blocks selection. If clicking and dragging does nothing, the owner unchecked “Select locked cells” when they applied protection. You cannot copy what you cannot select, so you’ll need an unprotected copy of the file.
• Workbook structure protection. This locks the sheet tabs so you can’t add, delete, move, or copy entire sheets. The Move or Copy command will be greyed out until structure protection is removed.
• A password to open the file. If Excel asks for a password before the workbook even opens, none of the in-Excel methods apply — you need that password from the owner.

If you’re unsure, look at Review → Protect Sheet / Protect Workbook on the ribbon. If the button reads “Unprotect,” protection is currently on. Knowing which type you’re dealing with saves a lot of trial and error.

Method 1: Select and Copy the Data (When Selection Is Allowed)

This is the fastest route when the sheet is protected against editing but not against selecting.

1. Open the protected sheet and click any cell to confirm you can select it.
2. Select the range you want — or press Ctrl + A to grab the whole used range.
3. Press Ctrl + C to copy.
4. Open or create the destination sheet, click the top-left cell, and press Ctrl + V.

To keep numbers, formats, and column widths intact, paste with Paste Special (Ctrl + Alt + V) and choose what you need, or use Home → Paste → Keep Source Column Widths. The pasted copy lands in a sheet you control, so you can edit it freely while the original stays protected.

Method 2: Duplicate the Whole Sheet with Move or Copy

If you want an exact duplicate of the entire tab — formulas, formatting, layout, and all — use Excel’s built-in Move or Copy command. This works as long as the workbook’s structure isn’t protected.

1. Right-click the protected sheet’s tab at the bottom of the window.
2. Choose Move or Copy from the menu.
3. In the dialog, pick where the copy should go under To book (the same workbook, or a different open one).
4. Check the Create a copy box at the bottom. This is the step people miss — without it, Excel moves the sheet instead of duplicating it.
5. Click OK.

Excel creates a new tab named, for example, Sheet1 (2). Right-click that tab and choose Rename to give it a clearer name. The copy inherits the original’s protection settings, so if you need to edit it you can apply Unprotect Sheet to the copy if you know the password. For more on this command in general, see our guide to copying a worksheet in Excel.

If Move or Copy is greyed out, the workbook structure is protected. Ask the owner to remove structure protection (Review → Protect Workbook) or to send you a copy without it.

Method 3: Save As a Copy of the Whole Workbook

Sometimes the cleanest approach is to copy the entire file rather than one sheet. This gives you an independent workbook you own outright.

1. With the file open, go to File → Save As.
2. Choose a location and give the copy a new name.
3. Click Save.

The new file is a complete duplicate, including every sheet and its protection. Because you now own this copy, you can apply your password (if you have it) to unlock and edit it without touching the original. This is also the safest way to experiment — your changes can’t affect the source file. Our walkthrough on how to make a copy of an Excel workbook covers the options in detail.

Method 4: Copy the Used Range into a Brand-New Workbook

If you only need the data and want a clean file with no inherited protection, combine selecting with a fresh workbook.

1. In the protected sheet, press Ctrl + A (or select the range you need) and Ctrl + C.
2. Press Ctrl + N to open a new, blank workbook.
3. Click cell A1 and paste with Ctrl + V, or use Paste Special → Values if you want results instead of formulas.
4. Save the new workbook.

This works only when the original allows selection. Pasting Values is handy when formulas reference other protected sheets that won’t come along — you keep the numbers without the broken links. You can then make a copy of the Excel sheet within that new file as many times as you like.

When Protection Blocks Copying Entirely

If the sheet won’t let you select cells, Move or Copy is greyed out, or the file demands a password just to open, there is no legitimate in-Excel workaround. Honest options are:

• Ask the owner for an unprotected copy or the password. This is the correct route in a workplace — the person who locked the file can share it or send an open version in seconds.
• Unprotect it yourself if you know the password. If you set the protection or were given the password, use Unprotect Sheet in Excel to remove it, then copy normally. The same applies to a password-protected Excel file you have the credentials for.

We don’t cover guessing passwords, brute-force tools, or third-party “unlockers.” Beyond the legal risk, those tools often carry malware. If you don’t have authorisation, the answer is to request access — not to circumvent it.

Understanding Why a Sheet Was Protected

Knowing the owner’s intent helps you ask for the right thing. Excel protection is usually applied for one of these reasons:

• To stop accidental edits to formulas or formatting while still letting people read and use the sheet. In this case the owner will often happily unprotect it for you.
• To allow input only in certain cells. A common setup locks the formula cells and leaves data-entry cells open — see protect a formula in Excel while allowing input. You can copy the visible data even when formulas are locked.
• To keep the structure fixed so sheets can’t be reordered or deleted. This is what blocks Move or Copy.

If you’re the one who needs to share a sheet that others shouldn’t break, our guides on how to protect an Excel sheet walk through applying protection the right way.

Frequently Asked Questions

Can I copy a protected Excel sheet without the password?

If the sheet allows cell selection, yes — select the data and copy it, or right-click the tab and use Move or Copy. Neither removes the password from the original. If protection blocks selection or the workbook structure is locked, you cannot copy it without help, and the right step is to ask the owner for an unprotected copy.

How do I copy data from a protected worksheet?

Click a cell to confirm selection works, then select your range (or Ctrl + A for everything), press Ctrl + C, and paste into a new sheet or workbook with Ctrl + V. If clicking and dragging selects nothing, the owner disabled selection of locked cells and you’ll need an unprotected version of the file.

Why is the Move or Copy option greyed out?

The workbook’s structure is protected, which locks the sheet tabs against adding, deleting, moving, or copying. Go to Review → Protect Workbook to see if it’s on. You’ll need the password to remove structure protection, or ask the file’s owner to send you a copy without it.

How do I know if an Excel sheet is protected?

Open the Review tab on the ribbon. If the button reads Unprotect Sheet or Unprotect Workbook, protection is currently active. You may also see a message like “The cell or chart you’re trying to change is on a protected sheet” when you attempt an edit.

Will copying a protected sheet also copy its protection?

Yes. Both Move or Copy and Save As carry the original protection settings to the duplicate. If you have the password, you can then unprotect the copy and edit it freely while leaving the source file untouched. If you don’t have the password, the copy stays locked in the same way the original is.

What’s the difference between a protected sheet and a hidden sheet?

A protected sheet has security features that prevent unauthorised changes, but it’s still visible. A hidden sheet simply isn’t shown until someone unhides it; its contents aren’t necessarily protected from editing once revealed. A sheet can be both hidden and protected at the same time.