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. 🙂

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

2 Responses 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

Leave a Reply to MF Cancel reply

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

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