AuthorChristina ArchivesCategories |
Back to Blog
You can remove the reference to take your changes back. From now on, every printed page will start with header row. If you want to repeat a column or columns, use the Columns to repeat at left option.Ĭlick OK to save your settings. So began my journey to figure out how to remove table formatting in Excel 2016 which involved a lot of clicking around and Google. As there are no headers, the headers do not follow you as you scroll down. You can tell because Row 1 is not a header and does not have dropdown menu buttons. In the example below, we set Rows to repeat at top to 2 nd row to repeat. The bottom image is a normal range of cells. For example, to print the header row on each page, click the button and select the header row reference. In the Create Table dialog box, check the My table has headers check box and click OK. Click the Table button in the Tables group on the Insert tab in the Ribbon. Regardless of how you get to this step, you will need to be on the Sheet tab in the Page Setup dialog.Ĭlick the reference selector icon corresponding to the heading type you want to be repeated. Select the header row by clicking and dragging over the cells that contain the header row labels. ![]() ![]() You will see two reference inputs under the Print titles section. Once the dialog is open, go to the Sheet tab. You can find the link at the end of the Settings section. On the Print window, click the Page Setup link to open the Page Setup dialog.
0 Comments
Read More
Leave a Reply. |