If you want to freeze a particular column of your spreadsheet, you do it in the same way as you froze the particular row.īut in this case, you need to highlight the column one to the RIGHT of the column you wish to freeze. How do I freeze a particular column of my spreadsheet? Oh, and you can freeze a column and row at the same time, as we’ll learn in a few moments. It will unfreeze anything you’ve previously frozen. Note: you don’t need to have anything highlighted to click this. If you decide that you want to freeze a column instead, or want to practise doing that, you need to click the Freeze Panes button then select the Unfreeze Panes option first. This is because you can only do one Freezing action at a time. Once you go to do something else with freezing, you will notice that the Freeze Panes option has changed to read Unfreeze Panes. Now you can scroll down as far as you like, and Rows 1 and 2 will always be visible at the top of the screen: If you scroll down the page, you will notice that Rows 3 and onwards start to disappear, and a horizontal black line appears at the point of freezing. Your spreadsheet is now frozen at the bottom of Row 2. Once you’ve highlighted the correct row, by clicking on the 3 in the left hand margin in this case (you can see that it’s become darker, with a line around it), click on the Freeze Panes button and select the Freeze Panes option. In this example, we’re highlighting Row 3 in order to freeze Rows 1 and 2. Not the row you want to freeze, the one below it. Here’s where it gets a tiny bit tricky (but you’ll save this post so you remember).Ĭlick on the row BELOW the point at which you want to freeze the spreadsheet. 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?
#WHY IS EXCEL FREEZING UP SO MUCH 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)
