Build Your Resume To Get Connected for Jobs and Internships - Resume Builder
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.
Learn Making Professional-Quality Documents With MS Wor...
Enroll For FreeImpress Everyone With Fluent Communication Skills With...
Enroll For FreeEnhance your customer engagement skills with our Custom...
Enroll For FreeImprove Your Presentation and Team Management With Soft...
Enroll For FreeBecome A Master In Sales With Career In Sales Taught In...
Enroll For FreeHave a friend to whom you would want to share this course?