Share via

Excel-freezing column while scrolling up/down?

Anonymous
2017-04-03T02:05:35+00:00

I want to be able to freeze the first column while scrolling UP/DOWN through my spreadsheet, but MS Excel 2016 seems to only want to freeze the first column if you scroll LEFT/RIGHT.  Can this be done?  I have spent some time on it and can't seem to make it work.  Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-04-03T05:06:33+00:00

    Hi Dan,

    Freezing a column is only available for horizontal scrolling. You might want to try splitting panes instead. Check this link to see how.

    Visit this link for more information about freezing a pane.

    Let us know if there's anything else we can assist you with.

    1 person found this answer helpful.
    0 comments