Quick Trick to Add or Move Pivot Table Fields

We're still recovering from Tuesday's Spreadsheet Day celebrations, so we'll keep it simple today. Here's a quick trick to add or move pivot table fields, just by typing. Watch the really short video, and there are written instructions below, if you prefer those.

Watch the Video

Here is the short video that shows the quick trick to add or move pivot table fields, just by typing.

Just make sure that you type the field name correctly! If you make a typo, you'll change the label for the existing pivot field, instead of adding the new pivot field.

Add or Move Pivot Table Fields

If a pivot field is not in the layout on the worksheet, you can type its name over an existing label, to add it to the layout.

Here are the steps to add or move pivot table fields on the worksheet:

  • First, change the pivot table to Outline layout or Tabular layout. This trick will not work in Compact layout.
  • Next, click on a cell that contains a pivot field name – a cell where you want a different field to appear
  • Type the name of the pivot field that you want to add or move to that location
  • Press Enter,  to complete the pivot table  layout change.


The pivot table layout changes, putting the field that you typed into the active cell. The existing fields shift down, and the added field takes its new position.


More Tips for Moving Labels

The video above shows how to move pivot fields, and you can use a similar technique to move the pivot items for any pivot field.

The next video shows how to move the pivot items, and there are written instructions on the Move Pivot Table Labels page.

Get the Sample File

Instead of building your own file for testing, download the Move Pivot Labels sample file from my Contextures website. The zipped file is in xlsx format, and does not contain any macros.



Quick Trick to Move or Add Pivot Table Fields http://blog.contextures.com/


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.