Notta
Showcase

back to gallery

how to copy formula in excel

5 steps
1

Select the Cell with the Formula

Click on the cell that contains the formula you want to copy. This cell will be highlighted.

2

Use the Fill Handle

Move your cursor to the bottom right corner of the selected cell until it turns into a small cross (the **Fill Handle**).

3

Drag to Copy the Formula

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.

4

Release the Mouse Button

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.

5

Check the Copied Formulas

Click on the newly filled cells to ensure the formulas are correct. You can verify that the cell references have adjusted appropriately.

Documents you might like

lighting effect

Start creating your guide online

Automate guide creations and save your time into things that matter.

Notta
Showcase
Copyright © 2024 Notta. All Rights Reserved.