When you open up the Excel document you want to start editing, click on the row or column you want to freeze.

The way this works is if you highlight a row or column, all others rows above or columns on the side will be frozen. For example, if you choose row 5, the 4 previous rows will also be frozen on your screen, allowing you to get a bulk of information saved at once.

When you have chosen the rows or columns you want to freeze, there will be a handful of options at the top that you can click on.

Each has their own set of tools that can be used to format a sheet in different ways and can really open up all the potential features an Excel user has at their disposal.

The option you will want to click on is ‘View’ near the far right of the screen.

Once the ‘View’ menu has been selected, look to the far right at the top of the screen to see a ‘Freeze panes’ option. Click on the small arrow beside it to open a drop-down menu.

You will be offered three options, two of which are to only freeze the top row or first column.

Instead, click the first option simply called ‘Freeze Panes’ to tell Excel to freeze only the rows that had been selected previously.

Your rows of choice will now be frozen and be easy to see as you navigate the page.

If you ever feel the rows are a bit too cumbersome or you don’t need them anymore, simply go on the same ‘Freeze Panes’ drop-down menu and click ‘Unfreeze Panes’.