Home » Pivot Tables » How to Quickly Format a Pivot Table


In this tutorial, you’ll learn how to format a pivot table using the feature of “Autoformat.”

  1. Now that you have your new table created it’s time to style it and make it look professional and the fastest way to do this is to use the pivot table floating menu bar – you’ll see it somewhere on your spreadsheet area. Click on the first button, labeled “Format Report” or you can click on the pivot table drop down menu and select “Format Report.”
  2. Now the “auto format” pop up window appears showing you various report templates that you can use. Check them out, select one and click OK.
  3. You will see the table instantly formatted like the auto format template that you just selected.

Great Job! Now that you know how to create a simple pivot table and format it, I’ll show you how to create a pivot table Chart in just a couple of easy steps in the following tutorial.

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)

Leave a Reply