Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
easy way to delete all rows with no text in them? | New Users to Excel | |||
delete rows | Excel Discussion (Misc queries) | |||
Delete Rows where cells does not meet criteria | Excel Worksheet Functions | |||
Want to delete rows | Excel Discussion (Misc queries) | |||
How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) |