If you have huge and also long workbooks or Excel spreadsheets, being able to see the column or row tags is exceptionally essential. Below is a quick means to ice up the tags in position for quick as well as very easy watching of your data.

Click View on the Ribbon and also select Freeze Panes.

Currently click Freeze Top Row. If you want to Freeze various other rows also just highlight them before choosing Freeze Panes.

That’s it! Currently as you can see by the example, you will be able to scroll throughout the file while keeping the column or rows in position.