Suppose, you have an Excel sheet that contains a lot of data. To read the data at the bottom of the sheet, if you scroll the sheet upward, the headings that lie in the top row will be invisible. It will make no sense of reading data without headings. Same is the case with column if you scroll the sheet rightwards the columns to the left will be invisible. The best way to retain rows and columns is to freeze them. Frozen rows and column will appear, no matter wherever you are on the sheet. So, let us learn How to Freeze Rows and Columns in MS Excel 2016?
Steps to Freeze Rows and Columns in MS Excel 2016:
Step 1: Open an Excel sheet on your screen, of which you want to freeze rows and columns. In the image below you can see that I have an Excel sheet of which I want to freeze top row and first two columns.
Freeze Panes: It combinely freezes rows and columns that appear above and to the left of the selected cell respectively.
Freeze Top Row: This freezes top row of the Excel sheet.
Freeze First Columns: Freezes the first column of the Excel Sheet.
Step 4: Now, if you want to freeze rows and columns simultaneously. You have to select a cell in the Excel sheet which exactly lies below the rows and next to the columns you want to freeze. Then under Freeze Panes, drop-down options click on Freeze Panes. It will freeze all the row above the selected cell and all the columns to the left of the selected cell.
Step 5: If you have selected the first cell of the Excel sheet then there does lie any rows above it and any columns beside its left side to get frozen. In this case, the Excel sheet is frozen at the centre.
Thank You. Keep Reading.