Hide and Unhide Columns Dialog Box

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

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 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.

See Also

Concepts

Take a Tour of the PowerPivot UI