How to Freeze Panes Multiple Rows in Excel
OKEGUYS – In some cases, Excel freeze panes are needed, so that some columns or rows remain visible and do not move when scrolled.
This feature will certainly make it easier for users to read the required data.
But, how to implement this one feature? It’s so easy, really. Here’s the full tutorial.
How to Freeze Panes in Excel
You can use this feature directly through the menu Tab View – Freeze Panes – Freeze Top Row like this.
By doing so, the first line of your document will be locked or not moving when you scroll down.
Unfortunately most people need those immovable rows a few rows down.
To do this there is another way that you have to do.
How to Freeze Multiple Rows in Excel
Because I want the one that doesn’t move is Student’s name and Score then all I have to do is put the cursor on the first Student Name.
After that click menu View – Freeze Panes – Frees Panes like this.
By doing this, some of the lines won’t move even if you scroll down.
How to Freeze Excel Columns
As for the column all you have to do is place the cursor on the one you want, here I put the cursor on PPKN then choose menu View – Freeze Panes – Frees Panes like this.
As a result, the column name will not move. Place the cursor in the tutorial above, you just need to adjust it to your own document.
That’s it for this tutorial, good luck, GUYS!
Post a Comment for "How to Freeze Panes Multiple Rows in Excel"