How to Create a Scrollable Grid View With Fixed Headers
- 1). Open the spreadsheet to edit in Microsoft Excel.
- 2). Drag the cursor over the rows that you want to freeze as a fixed header.
- 3). Click the “View” tab on the top navigation bar.
- 4). Click the arrow below the “Freeze Panes” option, and then click “Freeze Pane” from the drop-down list. The selected rows are frozen as the fixed header, and the remaining rows in the grid are scrollable.
