Download the New LearnVern Android App and enter Lucky Draw to win Free Certificate
If you are facing any issue in playing video please use Firefox browser.
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.
Have a friend to whom you would want to share this course?