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 ROWS Function
  • Count rows that contain specific values in Excel
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • Basic INDEX MATCH approximate in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples

Data Analysis Examples

  • Conditional Formatting Data bars Examples in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • Create Scatter Chart in Excel
  • How to Create Area Chart in Excel

Data Validation Examples

  • Excel Data validation don’t exceed total
  • Excel Data validation allow weekday only
  • Excel Data validation unique values only
  • Excel Data validation specific characters only
  • 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:   How To Sort One Column or Multiple Columns 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:   Subtotal function 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
  • REPT function: Description, Usage, Syntax, Examples and Explanation
  • How to compare two text strings in Excel
  • How to extract word containing specific text in Excel
  • How to extract domain from email address in Excel
  • Convert Text to Numbers in Excel
  • Add months to date in Excel
  • How to get workdays between dates in Excel
  • Calculate time difference in hours as decimal value in Excel
  • Basic overtime calculation formula in Excel
  • Extract time from a date and time in Excel
  • ODDLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • Example of Future value of annuity in Excel
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
  • PRICEDISC function: Description, Usage, Syntax, Examples and Explanation
  • ACCRINT function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles