how do I delete multiple cells - shift cells left?

asked 2019-11-06 21:28:07 +0100

gwstiles gravatar image

When I select multiple cells to delete, the options to "shift cells up" and "shift cells left" are grayed out.

Is there a way to access these options?

edit retag flag offensive close merge delete



Yes. Use them without multi-selecting non-contiguous areas.

Mike Kaganski gravatar imageMike Kaganski ( 2019-11-06 21:31:49 +0100 )edit

That is obvious but doesn't help. I need to be able to select non-consecutive cells and delete, and shift-left, on a regular basis. This works great in MS Excel but apparently it doesn't work in other applications.

gwstiles gravatar imagegwstiles ( 2019-11-15 22:07:22 +0100 )edit