All articles with 'power pivot' Tag

We all know pivot table functionality is a powerful & useful feature. But it comes with some quirks. For example, we cant insert a blank row or column inside pivot tables.

So today let me share a few ideas on how you can insert a blank column.

But first let’s try inserting a column

Imagine you are looking at a pivot table like above.

And you want to insert a column or row. Go ahead and try it.

If you listen carefully, you can hear my screams of joy. I have 2 very happy news to share with you.

1. I am speaking at Excelapalooza Excel conference, happening at Dallas (Texas) between September 21 to 24.
2. I will be conducting an Advanced Excel, Dashboards & Power Pivot masterclass at Houston (Texas) between September 15 to 18.