Hide and Unhide Columns Dialog Box
The Hide and Unhide Columns dialog box provides a convenient way to hide and unhide columns in the PowerPivot window. To access this dialog box, on the Design tab, in the Columns group, click Hide and Unhide.
You might hide columns if you want to work with a subset of the data in the PowerPivot window, but you might need to unhide them as you shift the focus of your analysis. For example, suppose your workbook contains many tables with hidden columns. Rather than going through each table individually to unhide columns, you can click Select all, and then check the box in the In PowerPivot and In Pivot columns to make all columns visible everywhere. For more information, see Hide or Freeze Columns.
Note
This feature is not intended to be used for data security--only to simplify and shorten the list of columns in the PivotTable field list and PowerPivot window.
Column
Select a column that you want to hide or unhide.Click Select All, in the first row of the column, to apply your selections to all columns in the list.
Tip To hide an individual column, you can also right-click the column directly in the PowerPivot window, and specify one of the following options: From PowerPivot and PivotTable, From PivotTable, or From PowerPivot.
In PowerPivot
Check the box if you want the column to be visible as you are working with tables and columns in the PowerPivot window.In PivotTable
Check the box if you want the column to be visible in any PivotTables in the workbook.