Excel Tips
Present a Pivot Table in High-to-Low Order by Revenue »
December 22, 2022
A pivot table organizes data alphabetically by default. I want to produce a report that is sorted high to low by revenue.
Manually Re-sequence the Order of Data in a Pivot Table »
December 21, 2022
By default, a pivot table organizes data alphabetically. For the Region field, this means the data is organized with Central first, East second, and West third. My manager wants the regions to appear in the order East, Central, West. After unsuccessfully lobbying to have the Central region renamed Middle, I need to find a way to have my table sequenced with the East region first.
Can I Save Formatting in a Template? »
December 20, 2022
Every month, I have to change my pivot table formatting. Can I create a template to remember my favorite settings?
Apply Conditional Formatting to a Pivot Table »
December 19, 2022
The new conditional formatting options in Excel are amazing, but they require special care in pivot tables. If you include the grand total row, it will get the largest data bars, and the detail cells have relatively meaningless bars.
Select Pivot Table Parts For Formatting »
December 16, 2022
I want to manually format a pivot table. Can I select all the row subtotals? For example, select the region totals in rows 8, 12, and 16.
None of the 46,273 Built-In Styles Do What My Manager Asks For »
December 15, 2022
My manager asks for a pivot table to be formatted with alternating stripes that are two rows high. None of the built-in styles do this.
Format Pivot Tables with the Gallery »
December 14, 2022
Due to the dynamic nature of pivot tables, it is fairly hard to format them. If I start applying formats to individual cells, the formats are lost after I rearrange the pivot table. Help!
December 13, 2022
I hate Compact layout in Pivot Tables. I want all future pivot tables to start in Tabular.
Show Yes/No in a Pivot Table »
December 12, 2022
I want to show Yes/No values in a pivot table. If the customer bought from us in a period, show Yes. If there were no sales, show No.