Select the cell with the formula, and hover the mouse cursor over a small square at the lower right-hand corner of the cell, which is called the Fill handle. As you do this, the cursor will change to a thick black cross. Hold and drag the fill handle down the column over the cells where you want to copy the formula.
Keyboard shortcut: You can also press Ctrl+D to fill the formula down a cell in a column, or Ctrl+R to fill the formula to the right in a row.
Press F2 (or double-click the cell) to enter the editing mode. Select the formula in the cell using the mouse, and press Ctrl + C to copy it. Select the destination cell, and press Ctl+V. This will paste the formula exactly, without changing the cell references, because the formula was copied as text.
If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a "$" before the column letter if you want that to always stay the same. Place a "$" before a row number if you want that to always stay the same.
You can also use keyboard shortcuts CTRL+C and CTRL+V to copy and paste formulas. When you paste the formula in destination cell you can select different paste options like paste formula & formatting or paste only formula or paste formula and number formatting.
Use the keyboard shortcut to apply the formula to the entire column, including any new rows you insert: Ctrl + d (Windows) or Cmd + d (Mac). The formula will be copied to the entire column and applied to new rows as soon as they are added.
If you want to maintain the original cell reference when you copy it, you "lock" it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.
Select the formula cell to display the formula in the Formula Bar. Click on the reference cell you want to always use in the formula, and then press the F4 key.
Simply use the formula =UNIQUE, then select the list you want to remove duplicates from as your range. Make sure your range ALSO includes a bunch of extra cells as the bottom, so the formula will pick up any new values you add in the future.
In order to keep Excel from changing the cell reference when you drag it you need to make the cell reference what is called absolute value. This is done by entering a $ sign in front of the Column or Row that you do not want to change. In your case E2/F2 would need to be E$2/F$2 to keep it from changing to row 3, etc.
When copying a formula that's using a relative cell reference, the formula is going to become relative to where it is being pasted. For example, if cell B2 had the formula "=A2" that was copied to cell B3, it would become "=A3" because it's relative to where it's being copied.
For the double click copy to work you need to be directly adjacent a column that has data or formula in that come to a stop. So watch out for blank columns and remember to look for hidden columns as Excel 'sees' these even if you don't.
Click and drag the fill handle over the cells you want to fill. In our example, we'll select cells D5:D13. Release the mouse. The formula will be copied to the selected cells with relative references, displaying the result in each cell.
If you want to copy an entire range of formulas in Google Sheets but don't want to change their references, the Find and Replace feature is your best ally here. To enter the feature, either press Ctrl + H, or navigate to the Edit entry in the upper menu and navigate to Find and replace.
Go to Home –> Find and Select –> Replace (Keyboard Shortcut – Control + H). In the Find and Replace dialogue box, use the following details: Find what: $A$1 (the cell reference you want to change). Replace with: $B$1 (the new cell reference).
To do this, enter the formula in the top cell of the column, select the cell and the adjacent cells where you want to copy the formula, and then click and drag the Fill Handle downwards over the range. Excel will copy the formula automatically, adjusting it for each cell's relative position.