Can Excel display column headers on each screen? Yes, in Excel is called freezer boilers, which can be applied to columns or rows (or both), and it is super clear. We also show you how to split screens, a similar function. Both options make it easier to navigate large spreadsheets without losing track of basic data.
Freezing and Disconnecting Panels in Excel
The Freeze feature in Excel lets you scroll down through hundreds of rows and still sees the original headings or fields named in line 1 or browse hundreds of columns and still see data as a product or person's name in column A.
2nd To freeze the headings at the top of line 1, select View> Window (group)> Frozen panels> Frozen top row and it is clear. Now you can scroll down through hundreds of rows and the headers stagnate at the top of each screen.
3rd However, if your headers are stacked in multiple cells (on multiple lines, for example), or if you have a title on the spreadsheet, you want to freeze more than just the top row.
4th Then place the cursor in a cell just below the heading (s) you want to freeze. For example, to freeze both rows 1 and 2, place the cursor in line 3 and select View> Window (group)> Frozen panels. Excel freezes both row 1 and row 2. Press the Page Down key and note that the cursor moves down through the spreadsheet and the headings are stationary at the top.
5. The same applies to columns. For example, if you move the cursor to column C, select View> Window (group)> Freezers freezes Excel both columns A and B.
6. To disable the frozen boxes select only View> Window (group)> Frozen panels> Release panels and the spreadsheet returns to its original state.
You can also split the spreadsheet into quadrants, making it easier to work on columns or rows that are full screens apart. For example, if you divide the worksheet into two vertical sections, you can copy and paste cells from column B (in the left part) to column AD (in the right part) without having to mark over 28 columns or move multiple pages to the right.
first With Window Split you have to place the cursor to the right of the column where you want the split to break, or just below the line you want the split to break. Only select View> Window (group)> Share and the window is divided into halves or quadrants at the location where the cursor is located.
2. If the window does not divide where you need it, you can easily move the parts. Just place the cursor on top of the cutting vertical and horizontal lines. When the cursor changes to a cross with arrows at the ends, hold down the left mouse button and drag the split to its new location.
3. To remove the split, just select View> Window (group)> Share again, and the sharing window disappears and reveals the full worksheet again.
For more samples and detailed instructions on Freeze / Release and split Windows in Excel, check out our Excel Large Spreadsheet Tips.