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.

Pull Data From Another Sheet in Excel by Manually Selecting Cells You can also reference data from another sheet without needing complex formulas in Excel. Here's how to do that.