| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't "Shift Cells Up" anymore? why?
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.. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't "Shift Cells Up" anymore? why?
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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error message "cannot shift nonblank cells off the worksheet" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Can u add cells in Excel without pressing "shift +" one by one? | Excel Discussion (Misc queries) | |||
| I can't ask a question anymore-"Site Not Available" | Excel Discussion (Misc queries) | |||
| Pivot "row hide menu" keeps having items I don't have anymore!?!? | Excel Discussion (Misc queries) | |||
Hybrid Mode
