Navigate summary and detail levels without mistaking collapsed data for deleted, filtered, excluded or unimportant records
Use a question–workbook–sheet–hierarchy–summary-row-or-column–outline-level–group-boundary–expand-collapse–formula–visible-cell–copy-export–platform-limit–release chain. Treat an outline as a navigational structure, not a verdict about the value of hidden records.
Why this English matters now
Reading Excel’s outline levels before collapsing detail rows and columns is practical English for students, teachers and analysts searching how to group rows in Excel, collapse spreadsheet details or show only summary data.
Microsoft’s current guidance says an Excel outline can organise grouped rows or columns into as many as eight levels. Lower outline numbers represent outer summary levels, higher numbers expose inner detail, and plus or minus symbols expand or collapse groups.
Collapsed is a visibility state, not evidence that the hidden detail has been deleted, checked or excluded from a calculation. Strong readers define the hierarchy, locate summary formulas, inspect every level, distinguish grouping from filtering and manual hiding, copy visible cells carefully and restore a transparent release state.
Checked against the linked first-party sources on 2 November 2026. Interfaces, managed-device rules and school procedures can change, so reopen the current source before a live assessment, disclosure or account decision.
The practical reading method
Use a question–workbook–sheet–hierarchy–summary-row-or-column–outline-level–group-boundary–expand-collapse–formula–visible-cell–copy-export–platform-limit–release chain. Treat an outline as a navigational structure, not a verdict about the value of hidden records.
- Microsoft says an Excel outline can contain up to eight levels.
- Microsoft explains that lower outline numbers represent outer summary information and higher numbers expose inner detail.
- Microsoft documents plus and minus controls for expanding and collapsing groups.
- Microsoft warns that copying only visible outlined data requires selecting Visible cells only, and that removing an outline while detail is hidden can leave rows or columns hidden.
Official factual floor
- Microsoft Support: Outline (group) data in a worksheet
- SEAB 2027 G3 syllabuses for school candidates
- IMDA Digital Skills for Life
- Microsoft says a worksheet outline can contain up to eight levels, with outer summaries at lower level numbers and inner details at higher numbers.
- Microsoft documents grouping rows or columns and using outline symbols to show or hide detail.
- Microsoft says selecting Visible cells only is needed when copying only the displayed outlined data, and cautions that hidden detail can remain hidden if the outline is removed in that state.
Did You Know?
Deleting an outline does not delete its data. Yet Microsoft cautions that if details are hidden when the outline is removed, those rows or columns can remain hidden—so a reviewer may lose the outline controls without regaining the full visible sheet.
Full chapter index
- 1. Define the question and hierarchy
- 2. Preserve the workbook and shared state
- 3. Expand all levels before analysis
- 4. Read outer and inner outline numbers
- 5. Map row group boundaries
- 6. Map column group boundaries
- 7. Check summary positions and formulas
- 8. Distinguish group collapse from filters
- 9. Use plus and minus controls deliberately
- 10. Copy visible cells with care
- 11. Read web and desktop limits
- 12. Remove outlines without stranding hidden detail
- 13. Verify the final shared and exported result
The mechanism
Grouping should express a meaningful relationship among details, subtotals and totals.
Microsoft says an Excel outline can contain up to eight levels. In this chapter, the decisive phrase is define the question and hierarchy. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Rows are grouped merely because they are adjacent, although they belong to different categories.
An Excel outline stores a hierarchy of grouped rows or columns and provides numbered levels plus expand or collapse controls. It changes what is displayed without deleting the underlying cells. It does not validate formulas, declare collapsed records irrelevant, secure hidden information or guarantee that a copied or exported result includes the intended population.
- 1. state question
- 2. name detail unit
- 3. identify summaries
- 4. draw hierarchy
Preserve version history or an authorised copy; identify the workbook, sheet and analysis question; inspect frozen panes, filters, hidden rows and columns, merged cells and protected areas; locate summary labels and formulas; expand all outline levels; map every row and column group; check whether summary rows sit above or below detail and whether summary columns sit left or right; compare formula ranges with group boundaries; test each numbered level and plus or minus control; distinguish grouping from filtering and manual hiding; if copying displayed results, use Go To Special > Visible cells only and label the subset; verify paste dimensions and totals; test the authorised web or desktop environment; before removing an outline, expand the details; save, close and reopen; inspect the exact shared workbook and any exported PDF or CSV; and record the final visibility state. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook and sheet identity, purpose, outline level count, summary positions, group boundaries, summary formulas and ranges, filter state, manually hidden areas, protected areas, selected level, visible row and column counts, copy method, pasted dimensions, platform, web limitations, expand-before-remove check, reopen result, export identity, reviewer and release state.
Transfer: Purpose language supports meaningful structure. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Hidden detail must be seen before a reviewer accepts the summary.
Microsoft documents plus and minus controls for expanding and collapsing groups. In this chapter, the decisive phrase is expand all levels before analysis. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: An outlier remains collapsed and the total is trusted without inspection.
An Excel outline stores a hierarchy of grouped rows or columns and provides numbered levels plus expand or collapse controls. It changes what is displayed without deleting the underlying cells. It does not validate formulas, declare collapsed records irrelevant, secure hidden information or guarantee that a copied or exported result includes the intended population.
- 1. choose highest level
- 2. open all groups
- 3. count records
- 4. scan anomalies
Preserve version history or an authorised copy; identify the workbook, sheet and analysis question; inspect frozen panes, filters, hidden rows and columns, merged cells and protected areas; locate summary labels and formulas; expand all outline levels; map every row and column group; check whether summary rows sit above or below detail and whether summary columns sit left or right; compare formula ranges with group boundaries; test each numbered level and plus or minus control; distinguish grouping from filtering and manual hiding; if copying displayed results, use Go To Special > Visible cells only and label the subset; verify paste dimensions and totals; test the authorised web or desktop environment; before removing an outline, expand the details; save, close and reopen; inspect the exact shared workbook and any exported PDF or CSV; and record the final visibility state. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook and sheet identity, purpose, outline level count, summary positions, group boundaries, summary formulas and ranges, filter state, manually hidden areas, protected areas, selected level, visible row and column counts, copy method, pasted dimensions, platform, web limitations, expand-before-remove check, reopen result, export identity, reviewer and release state.
Transfer: Visibility language supports complete evidence. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Microsoft describes lower numbers as outer summaries and higher numbers as inner detail levels.
Microsoft warns that copying only visible outlined data requires selecting Visible cells only, and that removing an outline while detail is hidden can leave rows or columns hidden. In this chapter, the decisive phrase is read outer and inner outline numbers. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Level 1 is mistaken for the most detailed view.
An Excel outline stores a hierarchy of grouped rows or columns and provides numbered levels plus expand or collapse controls. It changes what is displayed without deleting the underlying cells. It does not validate formulas, declare collapsed records irrelevant, secure hidden information or guarantee that a copied or exported result includes the intended population.
- 1. start at level one
- 2. advance one level
- 3. name new detail
- 4. record maximum level
Preserve version history or an authorised copy; identify the workbook, sheet and analysis question; inspect frozen panes, filters, hidden rows and columns, merged cells and protected areas; locate summary labels and formulas; expand all outline levels; map every row and column group; check whether summary rows sit above or below detail and whether summary columns sit left or right; compare formula ranges with group boundaries; test each numbered level and plus or minus control; distinguish grouping from filtering and manual hiding; if copying displayed results, use Go To Special > Visible cells only and label the subset; verify paste dimensions and totals; test the authorised web or desktop environment; before removing an outline, expand the details; save, close and reopen; inspect the exact shared workbook and any exported PDF or CSV; and record the final visibility state. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook and sheet identity, purpose, outline level count, summary positions, group boundaries, summary formulas and ranges, filter state, manually hidden areas, protected areas, selected level, visible row and column counts, copy method, pasted dimensions, platform, web limitations, expand-before-remove check, reopen result, export identity, reviewer and release state.
Transfer: Level language supports confident navigation. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
A row group should begin and end around the intended detail records.
Microsoft says an Excel outline can contain up to eight levels. In this chapter, the decisive phrase is map row group boundaries. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A subtotal row is accidentally included inside its own detail group.
An Excel outline stores a hierarchy of grouped rows or columns and provides numbered levels plus expand or collapse controls. It changes what is displayed without deleting the underlying cells. It does not validate formulas, declare collapsed records irrelevant, secure hidden information or guarantee that a copied or exported result includes the intended population.
- 1. mark first row
- 2. mark last row
- 3. identify summary row
- 4. check nested groups
Preserve version history or an authorised copy; identify the workbook, sheet and analysis question; inspect frozen panes, filters, hidden rows and columns, merged cells and protected areas; locate summary labels and formulas; expand all outline levels; map every row and column group; check whether summary rows sit above or below detail and whether summary columns sit left or right; compare formula ranges with group boundaries; test each numbered level and plus or minus control; distinguish grouping from filtering and manual hiding; if copying displayed results, use Go To Special > Visible cells only and label the subset; verify paste dimensions and totals; test the authorised web or desktop environment; before removing an outline, expand the details; save, close and reopen; inspect the exact shared workbook and any exported PDF or CSV; and record the final visibility state. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook and sheet identity, purpose, outline level count, summary positions, group boundaries, summary formulas and ranges, filter state, manually hidden areas, protected areas, selected level, visible row and column counts, copy method, pasted dimensions, platform, web limitations, expand-before-remove check, reopen result, export identity, reviewer and release state.
Transfer: Boundary language supports correct grouping. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Columns can group time periods, measures or supporting calculations.
Microsoft explains that lower outline numbers represent outer summary information and higher numbers expose inner detail. In this chapter, the decisive phrase is map column group boundaries. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A key identifier column disappears with optional detail measures.
An Excel outline stores a hierarchy of grouped rows or columns and provides numbered levels plus expand or collapse controls. It changes what is displayed without deleting the underlying cells. It does not validate formulas, declare collapsed records irrelevant, secure hidden information or guarantee that a copied or exported result includes the intended population.
- 1. protect identifiers
- 2. mark first column
- 3. mark last column
- 4. check nested columns
Preserve version history or an authorised copy; identify the workbook, sheet and analysis question; inspect frozen panes, filters, hidden rows and columns, merged cells and protected areas; locate summary labels and formulas; expand all outline levels; map every row and column group; check whether summary rows sit above or below detail and whether summary columns sit left or right; compare formula ranges with group boundaries; test each numbered level and plus or minus control; distinguish grouping from filtering and manual hiding; if copying displayed results, use Go To Special > Visible cells only and label the subset; verify paste dimensions and totals; test the authorised web or desktop environment; before removing an outline, expand the details; save, close and reopen; inspect the exact shared workbook and any exported PDF or CSV; and record the final visibility state. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook and sheet identity, purpose, outline level count, summary positions, group boundaries, summary formulas and ranges, filter state, manually hidden areas, protected areas, selected level, visible row and column counts, copy method, pasted dimensions, platform, web limitations, expand-before-remove check, reopen result, export identity, reviewer and release state.
Transfer: Column language supports interpretable data. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Excel can place summary rows below or above detail and summary columns to the right or left.
Microsoft documents plus and minus controls for expanding and collapsing groups. In this chapter, the decisive phrase is check summary positions and formulas. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: The visible subtotal appears above detail but its formula excludes the final row.
An Excel outline stores a hierarchy of grouped rows or columns and provides numbered levels plus expand or collapse controls. It changes what is displayed without deleting the underlying cells. It does not validate formulas, declare collapsed records irrelevant, secure hidden information or guarantee that a copied or exported result includes the intended population.
- 1. record summary position
- 2. inspect range references
- 3. recalculate
- 4. compare independent total
Preserve version history or an authorised copy; identify the workbook, sheet and analysis question; inspect frozen panes, filters, hidden rows and columns, merged cells and protected areas; locate summary labels and formulas; expand all outline levels; map every row and column group; check whether summary rows sit above or below detail and whether summary columns sit left or right; compare formula ranges with group boundaries; test each numbered level and plus or minus control; distinguish grouping from filtering and manual hiding; if copying displayed results, use Go To Special > Visible cells only and label the subset; verify paste dimensions and totals; test the authorised web or desktop environment; before removing an outline, expand the details; save, close and reopen; inspect the exact shared workbook and any exported PDF or CSV; and record the final visibility state. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook and sheet identity, purpose, outline level count, summary positions, group boundaries, summary formulas and ranges, filter state, manually hidden areas, protected areas, selected level, visible row and column counts, copy method, pasted dimensions, platform, web limitations, expand-before-remove check, reopen result, export identity, reviewer and release state.
Transfer: Formula language supports trustworthy summaries. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Both can reduce visible rows, but they represent different operations.
Microsoft warns that copying only visible outlined data requires selecting Visible cells only, and that removing an outline while detail is hidden can leave rows or columns hidden. In this chapter, the decisive phrase is distinguish group collapse from filters. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A filtered population is described as merely collapsed detail.
An Excel outline stores a hierarchy of grouped rows or columns and provides numbered levels plus expand or collapse controls. It changes what is displayed without deleting the underlying cells. It does not validate formulas, declare collapsed records irrelevant, secure hidden information or guarantee that a copied or exported result includes the intended population.
- 1. inspect filter buttons
- 2. check status bar
- 3. review hidden rows
- 4. name active mechanism
Preserve version history or an authorised copy; identify the workbook, sheet and analysis question; inspect frozen panes, filters, hidden rows and columns, merged cells and protected areas; locate summary labels and formulas; expand all outline levels; map every row and column group; check whether summary rows sit above or below detail and whether summary columns sit left or right; compare formula ranges with group boundaries; test each numbered level and plus or minus control; distinguish grouping from filtering and manual hiding; if copying displayed results, use Go To Special > Visible cells only and label the subset; verify paste dimensions and totals; test the authorised web or desktop environment; before removing an outline, expand the details; save, close and reopen; inspect the exact shared workbook and any exported PDF or CSV; and record the final visibility state. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook and sheet identity, purpose, outline level count, summary positions, group boundaries, summary formulas and ranges, filter state, manually hidden areas, protected areas, selected level, visible row and column counts, copy method, pasted dimensions, platform, web limitations, expand-before-remove check, reopen result, export identity, reviewer and release state.
Transfer: Mechanism language supports honest interpretation. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
A minus hides a group’s detail; a plus restores it.
Microsoft says an Excel outline can contain up to eight levels. In this chapter, the decisive phrase is use plus and minus controls deliberately. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A reviewer clicks a control beside the wrong nested group and approves the wrong scope.
An Excel outline stores a hierarchy of grouped rows or columns and provides numbered levels plus expand or collapse controls. It changes what is displayed without deleting the underlying cells. It does not validate formulas, declare collapsed records irrelevant, secure hidden information or guarantee that a copied or exported result includes the intended population.
- 1. trace bracket line
- 2. name group
- 3. toggle once
- 4. verify visible range
Preserve version history or an authorised copy; identify the workbook, sheet and analysis question; inspect frozen panes, filters, hidden rows and columns, merged cells and protected areas; locate summary labels and formulas; expand all outline levels; map every row and column group; check whether summary rows sit above or below detail and whether summary columns sit left or right; compare formula ranges with group boundaries; test each numbered level and plus or minus control; distinguish grouping from filtering and manual hiding; if copying displayed results, use Go To Special > Visible cells only and label the subset; verify paste dimensions and totals; test the authorised web or desktop environment; before removing an outline, expand the details; save, close and reopen; inspect the exact shared workbook and any exported PDF or CSV; and record the final visibility state. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook and sheet identity, purpose, outline level count, summary positions, group boundaries, summary formulas and ranges, filter state, manually hidden areas, protected areas, selected level, visible row and column counts, copy method, pasted dimensions, platform, web limitations, expand-before-remove check, reopen result, export identity, reviewer and release state.
Transfer: Action language supports precise review. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Microsoft documents Visible cells only when copying just displayed outlined data.
Microsoft explains that lower outline numbers represent outer summary information and higher numbers expose inner detail. In this chapter, the decisive phrase is copy visible cells with care. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A pasted report silently includes collapsed detail because an ordinary copy was used.
An Excel outline stores a hierarchy of grouped rows or columns and provides numbered levels plus expand or collapse controls. It changes what is displayed without deleting the underlying cells. It does not validate formulas, declare collapsed records irrelevant, secure hidden information or guarantee that a copied or exported result includes the intended population.
- 1. select exact range
- 2. choose Visible cells only
- 3. paste to test sheet
- 4. compare totals
Preserve version history or an authorised copy; identify the workbook, sheet and analysis question; inspect frozen panes, filters, hidden rows and columns, merged cells and protected areas; locate summary labels and formulas; expand all outline levels; map every row and column group; check whether summary rows sit above or below detail and whether summary columns sit left or right; compare formula ranges with group boundaries; test each numbered level and plus or minus control; distinguish grouping from filtering and manual hiding; if copying displayed results, use Go To Special > Visible cells only and label the subset; verify paste dimensions and totals; test the authorised web or desktop environment; before removing an outline, expand the details; save, close and reopen; inspect the exact shared workbook and any exported PDF or CSV; and record the final visibility state. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook and sheet identity, purpose, outline level count, summary positions, group boundaries, summary formulas and ranges, filter state, manually hidden areas, protected areas, selected level, visible row and column counts, copy method, pasted dimensions, platform, web limitations, expand-before-remove check, reopen result, export identity, reviewer and release state.
Transfer: Transfer language supports accurate extracts. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Microsoft says the web supports outline use but some configuration and styling options differ.
Microsoft documents plus and minus controls for expanding and collapsing groups. In this chapter, the decisive phrase is read web and desktop limits. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A browser user assumes a missing setting means the workbook is corrupt.
An Excel outline stores a hierarchy of grouped rows or columns and provides numbered levels plus expand or collapse controls. It changes what is displayed without deleting the underlying cells. It does not validate formulas, declare collapsed records irrelevant, secure hidden information or guarantee that a copied or exported result includes the intended population.
- 1. name platform
- 2. read current support
- 3. avoid unsupported edits
- 4. test desktop if authorised
Preserve version history or an authorised copy; identify the workbook, sheet and analysis question; inspect frozen panes, filters, hidden rows and columns, merged cells and protected areas; locate summary labels and formulas; expand all outline levels; map every row and column group; check whether summary rows sit above or below detail and whether summary columns sit left or right; compare formula ranges with group boundaries; test each numbered level and plus or minus control; distinguish grouping from filtering and manual hiding; if copying displayed results, use Go To Special > Visible cells only and label the subset; verify paste dimensions and totals; test the authorised web or desktop environment; before removing an outline, expand the details; save, close and reopen; inspect the exact shared workbook and any exported PDF or CSV; and record the final visibility state. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook and sheet identity, purpose, outline level count, summary positions, group boundaries, summary formulas and ranges, filter state, manually hidden areas, protected areas, selected level, visible row and column counts, copy method, pasted dimensions, platform, web limitations, expand-before-remove check, reopen result, export identity, reviewer and release state.
Transfer: Platform language supports practical troubleshooting. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
Four useful discoveries
Define the question and hierarchy
Grouping should express a meaningful relationship among details, subtotals and totals.
Boundary: A sheet can support more than one reasonable hierarchy.
Preserve the workbook and shared state
Outlining changes workbook structure and can affect collaborators.
Boundary: A backup does not replace access control.
Expand all levels before analysis
Hidden detail must be seen before a reviewer accepts the summary.
Boundary: Very large sheets may need staged review.
Read outer and inner outline numbers
Microsoft describes lower numbers as outer summaries and higher numbers as inner detail levels.
Boundary: Numbering describes hierarchy, not importance.
Practice with realistic decisions
Map row group boundaries
A subtotal row is accidentally included inside its own detail group.
- mark first row
- mark last row
- identify summary row
- check nested groups
Map column group boundaries
A key identifier column disappears with optional detail measures.
- protect identifiers
- mark first column
- mark last column
- check nested columns
Check summary positions and formulas
The visible subtotal appears above detail but its formula excludes the final row.
- record summary position
- inspect range references
- recalculate
- compare independent total
Advice for students, families and educators
For students
- Expand every level before deciding what the worksheet proves.
- Label a copied summary as visible outlined data, not the complete dataset.
For families
- Ask the learner to show what the plus and minus controls reveal before discussing totals.
- Help compare a printout with the full workbook so collapsed evidence is not forgotten.
For educators
- Assess whether group boundaries and summary formulas match the stated hierarchy.
- Require students to name filters, manual hiding and outline collapse separately.
Frequently asked questions
What is an Excel outline?
A hierarchy of grouped rows or columns with level and expand-or-collapse controls.
How many levels are supported?
Microsoft says up to eight outline levels.
What does level 1 show?
The outermost summary view; higher numbers reveal more detailed levels.
Does collapse delete data?
No; it changes visibility.
Is grouping the same as filtering?
No. Grouping expresses a hierarchy, while filtering selects records by criteria.
Can hidden outline data be copied accidentally?
Yes; Microsoft documents Visible cells only when copying just the displayed data.
What happens if I remove the outline?
The data remains, but hidden detail can remain hidden if it was collapsed first.
Does Excel for the web support outlines?
It supports viewing and grouping, but current Microsoft guidance notes configuration and styling limits.
What must I verify?
Groups, formulas, levels, filters, hidden cells, copies, platform behaviour and final visibility.
Why English?
Because group, outline, level, summary, detail, collapse, hide, filter and delete describe different states.
Useful next reading
- Excel Sheet View — separate personal filter views from structural grouping
- Filtered spreadsheet subset — interpret visible records without calling them the whole population
- Why English Matters in Singapore — connect precise spreadsheet language to study and work
Closing thought
A useful outline makes a large worksheet easier to read while keeping its evidence available. Expand before judging, match formulas to group boundaries, label every visible-only copy and return the workbook in a state another reader can understand.