Excel print title rows to repeat at top năm 2024

1. Knowledge Base
2. Software and Solutions
3. Microsoft Office
4. Microsoft Office How-to
5. How to Repeat Title Rows in Excel (Mac and Windows)

Use the steps below to print title rows on each page of an Excel spreadsheet.

Step-by-Step

1. Click the Page Layout tab at the top of the window and select "Print Titles."
2. In the window that appears, select the Sheet tab if it is not already selected and click the spreadsheet icon in the "Rows to repeat at top" field.
3. Select the row or rows you wish to appear at the top of each page, then hit the return key and click OK.
4. To verify that the correct settings have been applied, select File>Print>"Show Print Preview."

Print Article

Details

Article ID: 82974

Modified

Wed 9/9/20 10:07 AM

Print gridlines and, for multiple page worksheets, print row or column headers or labels (also called print titles) in the first row or multiple rows on every page.

Want more?

Freeze or lock panes

Insert headers and footers

Print a worksheet or workbook

Here are a few more things you can do with printing in Excel, including printing headings, gridlines, row and column headings, and formulas.

You can even mimic a watermark and print it.

The first row of this worksheet has labels for the columns. This is referred to as a header row.

Since the worksheet is longer than a page, printing the header row on every page makes the worksheet easier to read.

You won't have to keep flipping back to Page 1 to remember what data was in a column.

Click the PAGE LAYOUT tab, and click Print Titles. Click in Rows to repeat at top, and then click any cell in row 1.

The entire row is automatically filled in for me. You can select multiple rows.

You can also select Columns to repeat at left to have columns repeating on the left of every page.

Click Print Preview, and in print preview you can see that the header will print at the top of every page.

If you have frozen or locked panes and want to print the top or left pane on every page, see the course summary at the end of the course for a link to the Freeze or lock panes course.

There are comments in this worksheet. When I point to the red indicator in the corner of this cell, the comment appears.

When you print a worksheet, you can print the comments at the end of the worksheet or as they display on the worksheet.

To print the comments as they display on the worksheet, you first have to display them.

Click the REVIEW tab, and click Show All Comments. Now I click the PAGE LAYOUT tab. Click Print Titles.

Click the Comments down-arrow. You have the options to print them At end of sheet or As displayed on sheet. Click As displayed on sheet.

Click Print Preview, and in print preview you can see the comments on the worksheet.

On the screen, by default, the worksheet's pages have gridlines, making it easier to read across rows and down columns.

But when you print, by default, the gridlines are not printed.

To print gridlines in a worksheet, on the PAGE LAYOUT tab, under Gridlines, check Print .

Now when you print the worksheet, the gridlines are printed and it is easier to read.

You can print row and column headings. This is 1, 2, 3 and so-on for rows and A, B, C, and so on for columns.

It makes it easier to discuss a print-out if the rows and columns don't have some sort of sequential IDs.

On the PAGE LAYOUT tab, under Headings, check Print.

Now when you print the worksheet, the headings are printed.

You want to put a watermark on your worksheet that says "Confidential".

There isn't a watermark feature in Excel, but you can come pretty close.

On the PAGE LAYOUT tab, click Background. I already have an image I want to use.

If you don't, you can find one by clicking options such as Office.com Clip Art and Bing Image Search.

Browse or search to find the image you want, click it, and your worksheet now has a watermark that says "Confidential".

Or say, you want to have a group review of the equations in your worksheet, to make sure they are correct.

How to print Excel with repeat row at top?

On the Sheet tab, under Print titles, do one—or both—of the following:.

In the Rows to repeat at top box, enter the reference of the rows that contain the column labels..

In the Columns to repeat at left box, enter the reference of the columns that contain the row labels..

How do you repeat header rows in Excel?

In the table, right-click in the row that you want to repeat, and then click Table Properties. In the Table Properties dialog box, on the Row tab, select the Repeat as header row at the top of each page check box. Select OK.

Why is Excel not allowing rows to repeat at top?

This is because the option is only available for a single sheet. Solution: To fix this, unselect all but the sheet that you want to repeat the rows for. You can do this by clicking on the sheet tabs that you want to unselect.

How do I make one row stay at the top when printing in Excel?

Print the top row on every page.

On the Page Layout tab, in the Page Setup group, click Print Titles. If the Print Titles ribbon button is grayed out, check to ensure that you're not currently editing a cell or an area chart. ... .

On the Sheet tab, in the Rows to repeat at top box, type "$1:$1" (as shown in the figure)..