Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!