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

Lookup and Reference Examples

  • How to reference named range different sheet in Excel
  • How to get address of last cell in range in Excel
  • Two-column Lookup in Excel
  • Count rows with at least n matching values
  • How to use Excel MMULT Function

Data Analysis Examples

  • Use Data Form to input, edit and delete records in Excel
  • How to create Checklist in Excel
  • How To Compare Two Lists in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • How to Create Area Chart in Excel

Data Validation Examples

  • Excel Data validation exists in list
  • Excel Data validation don’t exceed total
  • Excel Data validation no punctuation
  • Excel Data validation date in next 30 days
  • Excel Data validation specific characters only

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:   Number and Text Filters Examples 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:   Remove Duplicates Example 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
  • DOLLAR function: Description, Usage, Syntax, Examples and Explanation
  • How to count total words in a cell in Excel
  • How to count total characters in a range in Excel
  • LEFT, LEFTB functions: Description, Usage, Syntax, Examples and Explanation
  • How to check if cell contains number in Excel
  • How to get same date next year or previous year in Excel
  • Convert Excel time to Unix time in Excel
  • Convert decimal seconds to Excel time
  • Add workdays no weekends in Excel
  • Convert date to Julian format in Excel
  • EFFECT function: Description, Usage, Syntax, Examples and Explanation
  • PMT, RATE, NPER, PV and FV Financial Functions in Excel
  • Calculate interest rate for loan in Excel
  • Example of Future value of annuity in Excel
  • Example of payment for annuity in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles