How to total the data in an Excel table?

If you are looking for a method to total the data in an Excel table, then blog will be helpful to you. You can quickly total the data in a Microsoft Office Excel table by displaying a totals 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. Follow the steps mentioned below and you are done with totaling of data in Excel table.

• 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.

• 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.

It is to be noted that when you enter a formula in the row directly below a table without a total row, the total row is displayed with the formula and without the word Total.

In case there is corruption in MS Excel worksheet and all its data gets corrupt, you can use Kernel for Excel recovery software, which is prudent file repair tool and provides with working Excel file with all its data intact.

MS Office recovery tools are make to recover and repair requirements of users. Every ms office recovery  tool available at here: Office Recovery

Comments are closed.