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:
In same cases, however, you might want to lock more than one row or column. This is best shown by using the example below.