A serious difficulty normally confronted by individuals whereas working with plenty of spreadsheet knowledge is remembering which row and column represents what knowledge. Now, remembering one thing in a small spreadsheet isn’t a problem. Nonetheless, we’re speaking about over 10 rows and columns at a time the place when you begin scrolling by knowledge, the header row or column disappears and makes it exhausting to determine which row or column represents what worth.
This can’t solely result in errors, however scrolling up and down repeatedly also can turn into fairly irritating. Nonetheless, this difficulty can simply be mounted by merely freezing the rows and columns to at all times present on the highest all through the spreadsheet and right here’s the best way to do it.
Easy methods to freeze a rows/columns in Microsoft Excel
1.
Open any spreadsheet in Excel
Open any spreadsheet in Excel
2.
Now, click on on View choice from the titlebar
Now, click on on View choice from the titlebar
3.
Choose View choice and click on on Freeze Panes button
Choose View choice and click on on Freeze Panes button
4.
From the drop down menu select Freeze First Column or Freeze First Row as per your selected
From the drop down menu select Freeze First Column or Freeze First Row as per your selected
5.
You can even freeze the primary two rows or columns by choosing all the third row/column and clicking on Freeze Panes choice.
You can even freeze the primary two rows or columns by choosing all the third row/column and clicking on Freeze Panes choice.
Easy methods to unfreeze rows/columns in Microsoft Excel
To unfreeze panes, head to View ->View choice -> Unfreeze panes.