Freeze columns or rows in Microsoft Excel

To keep an area of a worksheet visible while you scroll to another area of the worksheet in Microsoft Excel, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
For more tips like this, check out the working remotely playlist at www.youtube.com/FoetronAcademy . Also, if you need any further assistance then you can raise a support ticket and get it addressed.