in

Check How to use freeze panes feature in Microsoft Excel to keep an area on spreadsheet always visible

How to use freeze panes feature in Microsoft Excel to keep an area on spreadsheet always visible

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

2.

Now, click on on View choice from the titlebar

3.

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

5.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Twitterati React To Hardik Pandya And Natasa Stankovic’s Pregnancy News With Funny Memes

sonyliv

Latest SonyLIV Premium Trick – Get SonyLiv 1 Year Subscription For Free