#Freeze headers in excel 2016 windows#

Now you're able to compare data for similar months from several different years. For more information see the Page Headers and Footers section of Exporting to Microsoft Excel (Report Builder and SSRS).

#Freeze headers in excel 2016 windows#

Move your windows so they are side by side.

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

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.

Hint: This should split the worksheet between rows 16 and 17 and columns F and G. Step 2: Click on the drop-down list of Freeze Panes in excel Freeze Panes In Excel Freezing panes in excel helps freeze one or more rows and/or columns so that they remain fixed while scrolling through the database.

Select cell G17 and click Split to split the worksheet into multiple panes. We can lock or freeze our row heading by following the below steps.

Freeze First Column and use the horizontal scroll bar to look at sales from 2015.

Any time you freeze rows and columns, the border below the last frozen row and to the right. You'd select cell D5, and then on the View tab, click Freeze Panes.

Say you want to freeze the top four rows and leftmost three columns. For this challenge, we want to be able to compare data for different years side by side. To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes. Within our example file, there is A LOT of sales data. This month IР Р†Р вЂљРІвЂћСћll show you how you can choose rows or columns to appear on every page when you print. To remove the split, click the Split command again. Last month I talked about how you can freeze rows or columns in an Excel workbook so that your headings stay visible on screen. After creating a split, you can click and drag the vertical and horizontal dividers to change the size of each section.