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.
 
Back
Top