Learn Excel-How to Total the Data in an Excel Table?

In the previous post, we saw ‘How to Sort Data in a Table-Microsoft Excel?’, now we will learn about How to Total the data in an Excel table?

Table of Contents hide

1 Where to Find The Total Row Option?

2 What is the use of Total Row option?

3 Shortcut to Enable Total Row

4 Share this:

5 Related

Where to Find The Total Row Option?

Click on the table anywhere after that click on the Design tab [Note: the design tab will be activated after clicking on the table] now find the Table Style Options in that select the box for ‘Total Row’.

What is the use of Total Row option?

After you enable this option in the table You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list for each table column.

Note:

The Total Row default selections use the SUBTOTAL function, which allows you to include or ignore hidden table rows, however, you can also use other functions.

Shortcut to Enable Total Row

Click anywhere in the table and then press

‘CTRL + SHIFT + T’ key then the total row is activated at the end of the table.

Also read other articles @ EduTaxTuber

June 1, 2021How To Create Multiple Ledgers in Tally Prime?

In this article, we will discuss that how we can create multiple ledgers in Tally Prime. If we create multiple ledgers then we can save our time on the other hand If we create a single ledger then it will …

May 29, 2021TallyPrime: Important Shortcut Key ALT + G or GO To

In this article, we will discuss the new and unique shortcut key ALT + G or GO To in the TallyPrime. With the help of the ALT + G shortcut key, you can navigate in tally anywhere. ALT + G …

If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.

The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function

Create TDS Nature of Payment

From the gateway of Tally press “C” then select “TDS Nature of Payments” under the Statutory Masters and press Enter. OR Press “ALT + G” select Create Master press Enter and select “TDS Nature of Payment” under the Statutory Masters and hit the enter button.

How To Check PM- Kisan Samman Nidhi Yojna Beneficiary Status

In this article we will see in detail how to check “PM- Kisan Samman Nidhi Yojna” beneficiary status i.e. whether money is received or not. You can check it Online. You can check in three ways i.e using 1. Aadhar Number, 2. Bank Account Number, and 3. Mobile Number.…. Read More