From the course: Nano Tips for Using Excel with Kat Norton
Rearrange PivotTable fields with Excel
From the course: Nano Tips for Using Excel with Kat Norton
Rearrange PivotTable fields with Excel
- Have you ever wanted to rearrange your pivot table? This situation has gotten me tripped up a bunch of times until I learned this trick. So here we can just right click on any of the pivot table items and then select More Sort Options, and here we are going to want to make sure that we are on manual sort mode. From here, we can hover over the field that we want to move and when our mouse turns into the little plus sign with the arrows at the end, that is our sign that we can click and drag to move our fields around and get them in the exact format that we like.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
LEFT and FIND with Excel53s
-
Sum across multiple sheets with Excel21s
-
Scan data from a paper document on mobile with Excel22s
-
Remove PivotTable subtotals with Excel24s
-
Rearrange PivotTable fields with Excel32s
-
Create a custom number format with Excel47s
-
COUNTIF wild card trick with Excel54s
-
Assign into buckets with XLOOPUP with Excel57s
-
Absolute referencing with Excel1m 26s
-