Home >> Computer >> Fix Rows & Columns Simultaneously in Microsoft Excel

Fix Rows & Columns Simultaneously in Microsoft Excel


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.

  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. 
You are done. Your output must be similar to this.
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.

About John Bhatt

Aka, Prithvi Raj Bhatt, A Proud Nepali, Blogger, Software Developer, ASP.NET, Web Designer & Developer, Faculty and a Troubleshooter blog @PRsBlog

Check Also


WhatsApp Video Calling is now on Android

Few months ago, we have shared a rumor that displayed some proof of Video Calling …

Leave a Reply

Your email address will not be published. Required fields are marked *