How to freeze rows and columns
Now in this video we will see that how we can freeze rows and columns in MS
Excel.
Suppose we have thousands of data in our Excel sheet and we want to scroll
down and see our particular record but if we do that we can't see the main
row which was denoting the headings. So in that case to freeze the main row
we can use freeze top row option from our VIEW tab.
Now suppose if we do not want to use this option, than we can unfreeze this
option from same place.
Similarly we can freeze our first column, by using freeze first column from
'Freeze panes' column in VIEW tab.
So this is how we can freeze any row and column in our MS Excel sheet.
Now in any case we want our first row and first two columns to freeze all
together, than for that we will select the adjacent cell of both column and
main row and use freeze pane option from VIEW tab.
This is how we can do our required work. This does not effect in print, it
is just for easy visibility to the user.
Share a personalized message with your friends.