Select Shift cells down. The cell is shifted down. 2] Shift the Excel cell down by clicking and dragging Move the cursor on the edge of the cell that you want to move down until you see a double ...

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

However, Excel lets you disable this movement, so you keep the active cell until you manually change position.