insert column prohibited by protection?

pit

New Member
Joined
Feb 27, 2005
Messages
8
I have a worksheet that i surmise has some sort of protection. I can't highlight a column to insert a new column. The cursor appears as a double-headed arrow when i hover over column. How can i check the different protections on this worksheet? Thanks.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
8,974
Click on the "Home" tab in the menu at the top. In the "Cells" group, click on "Format". Under "Protection", if it says "Unprotect Sheet" you know that the sheet has been protected.
 
  • Like
Reactions: pit

pit

New Member
Joined
Feb 27, 2005
Messages
8
Click on the "Home" tab in the menu at the top. In the "Cells" group, click on "Format". Under "Protection", if it says "Unprotect Sheet" you know that the sheet has been protected.
Thank you, mumps. It turned out i needed to view column and row "headers".
 

Watch MrExcel Video

Forum statistics

Threads
1,099,010
Messages
5,466,011
Members
406,460
Latest member
tryingtogoalone

This Week's Hot Topics

Top