This article shows how to copy formulas in Google Sheets, but click here if you want to learn how to copy formulas in Excel. Click on a cell with a formula in it, press Ctrl + C on the keyboard to copy it, then select another cell, and press Ctrl + V on the keyboard to paste the formulaĬlick here to get your Google Sheets cheat sheet Alternative method: You can also copy and paste cells that have formulas in them to copy formulas.Release your click when you have reached the last cell that you want the formula copied into.Drag the fill handle down to the bottom of the column/range that you want your formulas to copy into.Select the cell with the formula in it, then click on the fill handle, and hold the click (The fill handle looks like a cross / plus sign, and it appears when hovering your cursor over the tiny blue square at the bottom right corner of a cell selection).Enter a formula into the cell that is at the top of the column/range that you want to copy formulas to.To copy a formula down an entire column in Google Sheets, follow the steps below:

Google if then formula