When you're working with a lot of spreadsheet data on your laptop, keeping track of everything can be difficult.

Freezing rows and columns in Excel makes navigating your spreadsheet much easier.

This how-to works with Microsoft Excel 2016 as well as later versions. However, the this method also works with Google Sheets, OpenOffice and LibreOffice.

1. Select the row right below the row or rows you want to freeze. If you want to freeze columns, select the cell immediately to the right of the column you want to freeze. In this example, we want to freeze rows 1 to 5, so we've selected row 6.

2. Go to the View tab. This is located at the very top, inbetween "Review" and "Add-ins."

3. Select the Freeze Panes option and click "Freeze Panes." This selection can be found in the same place where "New Window" and "Arrange All" are located.

If you want to unfreeze the rows, go back to the Freeze Panes command and choose "Unfreeze Panes".

You can also choose "Freeze Top Row" to freeze the visible top row (and any above it) or "Freeze First Column" to keep the leftmost column visible when scrolling horizontally.