excel tip

Freeze Headers for Scrolling

The breaking point while working on a spreadsheet with a massive data set, is scrolling in any direction and trying to find that specific row or column you want. Users tired of this situation found a simple excel trick to deal with it. The trick is freezing a header row or column so that when you scroll, it doesn’t move. And below is how you do it:

  • Go to the View tab and look for Freeze Panes
  • You will find options like:
  • If you want to do both select Freeze Panes
  • If you changed your mind, select Unfreeze Pane – to reverse the freezing