To keep an area of the Data Model visible while you scroll to another area in the Power Pivot window, you can lock specific columns in one area by freezing them.

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

  2. Select one or more columns to freeze.

  3. Click Design > Columns > 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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!