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 Fill a Formula Across Excel. Excel formulas are a powerful way to quickly manipulate and display the data in your spreadsheets to your exact specifications. Once you've created an effective ...

Here’s how it works: When you start with a reference to cell A1 and drag your formula down, Excel updates the reference to A2, A3, and so on.