Copying a formula in Google Sheets is super easy to do. Let's see three different methods to do this.
The first thing you need to do, is to open your spreadsheet document.
2
Once you open the spreadsheet you need to work on, select the cell where the formula you need to copy is.
3
Now, click on the blue dot at the right bottom of the cell.
4
Hold the click and drag down the mouse to as many cells as you need. You'll get your formula in all those cells. Now let's see the second method.
5
Click on the cell where your formula is.
6
Press cmd+c if you use Mac or ctrl+c if you have Windows of Linux.
7
Now, click on the cell where you want to paste your formula.
8
Press cmd+v if you use Mac or ctrl+v if you use Windows of Linux.
9
You can keep pasting it in as many cells as you need.
10
There's one more way! You should place you mouse on the cell that has the formula you want to copy.
11
Right-click that cell.
12
Select "copy" from the dropdown options.
13
Now, click on the cell where you want to paste the formula.
14
Right-click that cell.
15
And click on "Paste". That's all! Which method would you prefer?