Why are my print titles greyed out Excel?

Why are my print titles greyed out Excel?

On the Page Layout tab, in the Page Setup group, click Print Titles. 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.

Why won’t Excel let me add print titles?

The solution is both simple and not very obvious: Instead, you have to go through the “Page Layout” ribbon and set the print range there. Set the rows and columns to repeat by clicking on “Print Titles” within the “Page Layout” ribbon. Click on “Print Titles” within the “Page Setup” section on the “Page Layout” ribbon.

How do I enable 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.

How do you set print titles in Excel 2003?

Setting Print Titles for a Single Row and Column

1. From the File menu, select Page Setup…
2. Select the Sheet tab.
3. Under Print titles, in the Rows to repeat at top text box, type an absolute row reference for the row you want to repeat.

Why is my page setup greyed out in Excel?

The first thing to check is if you have printer drivers installed in Windows and, if you are using a networked printer, that the printer is online. 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.

How do you unlock cells in Excel?

Here’s how to lock or unlock cells in Microsoft Excel 2016 and 2013.

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

Why is rows to print at top greyed out?

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.

Why are rows greyed out in Excel?

Please check whether the worksheet is protected. Go to Review tab, check whether you have “Unprotect Sheet” button. Because the protect sheet feature may block “Insert columns”.

How do I make excel not print the title?

Go to the “Sheet Options” group of the “Page Layout” tab. Remove the check mark in the box next to “Print” in the “Headings” column. The column headings will no longer be printed. Go to the “Microsoft” icon and choose “Print” and then “OK.”

How do you reset print titles in Excel?

To clear print titles from a report if you no longer need them, open the Sheet tab of the Page Setup dialog box and then delete the row and column ranges from the Rows to Repeat at Top and the Columns to Repeat at Left text boxes. Click OK or press Enter.

How do you change print margins in Excel 2003?

To change the margins in the Page Setup dialog box:

1. Select the correct worksheet.
2. Choose File Page Setup from the menu bar.
3. Select the Margins tab.
4. Use the spin box controls to define the settings for each page margin—top, bottom, left, right, header, and footer.
5. Click the OK button to change the margin settings.