Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel INDIRECT Function
  • Vlookup Examples in Excel
  • Multi-criteria lookup and transpose in Excel
  • Offset in Excel
  • Extract data with helper column in Excel

Data Analysis Examples

  • Error Bars in Excel
  • Everything about Charts in Excel
  • How to create Gauge Chart in Excel
  • How to create dynamic reference table name in Excel
  • Move chart to a separate worksheet in Excel

Data Validation Examples

  • Excel Data validation unique values only
  • Excel Data validation date in specific year
  • Excel Data validation allow uppercase only
  • Excel Data validation must not contain
  • Excel Data validation no punctuation

Add Outline to Data in Excel

by

Outlining data makes your data easier to view. In this example we will total rows of related data and collapse a group of columns.

1. First, sort the data on the Company column.

2. On the Data tab, in the Outline group, click Subtotal.

3. Select the Company column, the column we use to outline our worksheet.

Worked Example:   Advanced Filter in Excel

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 use the numbers to collapse or expand groups by level. For example, click the 2 to only show the subtotals.

Worked Example:   How to Sort by Color in Excel

Note: click the 1 to only show the Grand Count, click the 3 to show everything.

To collapse a group of columns, execute the following steps.

8. For example, select column A and B.

9. On the Data tab, in the Outline group, click Group.

Worked Example:   Use Data Form to input, edit and delete records in Excel


10. Click the minus sign above column C (it will change to a plus sign).

Result:

11. To remove the outline, click any cell inside the data set and on the Data tab, in the Outline group, click Subtotal, Remove all.

Post navigation

Previous Post:

Subtotal function in Excel

Next Post:

Use Data Form to input, edit and delete records in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • LEFT, LEFTB functions: Description, Usage, Syntax, Examples and Explanation
  • TEXTJOIN function: Description, Usage, Syntax, Examples and Explanation
  • How to strip non-numeric characters in Excel
  • Join first and last name — Manipulating NAMES in Excel
  • How to create email address from name in Excel
  • Get week number from date in Excel
  • Steps to create Dynamic calendar grid in Excel
  • Get days between dates in Excel
  • Convert Excel time to decimal minutes
  • Get days between dates ignoring years in Excel
  • DOLLARDE function: Description, Usage, Syntax, Examples and Explanation
  • How to Calculate Tax Rates in Excel
  • Tax rate calculation with fixed base in Excel
  • XIRR function: Description, Usage, Syntax, Examples and Explanation
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles