Copy & Paste for Password Protected Sheet Is Not Working

LaurindaS

New Member
Joined
Jan 15, 2019
Messages
15
I am working with a password protected sheet that has hidden columns. I used to be able to select all (Ctrl + A) and then copy a whole sheet, then go to a blank sheet & paste and then be able to see all the columns, including the hidden ones. Recently I found that I'm not able to do that anymore.

Does anyone know a way around this?

Thanks,
Laurinda

 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,788
Office Version
  1. 365
Platform
  1. Windows
Try PasteSpecial Values
 

Watch MrExcel Video

Forum statistics

Threads
1,109,536
Messages
5,529,422
Members
409,875
Latest member
Khushal Bisht
Top