Click the Page Layout tab at the top of the window. Click the Print Titles button in the Page Setup section of the ribbon. Click inside the Rows to repeat at top field, click the row number that you wish to print at the top of every page, then click the OK button at the bottom of the window.
Contents
How do you designate print titles in Excel?
Print row or column titles on every page
Click the sheet. On the Page Layout tab, in the Page Setup group, click Page Setup. 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. Click OK.
How do I print titles on every page in Excel 2013?
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].
Why can’t I change the print titles in Excel?
If the Print Titles ribbon button is grayed out, check to ensure that you’re not currently editing a cell or an area chart. Also, check to verify that at least one printer is set up in Windows. On the Sheet tab, in the Rows to repeat at top box, type “$1:$1” (as shown in the figure).
How do you add a title in Excel 2013?
How to Include a Title at the Top of the Page in Excel 2013
- Open your Excel file.
- Select the Insert tab.
- Click the Header & Footer button.
- Choose where to display then title, then type it.
What is a print title?
Print Titles is the term Excel uses to describe the rows and columns you want repeated when you print a sheet over multiple pages. You typically want to repeat the labels in the top row(s) and those in the left column(s) of the sheet.You can display multiple rows and columns.
How do I AutoFill in Excel?
Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature. Or, say you have information in Excel that isn’t formatted the way you need it to be, such as this list of names.
How do I keep the title at the top of an Excel spreadsheet?
To keep the column headers viewing means to freeze the top row of the worksheet.
- Enable the worksheet you need to keep column header viewing, and click View > Freeze Panes > Freeze Top Row.
- If you want to unfreeze the column headers, just click View > Freeze Panes > Unfreeze Panes.
How do you print row and column headings in Excel?
On the Ribbon, click the Page Layout tab. In the Sheet Options group, under Headings, select the Print check box. , and then under Print, select the Row and column headings check box .
How do I print frozen panes on every page in Excel?
Always print frozen panes on every page in Excel
- Go the worksheet that you want to print, and click Page Layout > Page Setup, see screenshot:
- In the Page Setup dialog box, click Sheet tab, and then select the row or column range that you want to print on each page under the Print titles section, see screenshot:
Why is print titles locked in Excel?
Note: If the [Print Titles] button is locked (greyed out), it may be because you are currently editing a cell or you have chart selected. If the “Rows to repeat at top” spreadsheet icon is locked, it may be because you have more than one worksheet selected within your workbook.
Where is Print Preview Excel?
Click Menus tab. Click File tab, move to Print Preview. Click Print Preview, and there will be a Print Preview window popping up, just as what you use in Excel 2003.
What is Excel title bar?
It lies next to the quick access toolbar or on top of the excel window. It displays the name of the open document.
How do I get the lines to print in Excel?
Print gridlines in a worksheet
- Select the worksheet or worksheets that you want to print. For more information, see Select one or multiple worksheets.
- On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines.
- Click the File tab, and then click Print.
- Click the Print button.
How do you put a title on a table in Excel?
To change the table name:
- Select any cell in the table.
- On the Ribbon, under the Table Tools tab, click the Design tab.
- At the far left of the Ribbon, click in the Table name box, to select the existing name.
- Then, type a new name, such as Orders, and press the Enter key.
How do I create a custom AutoFill list in Excel?
Create your own AutoFill Series
Click the File tab. Click the Excel Options button to open the Excel Options dialog box. Click the Advanced button [A] and scroll to the bottom of the Advanced Options window. Click the Edit Custom Lists button [B] to open the Custom Lists dialog box.
How do I AutoFill data from another sheet in Excel?
Go to the destination worksheet and click the cell where you want to link the cell from the source worksheet. On the Home tab, click on the drop-down arrow button of Paste, and select Paste Link from “Other Paste Options.” Or right-click in the cell on the destination worksheet and choose Paste Link from Paste Options.
What is name box?
Name Box is a tool that shows the active cell address. For example, if you have selected the cell C1, this name box will show the active cell address as C1.
How do you guarantee that all columns will print?
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 remove duplicates from Excel?
Remove duplicate values
- Select the range of cells that has duplicate values you want to remove. Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.
- Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.
- Click OK.