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

Can't shift cells up or down 0
Shift Cells Down 0
Delete cell shifts cells up - How to avaoid happening 0
How to shift cells up/down 0
Auto-ID and Delete/left shift cells when a cell contains text? 0
Can't insert cells 2
Table Preferred width is changed when pasting 1
Any way to use toolbar button to delete cells and move cells "up"? 2

Top