Marks PC Solution

When you are preparing a large statement or table in Excel, the column headings at the top usually disappear when you scroll down. And this is really troublesome when you need to input data under several headings. Couple of months ago, I faced the same problem. And just 2 days ago, one of my relatives questioned me how to create static/ fixed column header in Microsoft Excel.  Then I explored the topic and found the solution from Excel help and Microsoft Support Page. So, in this post, you are getting another important excel tutorial - How to Lock/ Fix/ Freeze Rows or Columns in excel while scrolling throughout the worksheet. Lock/ Fix/ Freeze Rows or Columns In Excel, the term is known as Freeze Panes . With this option, you can freeze a row or column that you want visible even when scrolling down or right.  Suppose, you preparing a salary sheet that contains hundreds of rows. And you can view only 25/30 rows in a view. When you scroll down, the column h...