Recommendations 

Why are Excel print titles disabled?

Kobe Glover

Why are Excel print titles disabled?

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 I turn on print titles 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.

Why is Page Setup greyed out in Excel?

It could be that if you don’t have a printer available to Excel that the program is disabling those options because setting them would have no meaning. Another thing to check is if the problem crops up with all workbooks or just with a single one.

Why can’t I repeat titles in Excel?

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. To unlock either button, you can also try clicking [File] > “Print” > “Page Setup.”

How do I remove print titles in Excel?

Remove Report Name when Printing from Excel

  1. Open Excel file.
  2. Click File.
  3. Select Print.
  4. Click Page Setup.
  5. Select Header/Footer.
  6. From Header drop-down choose (none)
  7. Click OK.
  8. Select Print.

How do you automatically number pages in Excel?

On the Insert tab, click Header & Footer. Excel automatically changes to Page Layout view. On Header & Footer tab, click either the Header or Footer, and then select the page number format you want. Header page numbers appear at the top of the printed page, and footer page numbers appear at the bottom.

What are print titles in Excel?

Excel 2013’s Print Titles feature enables you to print particular row and column headings on each page of the report. Print titles are important in multipage reports where the columns and rows of related data spill over to other pages that no longer show the row and column headings on the first page.

How do I create a custom footer?

On the Insert tab, in the Text group, click Header & Footer. Excel displays the Page Setup dialog box. Click Custom Header or Custom Footer. Use the buttons in the Header or Footer dialog box to insert specific header and footer elements.

How do I unlock Page Setup in Excel?

You can do it by following these steps:

  1. Click the File tab and then click Options.
  2. At the left side of the dialog box click Customize Ribbon.
  3. In the right column of the dialog box, click the small plus sign at the left of the View tab entry.
  4. Click once on the Workbook Views option.
  5. Click the Remove button.
  6. Click OK.

How do I fix Page Setup in Excel?

More information

  1. Press CTRL and then click each worksheet tab in the workbook that you want to affect.
  2. On the File menu, click Page Setup. In Excel 2007, click the dialog box launcher in the Page Setup group in the Page Layout tab.
  3. Make the changes that you want in the Page Setup dialog box, and then click OK.

How do you set print titles in Excel 2010?

Step 1: Open your spreadsheet in Excel 2010. Step 2: Click the Page Layout tab at the top of the window. Step 3: Click the Print Titles button in the Page Setup section of the Office ribbon.

How do you unlock the print area in Excel?

Clear a print area

  1. Click anywhere on the worksheet for which you want to clear the print area.
  2. On the Page Layout tab, in the Page Setup group, click Clear Print Area.

Where to find print titles in Excel 2016?

Most common solution was to make sure you access Print Titles from the Page Layout tab on the top ribbon. That didn’t work for me. This did work for Excel 2016: Go to View in top ribbon, make sure at far left you are NOT on Page Layout.

Why is print title not available in Excel?

If you forgot your password, you can reset your password . In the print preview on the sheet tab the print title option is not available, “rows to repeat at top”, can’t figure this out… any ideas? How to show all formulas in Excel?

How do I change Page Setup in Excel?

I would suggest using the Print Titles button on the Page Layout tab in the ribbon to make the neessary changes. As you are a veteran of previous versions this greying out was the case if you activated Page Setup from the Print Preview options but not through File, Page Setup.

Why are rows to repeat at top disabled in Excel?

By deault the option for settiing print area, rows to repeat and columns to repeat are greyed out if you display the Page Setup dialog via the Print option. ” I go to print and go to Page Setup”. I would suggest using the Print Titles button on the Page Layout tab in the ribbon to make the neessary changes.