» Setting the Number of Fields Displayed in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
1. Select a cell in the PivotTable report.
2. Right-click and then select Table Options -> Layout & Format tab.
3. Set the number in Report Filter fields per column, and click OK.
Result: Filter fields are grouped by four fields in each column.
Book Store:
Recommended Books:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Microsoft Word Version 2002 Inside Out
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
No comments have been submitted.
