How to freeze top row and first column in excel

Freezing certain rows and columns can help you reference key values while working on other parts of your Excel spreadsheet. Let’s look at how to do that.

This feature works best for title rows or columns containing identifying information of their respective fields.

That way, you can scroll down the worksheet and still keep track of what every value represents. This is an essential function you should master alongside the other Excel basics to be able to properly navigate the interface.

How to freeze multiple columns in excel

The Steps to Freeze Multiple Rows and Columns in Excel

1. Open an Excel workbook with some data already in it.

1. To freeze multiple rows or columns, you don’t select them all, but the last one.

   For example, we selected the third row here.

1. Now select the View tab from the top to get its associated options. You will notice a Freeze Panes icon in this bar.

1. Click on this Freeze Panes option to drop down a menu with a bunch of different options.

1. The Top Row and the First Column options do not need anything selected to work; they simply freeze the first row or the first
   how to freeze middle column in excel
   how to freeze two column in excel