How To Freeze Rows And Column In Excel 2016


Working with a big spreadsheet you will want to be able to see the header, usually top row and first column although you scroll the bar on the side or bottom section. This is what called freeze rows and columns.
In Excel 2016 we can freeze first row, first column, row and column and we can unfreeze all of them to make the spreadsheet back to the original position.

Freeze First Row or Top Row

Click View-Free Top Row and your row number 1 will stay visible when you slide to the bottom. To freeze the first third rows, click on any column in the fourth row, click View-Freeze-Freeze Panes.
freeze first row

Freeze First Column

Click View-Freeze First Column make column A stay visible when you slide left and right. To freeze the first third column click the whole fourth column by clicking column's header, for example, column header E. Click-View-Freeze Panes.
freeze first column

Freeze Certain Rows and Column

Click on the cell just under the row and next to columns you want to freeze. Click View-Freeze panes will make the rows and columns above and besides current active cursor keep visible or not scrollable.
freeze rows and column

Unfreeze Panes

Unfreeze panes will make all rows and columns in current sheet scrollable, or back to original position. 
unfreeze row and column

In the sample above I am using Excel 2016 but excel in another version will be the same except the location of Freeze panes slightly different.
How To Freeze Rows And Column In Excel 2016 Reviewed by Yunar Winardi on August 16, 2019 Rating: 5

No comments:

Powered by Blogger.