Inserting and Deleting Rows in Excel

T

ttonkel

I have a protected time sheet that I am revising for my job. I need to have
the worksheet protected but also need to be able to insert and delete rows.
When clicking on the protect worksheet button I check the boxes next to
insert rows and delete rows. Then I click protect.

After I protect it with or with out those options it won't let me add or
delete rows.

Why won't it let me do this? Does anyone have any ideas about how to fix it?
 
M

Michael Arch

Because the purpose of Protecting a Worksheet is to prevent accidentally
deleting of rows/colums or cells, you have to unlock the rows or columns that
the user will be allowed to delete. To do this, Select the rows and or
columns that you will allow the users to delete at will, and from the Main
Menu Select:
Format->Cells
Click on the Protection Tab and remove the check mark from the "Locked" box
 
S

Shane Devenshire

Hi,

You CAN insert and delete rows when Excel is protected!

I can't duplicate your problem. If you choose Tools, Protection, Protect
Sheet and check Insert Rows and Delete Rows and click OK, you should be able
to insert and delete the rows from the worksheet.

It suggests that something else is going on. To get the insert row or
delete row command to work, you must either select the row number(s) or
choose the command Insert, Row. You can not right click a cell and choose
the Insert command because Excel thinks you are telling it you want to insert
a cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top