How To Keep Headings At Top Of Page In Excel - Tap view > freeze panes, and then tap the option you need. Web steps to keep the title at the top of the page in excel. Go to the menu bar and click view. 3. New options will show up. Click on print titles in the page setup group. Web if you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Web click the [page layout] tab > in the page setup group, click [print titles]. Click and select the row you wish to appear at the. Make sure that you're on the sheet tab of the page setup dialog box. Web open the worksheet that you're going to print.
First, locate the first row just below the title row and select it. Use the freeze panes feature in excel to keep headings at the top of the page, allowing them to remain visible as you scroll through the rest of the spreadsheet. Click on print titles in the page setup group. Tap view > freeze panes, and then tap the option you need. Web click the [page layout] tab > in the page setup group, click [print titles]. Under the [sheet] tab, in the rows to repeat at top field, click the spreadsheet icon. Click and select the row you wish to appear at the. Switch to the page layout tab. New options will show up. Web steps to keep the title at the top of the page in excel. Make sure that you're on the sheet tab of the page setup dialog box. Web if you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Go to the menu bar and click view. 3. Web open the worksheet that you're going to print.