Deleting rows in Excel 2016

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

adityaupadhye47

Thread Starter
Joined
Feb 25, 2018
Messages
15
First Name
Aditya
I am using Microsoft Office Suite 2016.
I have a worksheet that I have protected. The things that I have allowed for anyone who gets access to this sheet are:
1. Select locked cells
2. Select unlocked cells
3. Insert rows
4. Delete rows

Now, my problem is that when I select the option to insert rows, it is working.
But, when I am trying to delete rows, a dialog box appears, asking me to unprotect the worksheet. May I know if I am doing something wrong or have I missed something? Please tell me the solution to this.
 

Keebellah

Trusted Advisor
Joined
Mar 27, 2008
Messages
6,611
First Name
Hans
The moment you protect the sheet you have to indicate the exact things that are allowed.
If you select only one row, does the same thing happen?
Is the entire row unlocked?
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top