Insert or move a field into Pivot table without drag and drop

If you do Pivot Table, the following won’t be a stranger to you as you must do a lot drag and drop to pivot.

Excel Tips - Move field by direct input.gif

But did you know that you may insert a field name and / or  swap the position of field name in the layout of a Pivot table by directly input?  See below:  

Excel Tips - Move field by direct input1.gif

Tip: Try the same for swapping position of items.

Nevertheless, be extremely careful of typing.  Make sure you type the field name 100% correct, including invisible space(s) if any.  Otherwise, Excel considers you are going to rename the field name instead.  See demonstration below?!

Excel Tips - Move field by direct input2.gif

By the way, we still need to use mouse drag and drop at the very beginning to create the first Report/Row/Column labels for this trick to work… Unless you are a keyboard guru and know how to do that without mouse,  or consider reading my post about F6 for hints in doing that. 🙂

This entry was posted in Excel Tips and tagged . Bookmark the permalink.

One Response to Insert or move a field into Pivot table without drag and drop

  1. Doug Glancy says:

    Hi there. I just stumbled onto these tricks last week. I was going to do a blog post, but this one is very nice, as is the one on Contextures.

    Like

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s