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. So I created this post to help myself – and you! What is “freezing” rows and columns? 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, 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. For 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: Where is the Freeze Panes button in Excel 2007 and Excel 2010? To find the Freeze Panes button, you need to be in the View Tab, then the long Window area. 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. How do I freeze the top row or first column of my spreadsheet? 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. This is because the first row and column on a given spreadsheet are likely to be the ones where you’ve inserted your headers. ![]() Click on one of these buttons and you’ll freeze just that row or column. Freeze the top row, scroll down thousands of rows, and that top row will still be on show. BUT: this will only freeze one of those two areas. Last month I talked about how you can freeze rows or columns in an Excel workbook so that your headings stay visible on screen. This month I’ll show you how you can choose rows or columns to appear on every page when you print. Excel Forum: More tutorials: https://www.teachexcel.com. Want to freeze the spreadsheet so it shows more than just the first row or column? Read the next three sections. BUT (2): this will only allow you to freeze the row or the column. 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? 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. This is where you need to be able to select the point at which the spreadsheet freezes. Movie downloading sites for mac. Here’s where it gets a tiny bit tricky (but you’ll save this post so you remember). Click on the row BELOW the point at which you want to freeze the spreadsheet. Not the row you want to freeze, the one below it. In this example, we’re highlighting Row 3 in order to freeze Rows 1 and 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. Your spreadsheet is now frozen at the bottom of Row 2. 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. 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: How do I unfreeze a row or column?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |