Tweak for totaling the data in an Excel table

In this blog, you’ll come to know about simple tweak that allows totaling of data of an Excel table in .xlsx or .xls file.

You can quickly total the data in a MS Office Excel table by displaying a total row at the end of the table and then by using the functions that are provided in drop-down lists for each totals row cell.

For that follow the given below steps:

• Click anywhere in the table.

• This displays the Table Tools, adding the Design tab.

• On the Design tab, in the Table Style Options group, select the Total Row check box.

• The total row appears as the last row in the table and displays the word Total in the leftmost cell.

• In the total row, click the cell in the column for which you want to calculate a total, and then click the drop-down list arrow that appears.

• In the drop-down list, select the function that you want to use to calculate the total.

One interesting thing is formulas that you can use in the total row are not limited to the functions in the list. You can enter any formula that you want in any total row cell.

Use Kernel for Excel recovery software in order to repair corrupt Excel worksheet .xls instantly and accurately.

Comments are closed.