How to freeze rows and colums headings on Microsoft Excel 2016?

From time to time i receive or develop Excel spreadsheets which contains huge data tables. One of the challenges in this case is how to ensure that the first rows and columns stay visible when you scroll through the table, so it’s easier to correlate the data itself with the row/column heading.

In order to overcome this challenge, i use the Freeze Panes command. Here’s how it goes:

  • Open the relevant Excel worksheet.
  • From the Excel 2016 ribbon, hit View.
  • Hit Freeze Panes.
  • From this menu you can lock your first column or top row pretty easily

In same cases, however, you might want to lock more than one row or column. This is best shown by using the example below.

  • If i highlight cell C3, and hit Freeze Panes. Rows 1and2 and will be locked, as well as columns a and b.

Screen Shot 2015-08-05 at 7.58.11 AM


  • You can always unlock the frozen columns and rows by selecting Unfreeze Panes.

Leave a Comment: