This is where you need to be able to select the point at which the spreadsheet freezes. Say, for example, you’ve got a double row of headers, or you’ve inserted a graph at the top of your spreadsheet that you want to be able to see as you scroll down. If you, like me, want to freeze both a row and a column, scan down to the section titled Can I freeze a row and a column at the same time? How do I freeze a particular row of my spreadsheet? Want to freeze the spreadsheet so it shows more than just the first row or column? Read the next three sections.īUT (2): this will only allow you to freeze the row or the column. Hooray!īUT: this will only freeze one of those two areas. Freeze the top row, scroll down thousands of rows, and that top row will still be on show. This is because the first row and column on a given spreadsheet are likely to be the ones where you’ve inserted your headers.Ĭlick on one of these buttons and you’ll freeze just that row or column. 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?
#Freeze first two rows in excel 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.
0 kommentar(er)
