Expanding upon this, if you choose the upper-left most, singular cell, that you do not want to be frozen, and choose freeze panes, all panes above and to the left of that single cell are frozen. Now you're able to compare data for similar months from several different years. If you select cell B2, and under 'View,' choose 'Freeze Panes,' the first column AND row will be frozen simultaneously.

Move your windows so they are side by side. Instructions on how to freeze the top 3 rows on Excel:Step 1: Highlight the first two rows.

Open a new window for your workbook, and select the 2012-2013 Sales tab.

This article will help you understand how to freeze rows and columns.

Use the horizontal scroll bar in the bottom right of the window to move the worksheet so that Column N, which contains data for January 2015, is next to Column F. This function is proved useful when you want to freeze rows or columns containing headings so that they are visible throughout.Hint: This should split the worksheet between rows 16 and 17 and columns F and G. Select cell G17 and click Split to split the worksheet into multiple panes.Freeze First Column and use the horizontal scroll bar to look at sales from 2015.For this challenge, we want to be able to compare data for different years side by side. In the drop-down menu, select Freeze Panes. Click the View tab in the Ribbon and then click Freeze Panes. If you want to freeze row 2 but do not want to freeze any columns, click in A3. For example, if you want to freeze row 6 and column A, click in B7. Within our example file, there is A LOT of sales data. Click below the row you want to freeze and to the right of the column you want to freeze. To remove the split, click the Split command again.

The end goal is to produce the same effect as the View > Freeze Panes > Freeze Top Row command in Excel 2007 so that the top row of the worksheet is frozen and users can see the top row of the worksheet even as they scroll through the data. After creating a split, you can click and drag the vertical and horizontal dividers to change the size of each section. I am looking to programmatically freeze the top row of an Excel worksheet from VBA.

How to freeze top 3 rows in excel 2016