WebExcel Help & Training. Tables. Total the data in an Excel table. Newer Windows versions Newer Mac versions Web. 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.