In a shock move, something that Microsoft Office gives you as a short cut is actually useful! If you click on that Freeze Panes button and select Freeze Top Row or Freeze First Column, it will automatically freeze that row or column for you. How do I freeze the top row or first column of my spreadsheet? Click on Freeze Panes and you’ll be given three options: Freeze Panes (note, this toggles between Freeze and Unfreeze, as we’ll discover later) Freeze Top Row and Freeze First Column. To find the Freeze Panes button, you need to be in the View Tab, then the long Window area. Where is the Freeze Panes button in Excel 2007 and Excel 2010? So, if you have a row of dates as a heading along the top or a column of customer names down the side, and your document becomes longer or wider than the screen on which you are viewing it, you can keep those columns and rows visible, instead of having to scroll up and down and backwards and forwards to find your headings.įor example, in the Gantt chart that records my work projects, I need to be able to see the dates and client names all the time, however large my document becomes: When you freeze a row or column in an Excel spreadsheet, you make sure that it’s on display however much you scroll down or across your document. So I created this post to help myself – and you! What is “freezing” rows and columns?

It was time to create a new Gantt chart for myself to keep my various projects under control, and yet again I had forgotten how to freeze the columns and rows in the way I like.

Freeze multiple panes in excel 2003