Freeze columns in a Data Model in Power Pivot

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.

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.