To keep specific columns visible while scrolling in the Power Pivot window, you can freeze them.
- In the Power Pivot window, select the table that contains the columns you want to freeze.
- Select one or more columns to freeze.
- Select Design > 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 a column, it does not return to its original position.