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.
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:
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?!
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. 🙂
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.
Glad you like it.