How to freeze first two rows in excel 2010
![how to freeze first two rows in excel 2010 how to freeze first two rows in excel 2010](https://basicexceltutorial.com/wp-content/uploads/2019/07/070419_1336_HowtoFreeze4.png)
How do I freeze the top row or first column of my spreadsheet?
![how to freeze first two rows in excel 2010 how to freeze first two rows in excel 2010](https://basicexceltutorial.com/wp-content/uploads/2020/08/080520_1059_Howtofreeze2.jpg)
![how to freeze first two rows in excel 2010 how to freeze first two rows in excel 2010](https://michelpoudrier.com/images/other/98/how-freeze-row-1411E7.gif)
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?
HOW TO FREEZE FIRST TWO ROWS IN EXCEL 2010 HOW TO
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.