@theofficelabhq: PivotTables are powerful, but their default layout isn’t always the easiest to work with. 👀 A few quick layout changes can turn them into clean, reusable tables for formulas, custom charts, and reports. Save this for the next time you’re working with a PivotTable. 📌 #excel #exceltips #pivottable #exceltutorial #learnexcel

The Office Lab
The Office Lab
Open In TikTok:
Region: DE
Tuesday 25 August 2026 15:47:08 GMT
158555
6246
30
554

Music

Download

Comments

vivi30251
vivi :
You can make this as the default layout
2026-08-26 08:04:09
39
us.user.6548
No Name :) :
Instead use formula. Pivot by
2026-08-27 03:04:39
6
user049034928
Bacon :
Just make it the classic look
2026-08-27 11:59:40
7
bonettttti
bonetti :
This is what I do for every single table every single day
2026-08-27 22:10:35
2
gumdrops101
🎀 :
literally needed this video earlier today 😭
2026-08-28 03:27:20
3
mlrodrigo69
Maria :
Thank you! I was struggling to figure this out. So glad I found this in time🫶
2026-08-28 18:36:18
1
jackstarkey_8
JJ :
I like it the hard way code it as a pivot table save as csv 😅
2026-08-27 05:07:43
6
user587865391272
user587865391 :
or you can just go to classic mode
2026-08-28 22:11:24
0
notchugs
chugs :
Sort and format your pivot table
2026-08-28 21:22:42
0
elliedionne
Ellie Dionne🇹🇹 :
Appreciate this page
2026-08-30 13:36:20
0
irmineseignoret
Irmine Seignoret :
Nice
2026-08-28 06:06:49
1
sibusiso_83
Sibusiso :
Thank you
2026-08-27 20:32:40
1
misstea48
Mandrake :
Omg you just saved my life 😭😭😭 I’ve been working on a task with pivot tables and I needed exactly this I just didn’t know it was possible 🙏🙏🙏
2026-08-27 10:42:29
3
kenadams122
Ken Adams122 :
Why didn’t you just double click on the grand total and drill down to create a table with all the fields automatically?
2026-08-27 21:16:39
2
kmarie05019
Kmarie :
🥰🥰🥰
2026-08-28 02:00:44
0
kerrin55
KA :
😁😁😁
2026-08-30 14:00:25
0
To see more videos from user @theofficelabhq, please go to the Tikwm homepage.

Other Videos


About