Freezing Panes
You can freeze columns, rows, or both so that column letters and row numbers remain in view as you scroll instead of scrolling off the screen with the rest of the worksheet. This is particularly helpful with larger worksheets.
Click the View tab.
Click the Freeze Panes button.
Select Freeze Panes from the menu to free both columns ...
Get Easy Office 2013 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.