Delete cells in Excel 2007 give a pop up: delete entire sheet row?

  • Thread starter Thread starter frogman7
  • Start date Start date
F

frogman7

I just want to delete the cells and shift to the left but it doesn't
give me that option. Why?
 
I just want to delete the cells and shift to the left but it doesn't
give me that option.  Why?
Click to expand...

I found out some interesting info. The cells in question did not have
any filters on them but the sheet did have a few cells that had
filtering on them that is why I got the delete entire sheet row? pop
up. I took the filter off of the few cells on the sheet and tried
again and it worked.
 
You must log in or register to reply here.

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

Similar Threads

I can only delete an entire row not a cell in excel 2013? 1
Delete Cells on value 5
Moving a bunch of data 1
Delete only Filetered rows in excel 2007 not hidden rows or header 0
Excel Cannot delete empty cells/rows 4
Can't "Shift Cells Up" anymore? why? 1
Array macro question 4
Monthly Charts 4

Back
Top