Microsoft Excel is an extremely popular Office application among students, offices, researchers. It facilitates a plethora of options to create a huge table. You can create graphs, pie charts, trends of a particular business or scientific model and so on. The numbers of features are almost endless.

As we all know, MS Excel is often used as an efficient data analysis tool. We often work with huge data set, and to understand about the nature of the data, the trend, the variation, we have to perform data analysis on our data. Quick analysis enables you to perform many more formatting like color codes, greater than, less than, icon set, color scale, etc. There are provisions for various tables, pivot tables, charts, etc.

For large data tables, we often need to find the sum or average or any such function on the columns of the table. In such cases, you can use the row total option in MS Excel. The process is very simple and we will show you how to find the total data of a row in a table in MS Excel.

Steps To Total Data Of A Row With Total Row Option in MS Excel

First tap in any cell of the table. Now go to Table Design. Check the box beside Total Row option.

Total Data Of A Row With Total Row Option in MS Excel

Next, click on any bottom row total cell. A dropdown arrow will appear along with the cell. Click on it and select the function, you want, for e.g. SUM or AVERAGE.

Total Data Of A Row With Total Row Option in MS Excel

It’s done! You can select that cell and then expand towards right to apply the same functions on the other rows as well.

Total Data Of A Row With Total Row Option in MS Excel

About 

Happiness is that best therapy. Use it to heal yourself and then others!

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.