Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Freeze Columns

SQL Server 2012

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.

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

    A frozen column moves to the front of the table. Additional columns that you freeze are positioned next to the first column that you froze. If you later unfreeze the column, it will not be moved back to its original location.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.