Hidden Pivot Table Calculated Field Command

A few months back, I discovered a hidden Pivot Table command on the Home tab in Excel.

If you put your cursor in the Values/Data area of a Pivot Table, you can Go to the Home Tab and select Insert->Insert Calculated Field.

.

If you put your cursor in the Row or Column area of a Pivot Table, you can Go to the Home Tab and select Insert->Insert Calculated Item.

.

.

Ok…I know you’re thinking that this is no big deal. I felt the same way when I first noticed it. I thought it was simply interesting that it was there – nothing more. But I have to say that I use it all the time now that I know it’s there.

.

I think it’s because even if I’m working with a Pivot Table, I’m usually on the Home tab. It’s easier for me go to Insert ->Insert Calculated Field rather the alternative; switch to the PivotTable Tools contextual tab, click on Options, and find the calculated field/item options in the Calculations group.

.

For you hot-key fans out there, I know there is a hot key that I could use.

I hate taking my hand off the mouse; I avoid it wherever I can. Other than Ctrl+C and Ctrl+V, I don’t do hot keys. Unless I’m stuck with a Darth Vader Mouse.

3 thoughts on “Hidden Pivot Table Calculated Field Command

  1. coupon

    A fascinating discussion is worth comment. I think that you need to publish more about this issue,
    it might not be a taboo subject but generally
    people do not speak about such issues. To the next!
    All the best!!

Leave a Reply

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