HOW TO FREEZE THE FIRST COLUMN & ROW ON A SPREADSHEET

In MS Excel, there is this thing called FREEZE PANE. You can use this mainly for freezing a row or a column for easier scrolling through the sheet. What if I wanted to freeze the top row and the leftmost column? How do I do that?

1. Click on B2. This is the cell to which scrolling from top and from left will stop.
2. Go to View, Select Normal
3. Click on Freeze Pane

From this moment, when you scroll down, row 1 will not be out of sight, and when you scroll right, the first column will still be visible.
You can add additions to this like 2 rows and 1 column only, or 3 columns and 1 row, etc, whatever you prefer. Make sure to highlight the cell that will separate the stationary versus the moving cells.
Easy? Yup.


...to end: count then share your blessings to others...