For this Excel tip, I will show you how to freeze the heading in your

spreadsheet.This is useful when working with large Excel worksheets, as when your scroll the headings will stay at the top.

More links on about Office/Excel

• Freeze panes to lock rows and columns - Microsoft Support

Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes. Unfreeze ...

• Freeze or Lock Specific Rows and Columns when Scrolling in ...

Steps to Lock Rows/Columns in Excel. Go to the View tab and click the Freeze Panes button. From the drop down menu select if you want the header row ...

• How to keep column header viewing when scrolling in Excel?

Enable the worksheet you need to keep column header viewing, and click View · Freeze Panes ; 1. If you want to unfreeze the column headers, just click View ...

• 6 Ways to Freeze Rows and Columns in Microsoft Excel

The Freeze Panes feature will allow you to pin the top row and first column so when you scroll around the sheet they always remain in view. This makes it easy ...

• Excel Freeze Panes: Use it to Lock Row/Column Headers

When working with large data sets, if you scroll down or to the right of the worksheet you would lose track of the row/column headings. In such situations, you ...

• Excel: Freezing Panes and View Options - GCFGlobal

Hint: This should split the worksheet between rows 16 and 17 and columns F and G. Use the horizontal scroll bar in the bottom-right of the window to move the ...