Skip navigation

Expanding and collapsing with grouping and outlining symbols

Expanding and collapsing with grouping and outlining symbols: Excel 2016: Managing and Analyzing Data
Expanding and collapsing with grouping and outlining symbols: Excel 2016: Managing and Analyzing Data

After inserting one or more levels of subtotals, use the outline numbers and symbols that appear on the left side of the list to collapse and expand the list to show just summary rows or summary rows along with detailed original data. Top copy a subtotaled list, press Alt+semicolon first to select only visible data.

Resume Transcript Auto-Scroll
Skill Level Intermediate
3h
Duration
93,649
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now