How to copy data from a range where you cannot select, due to worksheet protection?
Here’s the situation: You receive a worksheet with data but not insight. Well, it happens and you get use to it already. You plan to copy the (raw) data and paste it to a new worksheet and do some analyses on your own. Unfortunately you are prohibited from performing such a simple action because the worksheet is protected in a way that you cannot select the cells with data you need. (Of course you do not know the password to unprotect the worksheet.)
What are you supposed to do then? Print a hard copy and then re-input the data one by one? If this is the approach you used, you’d better read this.
With Name Box (sitting on the top of cell grid; and on the left to formula bar), you may go to any range on s spreadsheet, even if it is protected from selecting.
Do the following:
IMPORTANT: Once you hit Enter, nothing happens apparently. Press Ctrl+C (before you hit or click on anything else).
Now you should see the “marching ants” surrounding A4:E8. It means that you have put that range into clipboard successfully for Pasting to somewhere else.
The next simple action is to go to a new worksheet or a blank worksheet and do the normal Paste (Ctrl+V).
There you go! Without the hassles of re-input manually. 🙂
Thoughts of protecting cells from selecting
Many people do that without a particular reason. “Just do it” is their motto in workplace, maybe. Nevertheless, there is one good reason I would protect locked cell from selecting. It is to make navigation easier for user’s input. With locked cells protected from selecting, while allowing “unlocked” cells to be selected, user could then focus on where they need to input. Although it is not perfect, it reduces chance of inputting data to irrelevant locations. 🙂
If human errors can be avoided totally, it is not human errors at all.