» Adding Groups and Outlines Manually
CATEGORY - Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
To add groups and outlines manually:1. Select cells to group (cells A2:A4 in the screenshot).
2. Press Alt+Shift+Right Arrow.
OR
From the Data menu, select Group and Outline, and then Group.
3. Repeat this technique for each group.
4. To clear the outlining, select the same rows or columns, and press Alt+Shift+Left Arrow.
Book Store:
Recommended Books:
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Guide to Financial Reporting and Analysis
- Financial Statement Analysis with S&P insert card
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Monte Carlo Methods in Finance
No comments have been submitted.
