• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Paste Formulas in Excel

August 6, 2021 by Andrew Childress
Paste formulas in Excel

Formulas are the easiest and best way to perform calculations in Microsoft Excel. Let’s learn how to paste formulas in Microsoft Excel.

Formulas are the easiest and best way to perform calculations in Microsoft Excel. But they can often be lengthy and difficult to type in correctly. The last thing you want to do is type the same formula over and over, just to use it in your spreadsheet. Fortunately, Excel lets you easily copy and paste! Let’s learn how to paste formulas in Microsoft Excel.

How to Paste Formulas in Excel

Formulas in Excel are smart – drop them in a new location, and they’ll update to reflect and incorporate the data around them. This hints at the power of formulas. They offer tremendous repeatability. Type a formula in once, and you can often use it over and over in different locations in your spreadsheet.

Let’s consider a simple example. Cell D1 contains a formula that sums the three numbers to its left, in cells A1:C1. The formula is:

=SUM(A1:C1)

Paste formulas in Excel

Now, imagine that you have three additional cells containing numbers that you want to sum: cells E3, F3, and G3. Since these cells aren’t directly adjacent to the cell containing your formula, you can’t simply drag the formula downward. You’ll need to paste your formula into the new cell.

To get started, click into the cell containing your formula, D1. Press Command + C on your keyboard (Control + C on Windows) to copy the contents of the cell, including the formula.

How to paste formulas in Excel

Then, go to the cell where you want to replicate the formula. Here, that’s cell H3. Right-click, then hover over Paste Special. The option you want is Formulas. Click on it.

Pasting formulas in Excel

Excel will paste in your formula. It will automatically update to capture the new data. Keep in mind, you’ll need to have the same number of values being summed.

How to paste formulas with Excel

As you can see, pasting formulas in Excel saves you time and hard work.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Add symbols to Excel Add Symbols in Excel
Next Post: Define Name in Excel Define name in Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top