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?
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.
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
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
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.
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
For Latest Updates & Learning Join Our YouTube Channel: Join Now