back to gallery
Click on the cell that contains the formula you want to copy. This cell will be highlighted.
Move your cursor to the bottom right corner of the selected cell until it turns into a small cross (the **Fill Handle**).
Click and hold the left mouse button, then drag the Fill Handle down or across to the cells where you want to copy the formula.
Once you have highlighted the desired cells, release the mouse button. The formula will be copied to the selected cells, adjusting automatically based on their relative positions.
Click on the newly filled cells to ensure the formulas are correct. You can verify that the cell references have adjusted appropriately.