Remember to enter the Excel 2010 Future of Productivity Giveaway -- it ends at noon (Eastern time) on Tuesday, June 8th. You could win a copy of Microsoft Office 2010 (with fancy new pivot table features), a Flip video camera, and a Seagate 1TB hard drive.
If you're working with an Excel 2007 pivot table, you might want to temporarily hide one or more of the items in a Row field or Column field. To do that, you probably click the drop down arrow for the Row or Column Labels, then remove the check mark for items you want to remove. That method works, but if the items aren't in ascending or descending order, it can be a pain to find the item you're looking.
Quickly Hide Items
Excel 2007 has enhanced filtering in pivot tables, and this can save you some time. Instead of searching through a long
Continue reading Pain Free Way to Hide Excel Pivot Table Items




Recent Comments