How to Copy and Paste Formulas in Microsoft Excel

We’ll show you a variety of ways

Along with the powerful formula features available in Microsoft Excel is the ability to reuse formulas without having to retype them. Ready to save some time with your spreadsheets? Here’s how to copy formulas in Excel using a variety of methods.

Absolute Versus Relative References When Copying Formulas

Before you begin, it’s important to note thecell reference style you use when you copy and paste a formulain Excel.

If you use absolute cell references in the copied formula, these remain unchanged when you paste the formula. This means that you’ll need to adjust the pasted formula to accommodate the new cell references. Absolute references contain a dollar sign ($) before the column, row, or both in the cell reference. For example,$A$1uses an absolute column and row.

If you use relative cell references in the copied formula, these automatically adjust to accommodate the new cell references when you paste the formula. Relative references do not contain a symbol before the column, row, or both. For example,A1uses a relative column and row.

Let’s look at an example.

Here, we have a formula in cell C1 to add the values in cells A1 and B1. We want to copy this formula to cell C2 and add the values in cells A2 and B2.

If you use absolute references as shown in the formula, those references do not automatically change to reference the new values. You must manually adjust the references in the formula to obtain the correct result.

Using the same example with relative references instead, the references automatically update to use the correct cell values.

Note: Keep in mind that although Excel is smart enough to change relative cell references for you, this may not work as expected if you’re copying the formula to non-adjacent cells or across different worksheets.

Also, remember that no matter which cell reference style you use, you should confirm the copied formula provides the results you expect after you paste it in the destination cell. If something isn’t right, take a look at ways tofix a formula problem in Excel.

Copy Formulas With Keyboard Shortcuts

If you’re a fan of using Excel keyboard shortcuts to perform actions quickly, then this is an ideal method when you want to copy and paste formulas as well as formatting.

Tip: You can paste the same formula to multiple cells by selecting them all before you use the paste keyboard shortcut.

Copy Formulas With the Ribbon and Paste Special

Keyboard shortcuts aren’t the only methods for copying and pasting formulas in Excel. You can use the built-in tools on the ribbon which include a Paste Special option if you want to include formatting in the operation.

For a copy and paste method that falls between keyboard shortcuts and ribbon buttons, you can use the shortcut, or right-click, menu.

Copy Formulas With Autofill

One convenient way to copy formulas to adjacent cells in Excel isusing the Autofill feature. You may have used this tool to create a series of dates or numbers in your sheet, but it works just the same for copying formulas in neighboring cells.

Copy, Paste, Complete

The nice thing about having different ways to copy and paste Excel formulas is that you can use what you’re most comfortable with at the time. Plus, you can combine some of the methods. For instance, you can copy with a keyboard shortcut and paste with a right-click. Let us know which method you find easiest.

Now that you know how to copy formulas in Excel, check out our tutorial forcopying a worksheet or workbooktoo.

Sandy Writtenhouse is a freelance technology writer and former Project, Department, and Program Manager. She turned her education, job experience, and love of technology into a full-time writing career. With all sorts of gadgets in her home and her hands, she seeks to help others make life easier through technology.Read Sandy’s Full Bio

Welcome to Help Desk Geek- a blog full of tech tips from trusted tech experts. We have thousands of articles and guides to help you troubleshoot any issue. Our articles have been read over 150 million times since we launched in 2008.

HomeAbout UsEditorial StandardsContact UsTerms of Use

How to Copy and Paste Formulas in Microsoft Excel#

Absolute Versus Relative References When Copying Formulas#

Copy Formulas With Keyboard Shortcuts#

Copy Formulas With the Ribbon and Paste Special#

Copy Formulas With the Shortcut (Right-Click) Menu#

Copy Formulas With Autofill#

Copy, Paste, Complete#