4 Steps and Shortcut: How to Freeze Cells in Excel

This Article shows you how to freeze particular rows and columns in your Microsoft Excel worksheet. Freezing rows or columns guarantees that specific cells stay noticeable as you scroll through the information. In the event that you need to handily alter two pieces of the spreadsheet immediately, Dividing your sheets will make the work a lot simpler.

Freezing the First Column or Top Row

View

Click the View tab. It’s available top menu of Excel. Frozen cells are rows or columns that stay sticky while you scroll through a worksheet. If you have a lot of information in the spreadsheet and if you want to see the top header while scrolling. It can help a lot.

All rows or columns can be frozen. Not possible to freeze individual cells.

Freeze Pane

Click on Freeze Panes button. This Option available under the “Window” section of the toolbar. There are freezing options that will appear.

Freeze Pane Single

Click on Freeze Top Row or Freeze First Column. If you want to keep the top row of cells sticky when you scroll down to see the rest of the row data, select Freeze Top Row. To Make the first column sticky as you scroll horizontally, then select Freeze First Column.

Unfreeze Panes

If you want to remove the sticky rows or columns, click on the Freeze Panes menu again and then select Unfreeze Panes.

Freezing Multiple Columns or Rows

Row Freeze

Select the row or column after which you want to freeze. If your data want to be sticky that takes up more than one row or column, click the column letter or row number after which you want to freeze. For example:

  • If you want to sticky rows 1, 2, 3, 4, and 5, Then click row 5 to select it.
  • If you want columns A and B to be sticky when you scroll horizontally, click column C to select it.
  • Frozen cells must connect to the top or left edge of the spreadsheet. We Cannot freeze rows or columns in the center of the sheet.
View

Click on the View menu.

Freeze Pane

Click on Freeze Panes button. This Option available under the “Window” section of the toolbar. There are freezing options that will appear.

Freeze Pane Multiple

Click on Freeze Panes from the menu.  The very first menu that freezes the columns or rows before the one you selected.

Unfreeze Panes

If you want to remove the sticky rows or columns, click on the Freeze Panes menu again and then select Unfreeze Panes.

Painting Hobbies

8 Steps: How to learn a new skill?

Everyone wants to be successful in life. Every person dreams big and works hard to fulfill them. But most people’s dreams remain only dreams. Because they don’t have skills to enrich the quality of life, or they don’t embrace their

Read More »
dropdown list excel

4 Steps: Add Dropdown list in excel

Adding a dropdown list in excel, will increase the look and feel of your spreadsheet. And it forces the users to select the data from preset values and restricts the invalid data being entered. Let’s look at how to add

Read More »