Copy formulas for selected cells fast and easy

Excel 365 2016 2013 2010 2007
You can use "Copy" (Ctrl+C) and "Paste" (Ctrl+V) options, but there is faster way to "copy" a formula to multiple adjacent cells.

Follow these steps:

   1.   Select all the cells that will contain the formula (dragging so that the cell that you will write the formula in is the first of the selected group of cells).

   2.   Enter the formula into the first cell.

   3.   Press Ctrl+Enter and the formula is placed in all the selected cells.

See also this tip in French: Comment copier rapidement et facilement les formules des cellules sélectionnées.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

Pasting pictures of cells and charts

Pasting pictures of cells and charts

One of Excel's best-kept secrets is its ability to copy and paste pictures of cells. You can copy a cell or range and then paste a picture of the cell or range on any worksheet or chart.
Paste results into cell without formulas

Paste results into cell without formulas

You may not always want to copy everything from the source cells to the destination cells. For example, you may want to copy only the current values of formulas rather than the formulas themselves.
Hide formulas from appearing in the edit bar

Hide formulas from appearing in the edit bar

Usually you can view a formula in the Excel cell when cell is selected, but you can protect spreadsheet to hide formulas in some cells.