Excel: Freezing View Panes

When working with a large Excel worksheet that has row and column headings, it’s important to have your title headings visible so you can keep track of where you are when scrolling to a different location in the worksheet.  The way to make the titles visible is to freeze the panes.

To freeze the panes, move the cell pointer to the cell below the row that you want to remain visible as you scroll and to the right of the column that you want to remain visible as you scroll.  Select View / Window / Freeze Panes.  In the example below, cell B5 was the cell chosen when freezing panes.


The next image shows the panes frozen in row 4 when the user is currently doing work on row 31 and beyond.

If you need to unfreeze panes, click View / Window / Unfreeze Panes.

Looking For More?


Silicon Valley Accounting Solutions produces the Solution of the Week in order to share tips and shortcuts that promote process efficiency and highlight software features that may not be in your current toolbox. Please let us know if you have questions on how to accomplish a particular task or if you simply have a comment to share.

Even if you find that you know most of what you see here, it only takes one “Aha” to make regular visits worthwhile. To avoid missing any solutions, you may subscribe and have a new one delivered to your inbox each week.

Contact Us

We want to help you grow
your business, call us
at: (408) 260-5250 or
find out more here.


When you need:
  • Clear processes for cash controls
  • Analysis of results
  • Customized reporting


When you need:
  • Timely and accurate bookkeeping
  • Reconciliations and monthly closes
  • Familiarity with popular accounting software
Web Analytics