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 ...

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.

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.