Moving Columns Or Rows Of A PivotTable In #Excel

Here is how you can re-arrange columns or rows in a PivotTable to get the look you want:

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Here are links to other posts about PivotTables:

PivotTable From Multiple Ranges

Counting Items Using A PivotTable

Analyzing Dates With PivotTables

By default, Excel will list the rows and columns of a PivotTable in alphabetical order, but that may not be in the order that you want. To change the order, just right-click on row or column heading and go down to “Move”. Here you will have the option of moving the row one place up or down, or moving it to the beginning or end of the list. It works the same for columns:

pm1

You will not be able to move it below or to the right of the Grand Total, those always need to be at the end.

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , ,

No comments yet.

Leave a Reply