ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Delete rows (https://www.excelbanter.com/excel-discussion-misc-queries/127668-delete-rows.html)

The Scott

Delete rows
 
I have setup a data var sheet. I need to delete some rows in different areas
and the delete is grayed out. I have tried everything and I can not delete
the rows.

Scott


Mike

Delete rows
 
Some possibilities.

have you selected something to delete because delete will be greyed out
until you do.

If the sheet is protected then delete will remain greyed out even if
something is selected.

"The Scott" wrote:

I have setup a data var sheet. I need to delete some rows in different areas
and the delete is grayed out. I have tried everything and I can not delete
the rows.

Scott


Dave Peterson

Delete rows
 
Is your worksheet protected?
Check under Tools|Protection. Do you see Unprotect sheet?

If yes, then unprotect the worksheet--you may need to supply a password.

The Scott wrote:

I have setup a data var sheet. I need to delete some rows in different areas
and the delete is grayed out. I have tried everything and I can not delete
the rows.

Scott


--

Dave Peterson


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com