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

's Computer Specifications

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

's Computer Specifications

Hi,

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

Regards,

Jaleel

"Cathy" wrote:

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error message "cannot shift nonblank cells off the worksheet"	CDelphi	Microsoft Excel Misc	2	15th Jun 2009 06:24 AM
Can u add cells in Excel without pressing "shift +" one by one?	~vanna~	Microsoft Excel Misc	1	16th May 2008 03:27 PM
ReVIEW (Erratum): some shortcut keys not working anymore-----help""""""""PhpApach...WORK WELL!!!!	wbrowse@gmail.com	Windows XP Help	0	13th Apr 2007 12:29 PM
How 2 use right shift "<<" and left shift ">>" operator in excel?	=?Utf-8?B?di0yYWpwYXU=?=	Microsoft Excel Programming	2	28th Dec 2005 01:33 PM
Insert 19 cells "Shift to the right" if cell contains "->"	robertjtucker	Microsoft Excel Programming	5	25th Jul 2005 04:20 PM