How to Set Up a Totaling Spreadsheet in Excel. Understanding how cells behave in relation to one another is essential to getting the most out of Microsoft Excel.