Home Computer Fix Rows & Columns Simultaneously in Microsoft Excel

Fix Rows & Columns Simultaneously in Microsoft Excel

by John Bhatt
0 comment 579 views
Hi,

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.

Fix Rows & Columns Simultaneously in Microsoft Excel 4

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.

  1. Click the Intersection point (cell) of rows and column you want to fix. 
  2. Click on View Tab.
  3. Click on Freeze Panes.
  4. Click on Freeze Panes. 
    Fix Rows & Columns Simultaneously in Microsoft Excel 5
You are done. Your output must be similar to this.
Fix Rows & Columns Simultaneously in Microsoft Excel 6
Have a look at Column Names and Row numbers I have highlighted in above snapshot.

If you have any questions or suggestions, drop a comment here. Do not forget to share if you found this helpful.
0 comment

Leave a Reply

Do NOT follow this link or you will be banned from the site!