Freeze panes and Split windows

  • Put the mouse-pointer over the top of the vertical/horizontal scrollbar to become a two-headed up and down arrow > click to the column/row need to be frozen

  • Do any of the following:

    • Go to View tab > Window group > click the arrow below Freeze Panes > click Freeze Panes

    • Go to View tab >  Window group > click Split