Tech Secrets
News

How to Freeze Rows AND Columns in Excel

feature

Operating with a big group of information in Microsoft Excel can be catchy. It’s very aggravating when several columns or rows of information are similar, which means you must keep jumping back to the header to recall what you’re seeing. An excellent alternative to this is to freeze rows, columns, or both so they remain while you scroll through the remainder of your information shown in your display. Here’s how to do it.

In case you would like to freeze columns in the exact same time AND rows, follow the steps below.

Freeze Rows AND Columns at the Same Time

1 Select the first cell that you want to be unfrozen. That means that every cell above it and to the left of it will be frozen. In my example, I want to freeze the top row and the first column, so I click on cell B2. If I had selected B3, the top two rows and first column would be frozen. 

1

 

 

 

 

 

 

 

 

 

2 Go to the View tab, and click Freeze Panes.

3 Lines will appear on your spreadsheet separating out the frozen columns and rows from the scrollable part of your spreadsheet.

2

 

 

 

 

 

 

 

 

 

4 If you want to turn off your frozen rows and columns, go back to View>Freeze Panes and select Unfreeze Panes.

4

 

 

 

 

 

 

 

Below are some suggestions for effective freezing:

It’s not possible to freeze rows or columns in the middle of the sheet.
You can freeze a mixture of both, multiple columns, or multiple rows
You will need to use Freeze Panes to freeze columns or multiple rows. Choose the rows/columns by clicking on the header number/letter of the first row/column to freeze, and then click the last one while managing the Shift key in your keyboard.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Related posts

How to Install & use Linux Malware Detect (LMD) with ClamAV?

Farooq Ahmed

How to Set Custom Ringtones for WhatsApp Contacts

Farooq Ahmed

How Do I Export iPhone Contacts?

Farooq Ahmed