In that scenario, there is a functionality in excel known as “Print Titles”, which helps set a row or rows to print at the top of every page. The printing job becomes frustrating as you are not able to see the column headers in print after the first page. When you are working on large spreadsheets where data is spread across multiple pages and when you need to take a print out, it doesn’t fit well on one page. You can see in the below screenshot that Row 1, which has column headers, are still visible even when you scroll down. Once you click on the “Freeze Top Row”, the top row will be freezer, and you scroll down in excel without losing visibility to excel.You need to select the “Freeze Top Row” option. You will see three options after clicking on the Freeze Pane option.You need to follow the below steps to freeze the top row. The same formula is used in cell E19 and cell F19.After using the SUM formula, the output is shown below.
You can download this Column Header Excel Template here – Column Header Excel Template Example #1 – Freezing Row/Column
