Share via


Hide or Freeze Columns

If there are columns that you don't want to display in your table, you can temporarily hide them. Hiding a column gives you more room on the screen to add new columns or to work with only relevant columns of data. You can hide and unhide columns from the ribbon in the PowerPivot window, and from the right-click menu available from each column header. To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can lock specific columns in one area by freezing them.

Important

The ability to hide columns is not intended to be used for data security, only to simplify and shorten the list of columns visible in the PivotTable field list and PowerPivot window.

When you hide a column, you have the option to hide the column just while you are working in the PowerPivot window, or to also hide the columns in any associated PivotTables. If you hide all columns, the entire table appears blank in the PowerPivot window. When you hide all columns from a table that is used in a PivotTable, you might receive a message that the data must be refreshed.

Note

In Windows Vista and Windows 7, features in the PowerPivot window are available on a ribbon, which is discussed in this topic. In Windows XP, features are available from a set of menus. If you are using Windows XP and want to see how the menu commands relate to the ribbon commands, see The PowerPivot UI in Windows XP.

To hide an individual column

  1. In the PowerPivot window, select the table that contains the column that you want to hide.

  2. Right-click the column, click Hide Columns, and then click From PowerPivotand PivotTable, From PivotTable, or From PowerPivot.

To hide multiple columns

  1. In the PowerPivot window, select the table that contains the columns that you want to hide.

  2. On the Design tab, in the Columns group, click Hide and Unhide.

  3. In the Hide and Unhide Columns dialog box, locate each column that you want to hide, and then deselect one or both of In PowerPivot and In PivotTable.

  4. Click OK.

To freeze columns

  1. In the PowerPivot window, select the table that contains the columns that you want to freeze.

  2. Select one or more columns to freeze.

  3. On the Home tab, in the View group, click Freeze.

See Also

Other Resources

Working with Tables and Columns