Why are Excel print titles disabled?

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 print a title in Excel 2007?

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 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.”

Why is print titles locked?

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.

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.

What are print titles?

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 you unlock a cell?

Excel 2016: How to Lock or Unlock Cells

1. Select the cells you wish to modify.
2. Choose the “Home” tab.
3. In the “Cells” area, select “Format” > “Format Cells“.
4. Select the “Protection” tab.
5. Uncheck the box for “Locked” to unlock the cells. Check the box to lock them. Select “OK“.

How do you print gridlines in Excel 2007?

Print gridlines in a worksheet

1. Select the worksheet or worksheets that you want to print. For more information, see Select one or multiple worksheets.
2. On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines.
3. Click the File tab, and then click Print.
4. Click the Print button.

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.