Freezing Panes in Excel

In Excel, it may be beneficial to have a row or column static while all others scroll. To do this, simply select the row or column to be frozen and then click on 'View' along the top. Go to 'Freeze Panes' and choose which option is appropriate.

For more information, view Microsoft's guide for PC and for Mac.