Visible Cells Only - Greyed out "Delete Rows"

**Kashus** · 03-03-2015, 02:07 PM

Hello folks,

I have filtered down to set of rows in my sheet that I need to delete. I selected "Visible Cells Only" and when I right-click to delete them, the delete option is grayed out. If anyone knows what might cause this and how I can fix it, it would be appreciated. Thanks!

Solved: The data was in a table.

**rabbita** · 03-03-2015, 02:23 PM

Please attach that file you're working on.

Regards,
Alex

**Kashus** · 03-03-2015, 02:24 PM

hmmm, I figured this might be a common issue, but I can't find a solution.

**Kashus** · 03-03-2015, 02:25 PM

Just found out the issue. It is in a table.

**jjiao** · 04-04-2017, 11:22 PM

Hi,

I'm having the same problem too. Can i know which part of the data caused it?

Visible Cells Only - Greyed out "Delete Rows"

LinkBack

Thread Tools

Rate This Thread

Display

Visible Cells Only - Greyed out "Delete Rows"

Re: Visible Cells Only - Greyed out "Delete Rows"

Re: Visible Cells Only - Greyed out "Delete Rows"

Re: Visible Cells Only - Greyed out "Delete Rows"

Re: Visible Cells Only - Greyed out "Delete Rows"

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Delete entire rows if cells include "Paper".

[SOLVED] Delete Rows if a cell does not equal "Finished" or "Complete"

Only a few cells "normal", the rest "greyed out"

[SOLVED] How do I delete Sheets if "Delete" is greyed out?

Bookmarks

Bookmarks

Posting Permissions