Copy Formulas Up Without Dragging Up
- Select the cell that contains the formula you want to copy.
- Press Ctrl + C on your keyboard to copy the formula.
- Select the range of cells where you want to paste the formula.
- Right-click on the selected range of cells and choose "Paste Special" from the context menu.
- In the "Paste Special" dialog box, select "Formulas" and click "OK".
This will copy the formula to the selected range of cells without dragging it up. You can use this method each time you add new info at the top of your spreadsheet.