Can't "Shift Cells Up" anymore? why?

C

Cathy

I have been using "Shift Cells Up" and/or "Shift Cells Left" in the Delete
cell dialog box - but now it is no longer available to select. "Delete Entire
Row" and "Delete Entire Column" is the only options... what needs changed so
I can use this again? I have used this function in Excel 2007 every month
since we upgraded so I dont understand why it all of a sudden isnt working
anymore..
 
J

Jaleel

Hi,

Check whether any column is autofiltered to a particular cell value.

Regards,

Jaleel
 

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
Can't insert cells 2
Shift cells up or down 3
Any way to use toolbar button to delete cells and move cells "up"? 2
Delete - Shift Cells UP problem 3
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Shift + Home highlights entire worksheet to top, not single row 2
I can't delete a cell without deleting a row 2

Top