For a general spreadsheet guide, check out how to make a spreadsheet in Excel and format it. If you’re looking for Excel database info, read our guide on creating a database from an Excel spreadsheet. Are you using the free version of Excel and considering upgrading to Microsoft 365? See our coupon site for Staples discounts.
Select a cell in the data range. Go to the Data tab and click Subtotal in the Outline group. Insert summary rows with your own formulas. For example, you could use the SUM function to subtotal information. These can go above or below the data. If you place your summary rows above the data, open the dialog box in the Outline group of the Data tab (it’s the right angle with an arrow). Uncheck “Summary rows below detail. ”
Your data must have column headers and no blank lines for this feature to work.
If you receive a pop-up box that says “Cannot create an outline”, your data doesn’t have an outline-compatible formula in it. You may also have some blank cells in your data or missing column headers. You’ll need to manually outline the data.
If you receive a pop-up box that says “Cannot create an outline”, your data doesn’t have an outline-compatible formula in it. You may also have some blank cells in your data or missing column headers. You’ll need to manually outline the data.
