Show or Hide Outline in Excel (Alt + Shift + K)
The Show/Hide Outline feature allows you to quickly expand or collapse grouped data in your worksheet, making it easier to manage large sets of information.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Alt + Shift + K | Option + Command + 8 |
What Does This Shortcut Do?
This shortcut toggles the visibility of outlines for grouped rows or columns in your worksheet, allowing you to collapse or expand grouped sections instantly.
How to Show or Hide Outlines
- Ensure your worksheet contains grouped rows or columns
- Press Alt + Shift + K (Windows) or Option + Command + 8 (Mac)
- The outlines will be toggled between hidden and visible
Tips & Best Practices
- Use this shortcut to quickly manage the visibility of detailed data without ungrouping
- Combine with grouping and subtotal features for professional reports
- Ensure outlines are already applied before using this shortcut
FAQ
- Q: Can I toggle multiple outlines at once?
- A: Yes, this shortcut affects all outlines present in the worksheet.
- Q: Will this affect the data or formulas?
- No, it only changes the visibility of grouped rows or columns.
- Q: Is there a manual way to show/hide outlines?
- Yes, go to Data → Outline → Show/Hide in the Excel ribbon.