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.
🔖RELATED TUTORIALS: Conditional Formatting: • Conditional Formatting...
Original PivotTable Profit & Loss Report tutorial and file: www.myonlinetraininghub.com/e...
🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ 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

[@tristangeoffroy9286]

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.

[@MyOnlineTrainingHub]

Great to hear!

[@marcovirtual]

Yes! I work with Excel pretty much everyday, but Mynda's videos never fail to teach me new things. I love it!

[@koitaki]

What Tristan said...some really creative stuff here, thanks Myanda!

[@ivanbork4175]

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

[@MyOnlineTrainingHub]

Great idea, Ivan!

[@Donkeys_Dad_Adam]

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.

[@MyOnlineTrainingHub]

So pleased you liked it 🙏

[@mohammedelsakally540]

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 ...

[@MyOnlineTrainingHub]

Thank you so much for your support 🙏😊

[@goingvenus5603]

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!

[@MyOnlineTrainingHub]

Glad you can make use of it 😊

[@krishna6296]

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

[@MyOnlineTrainingHub]

So glad you liked it! 🙏

[@abdelouahedelmaazouzi6102]

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

[@MyOnlineTrainingHub]

Indeed!

[@therealjeffg]

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

[@MyOnlineTrainingHub]

Great to hear!

[@markanthony7078]

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!!

[@MyOnlineTrainingHub]

Wonderful to hear you've found my tutorials helpful 🙏😊 see you in a course someday where I can share even more.

[@billyjayamunga]

Exactly what I was looking for. Brilliant as always. Thanks Mynda!

[@MyOnlineTrainingHub]

You're so welcome! 😊🙏

[@dompedro14]

As always Mynda you provide excellent tutorials in a simple and easy way to understand. Thanks so much.

[@MyOnlineTrainingHub]

So glad you like them! 🙏

[@vijayarjunwadkar]

Thank you Mynda for yet another practical and useful video for the most commonly used but often confused; Pivot Tables. I got to know many new things. Keep up the great work!

[@MyOnlineTrainingHub]

Thanks so much, Vijay!

[@chrism9037]

Awesome. Tons of useful stuff, thanks Mynda!

[@MyOnlineTrainingHub]

Cheers, Chris!

[@shadrackawunyo7786]

Very well showcased Mynda. I love the presentation

[@MyOnlineTrainingHub]

Thank you so much 🤗

[@vanbap5638]

Great. Thank you very much! I applied it to my report.

[@MyOnlineTrainingHub]

Awesome to hear!

[@TheTinaMarbury]

You are the BEST excel teacher EVER!😁

[@MyOnlineTrainingHub]

Aw, thanks so much 🙏😊

[@ChessmasterSunnyKow888]

Hi Mynda You are really the best.

[@MyOnlineTrainingHub]

Aw, thanks so much!

[@MegaTrickykid]

Simply great! Thanks for this outstanding tutorial!

[@MyOnlineTrainingHub]

🙏 Glad you liked it!

[@IsAllAboutHealth]

Thank you! Love your videos. Great explanation with great tips!

[@MyOnlineTrainingHub]

Thanks so much. Glad you like them!

[@richaldaoud8416]

Thank you, very helpful video. Short and nice

[@MyOnlineTrainingHub]

So glad you liked it

[@silversolver7809]

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

[@MyOnlineTrainingHub]

Great to hear it was worth your time to watch 🙏

[@user-fu6sd1nm9m]

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

[@MyOnlineTrainingHub]

That's awesome to hear! 🙏😊

[@aicx40]

Awesome. Thanks for sharing.

[@MyOnlineTrainingHub]

Thanks for watching!

[@jawadahmadehssan6251]

Thank you Mynda. It was indeed useful

[@MyOnlineTrainingHub]

So glad! 😊

[@Koel0202]

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

[@MyOnlineTrainingHub]

My pleasure!

[@marcolevasquez]

Hy Mynda, great video. This was very helpful for me; saving a bunch of time. Thanks!

[@MyOnlineTrainingHub]

Awesome to hear 🙏

[@brianxyz]

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

[@MyOnlineTrainingHub]

Glad it was helpful!

[@ricardomantovaniassis]

Thank you so much, Mynda. 🥰🥰🙌

[@MyOnlineTrainingHub]

My pleasure!

[@internet_wanderer8316]

Thank you so much. Very useful info

[@MyOnlineTrainingHub]

Great to hear!

[@TheAndresOpeth]

AMAZING! Thanks a lot for everything!🤗

[@MyOnlineTrainingHub]

Glad you liked it! 🙏😊

[@karennguyen7083]

Great video as usual. Thank u so much, Mynda 🤩

[@MyOnlineTrainingHub]

Thanks for watching!

[@mogarrett3045]

excellent tips as always...thank you

[@MyOnlineTrainingHub]

Glad you like them!

[@Pshor]

You are indeed the best I have watched! Thank you

[@MyOnlineTrainingHub]

Wow, thank you!

[@SeaOfMadness]

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

[@MyOnlineTrainingHub]

So pleased you can make use of it 😊

[@mickaeltaieb6161]

Great video!

[@MyOnlineTrainingHub]

Thank you!

[@2bczar4u]

Wow, quite a few little tricks I did not know. Thank you once again!

[@MyOnlineTrainingHub]

Great to hear 😊

[@tomascoleto]

So cool and useful 👌. Lots of thanks 😊

[@MyOnlineTrainingHub]

Glad to hear that!

[@jeannekoh9544]

Just subscribed! Thanks for these tips!😊

[@MyOnlineTrainingHub]

Awesome 🙏 welcome!

[@mamtabhat5221]

You are the best...Many many thanks

[@MyOnlineTrainingHub]

So nice of you 🙏😊

[@rajeshmajumdar4999]

Superb Very Useful. Thank You so much!

[@MyOnlineTrainingHub]

So nice of you 🙏

[@raihansafa5514]

Thank you so much, really helpful

[@MyOnlineTrainingHub]

Glad it helped! 😊🙏

[@JJ_TheGreat]

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

[@MyOnlineTrainingHub]

It's the little things that count 😊

[@BlackCowOppa]

Very useful, thanks! 😊

[@MyOnlineTrainingHub]

Glad it was helpful!

[@mehdishahidian2711]

You are the best, Thank you!

[@MyOnlineTrainingHub]

Thanks so much!

[@StanEby1]

Wow! Thank you, Your Royal Awesomeness!

[@MyOnlineTrainingHub]

😁glad you liked it!

[@Kursatural]

Thank you for sharing!

[@MyOnlineTrainingHub]

My pleasure!

[@djl8710]

Thanks for doing this!

[@MyOnlineTrainingHub]

My pleasure!

[@MrJucesar2005]

This is super helpful.

[@MyOnlineTrainingHub]

I'm so glad!

[@saidechchababe9938]

Thanks a lot, Very useful

[@MyOnlineTrainingHub]

Glad to hear that 😊

[@sachinkishore4115]

Thank you so much. its very useful tricks

[@MyOnlineTrainingHub]

Awesome to hear!

[@kudifilipe9875]

Thanks 4 sharing, and level up my Excel skills...

[@MyOnlineTrainingHub]

Great to hear!

[@NewYears1978]

The number of times I have had a pivot table that I had to go and convert to just a normal data table and try to move over to the left the main field.... I had no clue you could repeat the labels and also TAB format which does what I was doing manually already. Wow. Great video =D

[@MyOnlineTrainingHub]

So pleased you can save some time with these techniques 😊

[@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!

[@MyOnlineTrainingHub]

Awesome to hear 😊

[@kevinbush4300]

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

[@MyOnlineTrainingHub]

Wonderful to hear, Kevin!

[@geovanrocha2822]

Hi Mynda, Thank you very much for sharing this. It would be nice if you make another video about pivot chart formatting tricks. I always struggle with them because they change format when I use slicers, for example.

[@MyOnlineTrainingHub]

With Pivot Charts, you must clear all filters, then apply formatting. HTH.

[@alexanderbaranov5418]

Best video book about Excel on the KZbin 👍

[@MyOnlineTrainingHub]

Wow, thanks!

[@danielhartjes2479]

Very nice video. Thank you!

[@MyOnlineTrainingHub]

Glad you liked it!

[@ExcelTemplatesSolutions]

Very useful, thanks

[@MyOnlineTrainingHub]

Glad to hear that! 🙏

[@TheIvalen]

Pivot tables are my life. I'll take any of your design tips any day! I usually find myself using the pivot table for data analysis and then copying pasting the data to a static table so I can make it pretty/ready for consumption. Ok, I will try from now on just to use the Pivot table only. The reason for the static table is I often have to insert rows of 'dates' with no additional data to provide a continuous timeline and the Pivot table doesn't let me do that (at least I don't think it can) without modifying the raw input data.

[@MyOnlineTrainingHub]

Glad this video was helpful. This tutorial explains how to make PivotTables display missing dates: www.myonlinetraininghub.com/display-missing-dates-in-excel-pivottables

[@vishwanath1810]

Learnt so many new things despite using excel for years now!! Thanks again 🤝

[@MyOnlineTrainingHub]

Great to hear!

[@HenricAndersen]

I feel much like a pivot table master, but newertheless I learned a few new things. Thank you very much Mynda 🙏

[@MyOnlineTrainingHub]

I'm so glad it was worth your time to watch!

[@gabytobin2695]

Thank you!

[@MyOnlineTrainingHub]

Pleasure!

[@ahmedshalaby9343]

Greetings from Egypt , great and very simple video thank you

[@MyOnlineTrainingHub]

Thanks for watching!

[@ARTHURYUNZAL]

thank you, much appreciated :)

[@MyOnlineTrainingHub]

You're welcome!

[@AmjadKhan-ng2xk]

good job, nice way of explaination

[@MyOnlineTrainingHub]

Thanks so much!

[@Earth-360]

You are a gem

[@MyOnlineTrainingHub]

Thank you!

[@GiteshBajaj]

Helped!

[@MyOnlineTrainingHub]

Great to hear!

[@cogiangxcel693]

thank you, very hepful

[@MyOnlineTrainingHub]

Glad to hear that!

[@JJ_TheGreat]

Also, thanks for showing how to configure the default Pivot Table layout. I didn't know about that, either.

[@MyOnlineTrainingHub]

So pleased you found so many nuggets in this video 😊

[@vernacularbarnarchitecture]

Exactly. Same!!

[@hazemali382]

Lovely Mynda ♥

[@MyOnlineTrainingHub]

Thank you!

[@Everyonelovesyou]

Very useful video for all excel users

[@MyOnlineTrainingHub]

Glad you think so! 🙏😊

[@balasooriyamahesh]

Thank you ❤

[@MyOnlineTrainingHub]

You're welcome 😊

[@CideeTV]

thanks for the sharing..

[@MyOnlineTrainingHub]

My pleasure 😊

[@robparker1625]

Very useful 👍

[@MyOnlineTrainingHub]

Glad you think so!

[@datareggibi]

Amazing!

[@MyOnlineTrainingHub]

Thanks! 😊

[@ynotedaw6960]

Thank you! I did not know that pivot tables could have custom formatting. This is very helpful.

[@MyOnlineTrainingHub]

Glad I could help!

[@jerg83]

Great!. 👏🏼👏🏼

[@MyOnlineTrainingHub]

Thank you! 😃

[@nusratshaheen4737]

Awesome & thnx

[@MyOnlineTrainingHub]

Most welcome 😊

[@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.

[@MyOnlineTrainingHub]

Great to hear!

[@GothicPrincezz]

Great vid!

[@MyOnlineTrainingHub]

Thank you!

[@arkai59]

I already knew some of these tricks but it is still very impressive. You really are at the top of your game, Mynda, thanks for your great input with your channel 🙂

[@MyOnlineTrainingHub]

Thanks so much for your kind words!

[@tanweerabbasabbas649]

mynda. you are cool!!

[@MyOnlineTrainingHub]

Glad you liked my video 😊🙏

[@steven.h0629]

❤Yes.. useful and been there 👍😎✊

[@MyOnlineTrainingHub]

🙏

[@user-jp3kg5ue5t]

thanks you!

[@MyOnlineTrainingHub]

You're welcome!

[@AlbertoSaravia]

Thank you :)

[@MyOnlineTrainingHub]

You're welcome!

[@MuhammadIrfan-wr8zo]

Pronounce extreme convex and sweet accent and perfection.. Outstanding.

[@MyOnlineTrainingHub]

Thank you!

[@shiltonshilton5898]

I love you so much ❤❤❤

[@MyOnlineTrainingHub]

Glad the video was helpful 😊

[@warrennalty6599]

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.

[@MyOnlineTrainingHub]

Great tip 🙏

[@luisalonso3018]

Excellent video, thank you! Suggestion: can you do a video teaching us tips on how to format the slicers for pivot tables. That would be great! Thank you once again.

[@MyOnlineTrainingHub]

Already done one here: kzbin.info/www/bejne/gXa9q3qrZrJ8j5Y

[@SybedeJong]

Hi Mynda, Thanks for the great video. I was wondering why you mentioned having all row labels on for lookup purposes, while you can also use the getpivotdata function. I see there may be situations in which one is preferred over the other. Maybe a nice one for another video some day?

[@MyOnlineTrainingHub]

Thank you! GETPIVOTDATA can perform a lookup of sorts, but it's not as user friendly as XLOOKUP and for that you need row labels repeated. I love GETPIVOTDATA too. I did a video on it here: kzbin.info/www/bejne/gnXJkIKIo7h2q5Y

[@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.

[@MyOnlineTrainingHub]

Typing over the blank in the cell is just a shortcut to editing how the PivotTable handles blanks in the Options dialog box.

[@FutureCommentary1]

I had noted this video and woke up super early today to watch it. Everybody is all power pivot and pivot tables from data models today when really sometimes a regular old pivot table does the job. They look so ugly. I have been using Excel forever. I don't know why I never really explored the formatting options. I usually copy the data from the table and do the formatting elsewhere (smh at myself lol). Thanks for this vid.

[@MyOnlineTrainingHub]

Awesome to hear you'll be able to make use of these techniques!

[@amralsabban3533]

Thanks

[@MyOnlineTrainingHub]

Welcome 😊

[@eleburciaga6769]

Hello, can you do a center of gravity tutorial to select an optimal location for an office?

[@ecnerwalp8681]

Lifesaver

[@MyOnlineTrainingHub]

Great to hear 🙏

[@txreal2]

Forgot all about Default PivotTable Layout. Thanks!

[@MyOnlineTrainingHub]

Glad it was worth your time to watch 😊

[@ConnerZee]

I thought I i knew all there was about pivot tables and im no novice haha! Im definitely going to implement a few if these tips ASAP

[@MyOnlineTrainingHub]

Awesome to hear 😁

[@tanweerabbasabbas649]

You sre so. Cooool😘

[@MyOnlineTrainingHub]

Thank you! 😃

[@aiasaiascon3894]

Wow!!!!

[@MyOnlineTrainingHub]

Glad you liked it 🙏