You can shift Cells Down in Excel by right-clicking, clicking and dragging, via the Home tab, using Shift-Click-Drag, Right-click and drag, Inserting copied cells, etc.

How to Shift Everything Down in Excel. Microsoft Excel contains features that make it very easy for you to reposition your work to add additional information or just to center your work on a page ...

Here's a quick tip for creating a Microsoft Excel drop down list from another tab.