Adding Outline Numbering in ExcelOutlining with Manual NumberingYou can create manual outline numbering such as 1, 1.2, 1.2.3, etc. by converting the cells used for the outline numbers to text. If the number of items will never be greater than 9, you can use a custom number format such ...
2. On the Data tab, in the Outline group, click Subtotal. 3. Select the Company column, the column we use to outline our worksheet. 4. Use the Count function. 5. Check the Company check box. 6. Click OK. Result: 7. To collapse a group of cells, click a minus sign. You can ...
You’d be better off breaking out each region into a separate group of cells, and then tying everything together with another batch of cells that sums up your sales across all regions. Excel’s grouping and outlining features are perfect for dealing with multilayered information like this. ...