How to Freeze or Unfreeze Rows and Columns in Excel

A large amount of data can fit on an Excel sheet. It can become quite cumbersome with hundreds upon thousands of rows and columns. Row and column freezing is one minor feature that makes managing all of that data simpler. This indicates that particular rows or columns will always be shown when you browse the spreadsheet. In this article we will try to tech you how to Freeze or Unfreeze Rows and Columns in Excel.

It might be challenging to stay organised while dealing with a lot of spreadsheet data on your laptop. When working with a small subset of data, it is one thing to compare one or two rows of data, but when twelve rows are involved, things become cumbersome. Even so, we haven’t even begun to discuss columns. There is just one thing you can do when your spreadsheets get too big: freeze the rows and columns.

How to Freeze/Unfreeze Rows and Columns in Excel

How to freeze the first column:

  • Choose View > Freeze Window.
  • Select Freeze First Column.

How to freeze the first two columns:

  • Select the third column.
  • Select View > Freeze Panes > Freeze Panes.

How to freeze columns and rows:

  • Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
  • Select View > Freeze Panes > Freeze Panes.

How to unfreeze rows or columns:

  • On the View tab > Window > Unfreeze Panes.

Final Words

We hope our article on Freeze/Unfreeze Rows and Columns in MS Excel will help you and resolve all your problems. When working on a large spreadsheet, it can be helpful to “freeze” specific rows or columns so they stay on screen while you scroll through the rest of the spreadsheet.

I hope you understand this article, How to Freeze or Unfreeze Rows and Columns in Excel.

James Hogan
James Hogan
James Hogan is a notable content writer recognized for his contributions to Bollyinside, where he excels in crafting informative comparison-based articles on topics like laptops, phones, and software. When he's not writing, James enjoys immersing himself in football matches and exploring the digital realm. His curiosity about the ever-evolving tech landscape drives his continuous quest for knowledge, ensuring his content remains fresh and relevant.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Related Articles

Hubspot Service Hub review 2024: a comprehensive platform

When it comes to customer support operations, HubSpot Service Hub is an all-encompassing customer service platform that is meant to...
Read more
When players on Windows 11 or 10 try to log in to Steam, they may get the error code E87....
Users of Windows 11 or 10 may find it frustrating to deal with the error number 147-0 in Microsoft Office....
The Microsoft Store is an important part of the Windows operating system because it gives users a single place to...
It can be hard to find the right balance between usefulness, durability, and cost when it comes to kitchen storage....
Both AirDroid and Vysor are well-known tools that help Android users control their devices and mirror them. One of the...