Shift a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2235667%22%20slang%3D%22en-US%22%3EShift%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2235667%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20office%202019%20and%20windows%2010.%26nbsp%3B%20I%20just%20upgraded%20to%202019%20from%202016.%26nbsp%3B%20Before%20I%20was%20able%20to%20right%20click%20in%20a%20cell%20and%20shift%20cell%20left%2C%20right%20%2C%20up%20or%20down.%26nbsp%3B%20Did%20that%20feature%20get%20removed%3F%26nbsp%3B%20Now%20it%20just%20gives%20me%20the%20option%20to%20insert%20a%20row%20or%20column.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2235667%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am using office 2019 and windows 10.  I just upgraded to 2019 from 2016.  Before I was able to right click in a cell and shift cell left, right , up or down.  Did that feature get removed?  Now it just gives me the option to insert a row or column.  

1 Reply

@sbohlar 

Excel 2019 isn't different from Excel 2016 in this respect.

If you right-click a cell in a table, you can only insert a table row or table column, since you cannot shift single cells in a table - that would disrupt the table structure.

But if you right-click a cell outside a table and select Insert... from the context menu, you should get a dialog with several options.