12 Pro PivotTable Formatting Tricks = No more UGLY PivotTables!

One of the downsides of PivotTables is they have a very distinctive look. Some might even say they’re ugly. In this video I cover 12 PivotTable formatting tricks that will transform their look and feel.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

⏲ TIMESTAMPS
0:00 How to Format PivotTables
0:23 Custom Sort Order
1:24 Column Labels
2:19 Inserting Blank Rows
2:42 Subtotal Position
3:14 Custom Styles
5:08 Expand/Collapse Buttons
5:30 Conditional Formatting
7:58 Repeating Item Labels
8:48 Report Layouts
9:20 Hiding (blank)s
10:08 Preserving Formatting
10:37 Default PivotTable Layout

[tristangeoffroy]

Despite decades of pivot table practice, you just taught me fews things (template formating) I always looked for, in a cristal clear manner. Very professional. Thank you very much.

[Adam_K_W]

This is one of the best videos you've done to date! Thank you so much for consolidating all of this into a simple, easy to navigate, useful set of tips and tricks! Pivot tables are so widely used these days, and even though they are sort of being replaced by Power BI, they still have their place. Awesome.

[mohammedelsakally]

Thank you Mynda for your always valuable contributions to enhance the Excel skills which we are always awaiting from you especially that you are representing the content of each video by an easy and professional way ... Thank you and we are supporting you ever ...

[abdelouahedelmaazouzi]

Perfect format! Once done you can present directly to the Management without any changes or modifications.

[krishna]

Perfect tutorial, straight to the point. Great work. Thank you!

[fusdnmm]

Oh and.... I have learned sooo much from watching your videos! In case you've had your doubts... your time has been well spent!!!

[goingvenus]

THANK YOU! I've been an Excel trainer for over 30 years and using PivotTables since they first came out. I never did learn that you can set PivotTable defaults in the Options dialog box. I"m ecstatic because it never made sense to me that we had to change the PT layout every. single. time. to a specific option. Amazing!

[ivanbork]

Thank you Mynda, always very inspirational to see your tutorials, sometime almost lifechanging.
In this case I have done something similar, and have created my own PivotTable styles, and then saved the workbook as templates .xltx, including introduction sheet and print layout for some sheets added head and footer, and links to a couple of lists holding essential number /- names for categories. All in all it saves time end ensure a consistent in the way the different jobs have

[therealjeffg]

Awesome Mynda, gold nuggets everywhere in that one. Thank you.

[markanthony]

Thank you Mynda, you have made my project i had so easy to present ..thanks for all the free tutorials you do here - I don't take it lightly as a lot of work gone in to prepare for free....I still intend to enroll on one of your paid programs in coming weeks! Thank you and see you on the other side very soon. Stay blessed!!

[silversolver]

Excellent! I've used pivots 'forever' but still learned a couple of things :)

[SeaOfMadness]

The tip of adding the space is genius - Can't believe I didn't think of that before!

[NancyMancarious]

I now know that I've mastered the pivot tables when all of these tips are not new to me. Thank you - always helpful.

[JJ_TheGreat]

5:07 Wow! That is brilliant 👏!
I never knew you could do that! 😀

[Koel]

This is genius! Thanks, Mynda for all the tricks!

[brianxyz]

The sorting tip at the beginning is amazing. Had no idea you could do that!

[JJ_TheGreat]

10:07 Oh, wow! I didn't even think about re-naming the "(blank)" to "" (nothing). I always went into the Pivot Table options in order to hide blanks.

[warrennalty]

To change the headings, I press ctrl-h replace, type Sum of (no space after of) and leave replace with blank. This removes Sum of leaving leading space. Great if there are many headings.

[kevinbush]

Brilliant… pivot tables play such a big part in my stuff, but they ARE ugly.

This will solve that.

I have to say, you and Leila have given me so much finesse in my workbooks.

Thanks Mynda

[sjdyt]

I use pivot tables a lot but I still learned a couple of things here which I hadn’t really thought about before. I’ll be amending my defaults after I press post!