Avatar of Joseph Salazar
Joseph Salazar
Flag for United States of America asked on

Printing Sheets issue in Excel 2016

I have an Hp Printer and I am attempting to print out sheets

But when i try to enter the rows I want to print it is grayed out.

 -- Rows to Repeat at top
 --Columns to Repeat at left

I uninstalled the Printer and reinstalled and have the Same issue.

How can I repair.

See Picture below....the area I wish to edit is grayed out.

Cjoego
Printing-Sheets.PNG
Printers and ScannersMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Joseph Salazar

8/22/2022 - Mon
John

1. Try Repairing Office (Full Repair) - go to Programs and Features.
2. Make a new, test, Windows User Profile (Account) . Log into the new Account and test Excel printing in the new account.
Alan

Hi Jospeh,

Please can you try creating a new Excel workbook, and just put some random text in the first few rows, then try to do the print rows settings again, and let us know if that works.

If so, then it might be a corrupt file.

Alan.
Ramin

Did you try using the Print Titles button on the Page Layout tab in the ribbon ?
Do you get the same result ?

More details:
http://www.asknguyen.com/repeat-top-rows-printing-excel-2013.html
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
Rob Henson

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Joseph Salazar

ASKER
Thanks Rob that was it,

Cjoego