How do I print the top row on every page in Excel 2010?

How do I print the top row on every page in Excel 2010?

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 top of every page. Press the [Enter] key, then click [OK].

How do I print a row on every page in Excel?

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.

How do I repeat rows in Excel 2010?

How to Repeat Rows in Excel 2010

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

How do I set print area in Excel 2010?

Set one or more print areas

1. On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print.
2. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

How do I fill every other row in Excel?

Shading every other row in a range makes it easier to read your data.

1. Select a range.
2. On the Home tab, in the Styles group, click Conditional Formatting.
3. Click New Rule.
4. Select ‘Use a formula to determine which cells to format’.
5. Enter the formula =MOD(ROW(),2)
6. Select a formatting style and click OK.

How do I show the top row in Excel when scrolling?

Select the cell in the upper-left corner of the range you want to remain scrollable….To freeze the top row or first column:

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

How do you print rows repeatedly at the bottom of every printed page 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 repeat row data in Excel?

Title Rows

1. Click the “Page Layout” tab, and select “Print Titles” from the Page Setup section of the ribbon.
2. Click inside the box next to “Rows to Repeat at Top” in the Page Setup dialog box.
3. Click in the worksheet on the row you want to repeat.
4. Click “OK” to save the change and close the dialog box.

How do I get my Excel spreadsheet to print on one Page?

Shrink a worksheet to fit on one page

1. Click Page Layout.
2. Select the Page tab in the Page Setup dialog box.
3. Select Fit to under Scaling.
4. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes.
5. Press OK at the bottom of the Page Setup dialog box.

How do I expand the print area in Excel?

How to expand print area in Excel

1. Select the cells that you’d like to add.
2. On the Page Layout tab, in the Page Setup group, click Print Area > Add to Print Area.

How to display the top row on every page in Excel 2010?

Repeating the top row on every page when you print in Excel is a great way to make the data easier to read. 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.

How to print a row at the top of every page?

Click inside the Rows to repeat at top field. Click the row number at the left side of the spreadsheet for the row that you wish to repeat at the top of every printed page. This will populate the Rows to repeat at top field with something like $1:$1, where the number represents the number of the row that will be repeated at the top of every page.

How to print title on every page repeatedly in Excel?

Now you can click the File (or Office button) > Print to print every n rows in one page with adding title into every page. Actually, we can apply Kutools for Excel’s Insert Titles Rows utility to add the title/header row at every x rows, and then split every x+1 rows as a separate page. Please do as follows:

How to print the first row of column headers in Excel?

For example, you can repeat the first row of column headers on all pages when you have large, complex worksheets. Select the worksheet that you want to print. On the Page Layout tab, in the Page Setup group, click Print Titles.