PowerPivot hide columns and unhide




In this step by step PowerPivot Tutorial I will show you how to using PowerPivot hide columns and unhide them. For the purpose of this tutorial I will use PowerPivot in Excel 2013.

Other Versions of Excel:

  • PowePivot Excel 2013 (v3)
    • This blog post has been written using PowerPivot in Excel 2013
  • PowerPivot Excel 2010 (v2) - SQL Server 2012
    • The step we will use should be similar in Excel 2010 with PowerPivot SQL Server 2012 (v2)
  • PowerPivot Excel 2010 (v1) - SQL Server 2008 R2
    • The step we will use should be similar in Excel 2010 with PowerPivot SQL Server 2008 R2 (v1)

Who is it for?

  • People who would like to improve user experience with PowerPivot model and hide some columns

See below PivotTable taht uses PowerPivot model and notice that we have quite a few IDs (Primary Keys and Foreign Keys). In our case those IDs are meaningless and users should not use them therefore in we will hide the columns from users.

PowerPivot unwanted fields

 

PowerPivot hide column

Are you a paid member?

Log in or Buy Membership
Unlimited use access passes from $9
and long term discounts up to 87%





Did you find this page useful? +3  |  -0
(3 Votes)

Easy to find via google and nicely packaged the info to answer the Q I had. Also liked the windows explorer like navigation on the left. Excellent site - favourited thx