Excel not row repeat at top last page năm 2024

If you want to print a sheet that will have many printed pages, you can set options to print the sheet's headings or titles on every page.

Excel automatically provides headings for columns (A, B, C) and rows (1, 2, 3). You type titles in your sheet that describe the content in rows and columns. In the following illustration, for example, Projected is a row title and 2nd QTR is a column title.

Row headings

Column headings

Column titles

Row titles

Print row and column headings

1. Click the sheet.
2. On the Page Layout tab, in the Sheet Options group, select the Print check box under Headings.
   
3. On the File menu, click Print. You can see how your sheet will print in the preview pane.

Print row or column titles on every page

1. Click the sheet.
2. On the Page Layout tab, in the Page Setup group, click Page Setup.
   
3. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat.
4. Click OK.
5. On the File menu, click Print. You can see how your sheet will print in the preview pane.

Print row and column headings

1. Click the sheet.
2. On the Layout tab, under Print, select the Headings check box.
   
3. On the File menu, click Print. You can see how your sheet will print before you print it by clicking Preview.

Print row titles on every page

1. Click the sheet.
2. On the Layout tab, under Print, click Repeat Titles.
   
3. Click in the Columns to repeat at left box, and then on the sheet, select the column that contains the row titles. Tip: To minimize and expand the Page Setup dialog box so that you can see more of your sheet, click
   
   or
   
   next to the box that you clicked in.
4. Click OK.
5. On the File menu, click Print. You can see how your sheet will print before you print it by clicking Preview.

Print column titles on every page

1. Click the sheet.
2. On the Layout tab, under Print, click Repeat Titles.
   
3. Under Print titles, click in the Rows to repeat at top box, and then on the sheet, select the row that contains the column titles. Tip: To minimize and expand the Page Setup dialog box so that you can see more of your sheet, click
   
   or
   
   next to the box that you clicked in.
4. Click OK.
5. On the File menu, click Print. You can see how your sheet will print before you print it by clicking Preview.

See also

Print part of a sheet

Print with landscape orientation

Scale the sheet size for printing

Preview pages before you print

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

How do I repeat rows in Excel except last page?

F5 > Select Cells > OK Then you will see that all the pages are printed out with certain rows repeating on top, except the final sheet.

How do you repeat rows at top only certain pages in Excel?

First off, select the row you want to repeat. Next, navigate to the "Page Layout" tab and click on the "Print Titles" option. In the "Page Setup" window that appears, select the "Rows to repeat at top" or "Columns to repeat at left" option, depending on whether you want to repeat rows or columns.

Why can I not select rows to repeat at top in Excel?

Multiple sheet selection When you have multiple sheets selected in your workbook, the "Rows to Repeat at Top" option will be greyed out. This is because the option is only available for a single sheet.

How do I stop Excel from repeating rows?

On the Data menu, point to Filter, and then click Advanced Filter. In the Advanced Filter dialog box, click Filter the list, in place. Select the Unique records only check box, and then click OK. The filtered list is displayed and the duplicate rows are hidden.