#FREEZE FIRST TWO ROWS IN EXCEL CODE#
You could write some VBA code to handle the horizontal scrolling, but that simply adds complexity to the situation.
#FREEZE FIRST TWO ROWS IN EXCEL WINDOWS#
This means that if you scroll one of the windows left or right, the other window doesn't scroll at the same time. The biggest drawback to this approach is that the windows are not horizontally linked. This allows you to see everything you want to see, although it is a bit expensive when it comes to screen real estate since both windows have column letters visible. Now you can display the totals row (or rows) in the bottom window, and freeze the top rows in the top window. (The bottom window should be large enough to hold your totals and the top window can occupy the rest of the available space.) Use the mouse to adjust the vertical height of both windows. Make sure the Horizontal radio button is selected.Īt this point you should see your two windows-one in the top half of the screen and the other beneath it.You should see the Arrange Windows dialog box. Click the Arrange All tool in the Window group.Excel creates a new window on the data in the worksheet you are working on. Click the Freeze Panes box, then choose Freeze Panes from the list. Click the New Window tool in the Window group. Click on the first cell in the column below the rows you want to freeze.(This should be the only workbook open.) Then follow these steps: Start by opening the workbook that contains the worksheet you want to work on. There is another approach you can use, however. The top-of-column totals could be added either using SUM formulas (as you would with the totals at the bottom), or you can leave the totals at the bottom of the columns and simply add a referential formula (like =B327) in a row at the top of columns. Then, press ALT + W After that, our screen will look like the image below. First, click on cell A3, as we want to freeze the cell above this row. This may seem awkward, but it has the added benefit of allowing you to easily add new rows to your data table. Method 2: Freezing Top Two Rows Using Shortcut key We can also use a shortcut key to freeze the top two rows if we want. What most experienced Excel users do is to put the column totals at the top of the columns instead of at the bottom. Excel won't let you do this, however-when you try, then the freeze is removed and replaced with the split, and trying to reapply the freeze removes the split. At first thought you may believe that you can freeze rows and also split the worksheet window so that you can put the totals below the split. Unfortunately there is no way to do this in Excel. He would like to also freeze the bottom row, so the column totals are always visible. Kevin has a long (vertical) worksheet that has the first few rows frozen so the column headings are always visible.