How do I make the first row in Excel print on every page?

Use these steps to display the top row on every page in Excel 2010.

Select the Page Layout tab.
Click the Page Setup button.
Choose the Sheet tab.
Click inside the Rows to repeat at top field.
Click the row number you wish to repeat.
Click the OK button.

How do I keep the top row in Excel from scrolling down?

To freeze the top row or first column:

From the View tab, Windows Group, click the Freeze Panes drop down arrow.
Select either Freeze Top Row or Freeze First Column.
Excel inserts a thin line to show you where the frozen pane begins.

How do I repeat top and bottom rows in Excel?

Through the Sheet tab of the Page Setup dialog box (display the Page Layout tab of the ribbon and click the small icon at the lower-right of the Sheet Options group), Excel allows you to specify rows to repeat at the top of a printout or columns to repeat at the left of a printout.

How do you guarantee that all columns will print on one page in Excel?

Click the Page Layout tab on the ribbon. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page. To print your worksheet on a single page, choose 1 page in the Height box.

How do you freeze a row in Excel that isn’t the top row?

To freeze rows:

Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3.
Click the View tab on the Ribbon.
Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
The rows will be frozen in place, as indicated by the gray line.

How do you print rows repeatedly at the bottom of every printed page in Excel?

MS Excel does not have a direct way of repeating rows at bottom or repeating columns at right while printing. It has options to only repeat rows or columns at top or left. One of the ways to repeat rows at the bottom of a page is to use a footer on every page.

How do you repeat rows on bottom of every printout except the last page in Excel?

How do you print rows in Excel?

Step 1: Open the spreadsheet in Excel 2013. Step 2: Click the Page Layout tab at the top of the window. Step 3: Click on the top-most row that you want to print, then drag your mouse down until the desired rows are selected. Step 4: Click the Print Area button in the Page Setup section of the ribbon, then select Set Print Area.

How to repeat heading row every nth row in Excel?

After above steps,click at Kutools Plus > Printing > Insert Page Break Every Row. See screenshot:

In the Insert Page Break Every Row dialog,type the interval number into the textbox. See screenshot:

Click Ok. Now in every 5 row,there is a page break,and when you print the worksheet,the heading row is in the top in every page.

How do you repeat rows at top?

Click the Page Layout tab. Click the Page Setup dialog launcher or the Print Titles button. Click the Sheet tab at the top of the Page Setup window. Click inside the Rows to repeat at top field. Click the number of the row that you want to repeat, or manually enter the $X:$X data.

What is the first row in Excel?

In an Excel worksheet, rows are numbered top to bottom with row 1 being the first row. columns are numbered left to right with column A being the first column.