• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to make Excel automatically copy formulas and calculate totals

0 Comments

How to make Excel automatically copy formulas and calculate totals: Using functions/formulas to calculate data is almost a daily task for Excel users. However, when adding new rows/columns of data using the same approach, the default is that those formulas are not applied to the new rows/columns. At this point, you have to re-enter the formula and function to calculate for the new data position, which is very time-consuming. There is a more efficient way to customize Excel to automatically copy formulas and calculate totals when changing the data range. Please follow the article below for instructions.

Step 1

For example, we have a data table as shown below, first we need to set the format of the data table to Table. You select the entire data table and then select the Home tab on the toolbar. Then select Format as Table. The scroll bar will display the available Table templates in Excel. You select a template that you like.

How to make Excel automatically copy formulas and calculate totals

How to make Excel automatically copy formulas and calculate totals

Step 2

At this point, the Format As Table dialog box appears. You select the entire table and then click OK.

How to make Excel automatically copy formulas and calculate totals

How to make Excel automatically copy formulas and calculate totals

Step 3

Next, you select the Design tab on the toolbar. Here you can adjust the format of the table in the Table Styles section. In addition, there are sections for you to customize the table as follows:

  • Total row: Add a total row to the end of the worksheet, with a list of functions for each cell in the total row.
  • Banded row and Banded columns: Change the darkness/lightness of alternating rows/columns.
  • First column and last column: Change the format of the first and last column of the table.
  • Filter button: Hide or show the arrow on the header row.
How to make Excel automatically copy formulas and calculate totals

How to make Excel automatically copy formulas and calculate totals

Step 4

To automatically calculate totals, you just need to tick the Total Row box. That’s all the total cell will be automatically inserted at the end of the worksheet.

How to make Excel automatically copy formulas and calculate totals

How to make Excel automatically copy formulas and calculate totals

Step 5

Next, to add a row, you right-click on the position where you want to add the row on the data table.

The scroll bar appears, you select Insert => Table Rows Above.

How to make Excel automatically copy formulas and calculate totals

How to make Excel automatically copy formulas and calculate totals

That’s it, a new row has been added to the data table. Along with that, the cell in the Total column will also be automatically copied with the formula like the remaining cells of this column. Now you just need to enter data into the remaining cells in the newly added row.

How to make Excel automatically copy formulas and calculate totals

How to make Excel automatically copy formulas and calculate totals

In this way, the article has instructed you on the trick to automatically copy formulas, calculate totals in Excel data tables. Hopefully, the article will be helpful to you in your work. Wish you success!

Rate this post
29
239 Views
How to Refresh Data Connections and Pivot Tables using Excel VBAPrevHow to Refresh Data Connections and Pivot Tables using Excel VBAMarch 25, 2023
How to Automatically Update Edit Time in Excel FileMarch 26, 2023How to Automatically Update Edit Time in Excel FileNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Kaspersky Internet Security 2021 1 year 1 device key Global Kaspersky Internet Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $24.00
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
Products
  • Office 2019 Professional Plus Key Global Bind to your Microsoft Account Office 2019 Professional Plus Key Global Bind to your Microsoft Account
    Rated 4.97 out of 5
    $49.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
  • Microsoft Visio Standard 2019 Key 1PC Microsoft Visio Standard 2019 Key 1PC $12.00
  • Microsoft Visio Professional 2013 Key 1PC Microsoft Visio Professional 2013 Key 1PC $9.00
  • Windows 10 Pro Key Global Genuine Key Windows 10 Pro Key Global Genuine Key
    Rated 4.78 out of 5
    $6.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
  • Windows Server 2025 Standard Windows Server 2025 Standard $30.00
  • Windows 10 Pro Key Global 20 PC Windows 10 Pro Key Global 20 PC $50.00
  • Microsoft Office Professional Plus 2013 retail CD Key Global Microsoft Office Professional Plus 2013 retail CD Key Global
    Rated 4.97 out of 5
    $11.00
  • Windows Server 2025 Datacenter Windows Server 2025 Datacenter $30.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.