Total the data in an Excel table Click anywhere inside the table. Go to Table Tools > Design, and select the check box for Total Row. The Total Row is inserted at the bottom of your table. ... Select the column you want to total, then select an option from the drop-down list.