Once again, moving ahead on Microsoft Excel series, We will learn another trick here. In previous posts, we have learnt how to fix one or more rows at same time and how to fix one or more columns at same time so that we can feel comfort with our data.
Now, it is time to fix row and columns simultaneously
Lets have a loot at the previous file we have created for demonstration. Vehicle Daily Status sheet.
We want here to fix the column A to E and rows 1,2 and 3. So that wherever we are on sheet, we know what field it is?
Lets move to process without loosing any time.
- Click the Intersection point (cell) of rows and column you want to fix.
- Click on View Tab.
- Click on Freeze Panes.
- Click on Freeze Panes.