#Freeze first two rows in excel 2007 how to
#Freeze first two rows in excel 2007 zip

This arrangement also lets you filter out individual bits of information when you start using functions later in this book. Bottom: The benefit of a six-column table is significant: It lets you break down (and therefore analyze) information granularly, For example, you can sort your list according to people’s last names or where they live.

#Freeze first two rows in excel 2007 zip

And if you clump the addresses and ZIP codes together, you have no way to count the number of people in a certain town or neighborhood. For example, you can start by typing information into cell A40 without worrying about filling any data in the cells that appear in the earlier rows.įigure 1-4. Top: If you enter both first and last names in a single column, you can sort the column only by first name. However, you don’t have to follow any set order. When you enter information, enter it one cell at a time. Every spreadsheet file can hold a virtually unlimited number of worksheets, as you’ll learn in Chapter 4. In the unlikely case that you want to go beyond those limits-say, if you’re tracking blades of grass on the White House lawn-you’ll need to create a new worksheet. Incidentally, an Excel cell can hold approximately 32,000 characters.Ī worksheet can span an eye-popping 16,000 columns and 1 million rows. Figure 1-3 shows this cell, which looks like a rectangular box. For example, C6 is the address of a cell in column C (the third column) and row 6 (the sixth row). Excel uniquely identifies each cell by column letter and row number. The smallest unit in your worksheet is the cell. Excel names columns using letters (A, B, C…), and labels rows using numbers (1, 2, 3…). To freeze the top row and two leftmost columns, you must first of all make the cell active whose top left corner rests at the intersection of theīottom of the row and right edge of the column you want to freeze.The grid divides your worksheet into rows and columns. Then as you scrolled right, you would still be able to see the year and financial period that the data related to, as they would be frozen in place. If the table of data was wider, so that you had to scroll horizontally, freezing the two leftmost columns in addition to the top row would be a good idea. For example, consider the following example. These can all be frozen by making a carefullyĬhosen cell active and then choosing the Freeze Panes option from the Freeze Panes menu. It may be that you have column headings that span more than one row, or a even row headings. To remove the frozen panes, click the same Freeze Panes button again but this time select Unfreeze Panes. When you scroll downwards, the top row will always be displayed where it currently is. When you choose this option, a discrete line appears beneath the top row, indicating Which is why freezing the top row is a popular option. Column headings are often displayed in the top row, We'll look at the option to Freeze Top Row first as that's the most simple to understand.

#Freeze first two rows in excel 2007 how to

How To Freeze Panesįirstly, you don't need to work on data that has been converted to a table to freeze panes, although in this example I am.Ĭlick View > Window > Freeze Panes.

When you freeze panes in Excel, the headings will remain fixed in place while the data scrolls. On the other hand, if you have a large table that has many columns, without those headings to remind you, you may very soon forget which column is which. If you have a small table with only a few columns, it will probably be easy to remember what data is held in each column and so it doesn't matter that youĬan't see those column headings. By default, when you scroll down a table of data, the colun headings you so lovingly crafted will disappear off the screen.