![excel shift cells down one excel shift cells down one](https://www.exceldemy.com/wp-content/uploads/2021/12/Shift_cells_right_03-1.png)
This is performed when you want to select one or more cells and merge them into a larger cell. Whereas you could undo a deletion if you used the menus or keyboard, if you use a macro, you cannot undo it or any edits you did before the deletion. Shift cells down to shift selected cells and all cells in the column below it downward. The only drawback to remember about using a macro is that when you invoke any macro, Excel clears the Undo stack. With one small change, the macro can shift the remaining cells up: The following macro will delete the selected cells and shift the remaining cells to the left:
![excel shift cells down one excel shift cells down one](https://www.automateexcel.com/excel/wp-content/uploads/2021/09/insert-shift-cells-down-7.png)
If you are a "mouse person," you may want to create a couple of macros that achieve the desired effect, and then assign those macros to shortcut keys that can pull them up quickly. If you memorize the keystrokes, you can enter them very quickly and achieve the desired results. Similarly, if you want to move cells up, just press Alt, E, D, U, Enter. If you want to always move cells left, you would use the keystrokes Alt, E, D, L, Enter. The first is to simply memorize the keystrokes required to always move remaining cells in the desired direction. There are two ways you can go about making this happen. You may not want to move the remaining cells according to Excel's assumptions you may want to always move the remaining cells in one particular direction. In all other situations (the number of rows is greater than or equal to the number of columns), then Excel offers to move the remaining cells up, by default. If the selected cells include fewer rows than columns, then Excel offers to move the remaining cells to the left. When you select a number of cells (not entire rows or columns) and then choose to delete those cells, there are two directions that remaining cells can move: to the left or up.