Drag and drop Excel keyboard shortcut

Use shift + Control + arrow keys to select data. Control + X to cut. Go to destination cell and ctrl V. Don’t use drag and drop as such…fuks up the data more often than not imo
 
Right, but you lose any formula reference which is not anchored by copying + pasting. I drag cells all the time, it’s one of the main reasons I cannot completely switch to keyboard on Excel.
 
cutting and pasting should update formula references appropriately…..
 
Put “1” in cell A1
Put “2” in cell B1
Put “A1+B1” in cell C1
Now move cell C1 to cell C3 by copying+pasting…does the formula remain correct?
Another problem with this approach is that the formula in C1 remains there for you to delete…
 
Trying this…if cells are locked in ($) the formula travels to C3 ( it’s still =c1+c2) if you copy or cut. If you cut C2 formula is moved. Never thought of the drag drop option. I find there is a lot of room for error using drag drop
 
You must log in or register to reply here.
Back
Top