Share via

Deleting Excel cells no longer offers to shift cells left or up

Anonymous
2012-11-14T10:09:22+00:00

Hi,

Using Excel 2007 and trying to delete a cell or block of cells I am offered a choice of whether I want to delete the Entire Row or Entire Column. The choices for Shift cells left and Shift cells up are greyed out. This appears to be a recent change in the way Excel works. How do I get it to give me the Shift options as else I have to select the cells to the right and drag them over which is extra work and not the way it used to work?

I don't know whether this matters but the workbook says it's shared, however, I'm the only user. The workbook is not protected.

Cheers

Andrew

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-11-15T06:02:14+00:00

Hi Andrew,

Thank you for asking.

I would definitely be able to help you related to your issue.

Since the workbook is shared shift cells left and up will be greyed out.

You may follow the steps below and check if it works

Click on Review tab, select Share Work, under **Editing,**and uncheck ‘allow changes by more than one use at the same time’

I hope this helps. If you need any further information, you can always reply and I’ll be happy to help you.

Thank you.

Was this answer helpful?

20+ people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-08-07T06:42:04+00:00

    It could also be caused by a filter. If you have any columns filtered you can't delete and shift...

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments
  2. Anonymous
    2016-03-03T10:49:53+00:00

    Hi Raju

    Just restarting this really old thread.

    Is this behaviour by design?

    Thanks

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments