"Rows to repeat at top", in Page Setup/Sheet disabled in Excel 2010
I have read all of the postings on this question. I am having the same problem! However I do not see any solution. I see a lot of "I think's", or "try this'", but no clear cut-solution. Let me restate;
I am running Excel 2010 in Office Professional:
I want to print a long spread sheet and I would like the title row repeated on the top of each page. I specify the print area range. The first row is frozen, so that when I scroll through my work on screen, I can differentiate the column information by having
the first row frozen. I want this to happen when I print this long document.
I go to print and go to Page Setup. I select the "Sheet" tab. The Print address bar area is disabled (grayed), but my print range is there. Under "Print" Titles", both selections are disabled (grayed); "Rows to Repeat at Top" and Columns to Repeat at Left"
are unavailable for selection. The address selection button on the right, of each of these three address range bars are also disabled (grayed).
This worksheet is on my hard drive. It is the only worksheet in the file. When I click on the worksheet tab, it does not say "Ungroup Sheets" which means that sheets have never been grouped.
I have been using Excel since Excel 95. I have done this many times in past versions, and it is a relatively simple procedure. Does any know why I can not access this feature in Excel 2010?
November 30th, 2012 3:37pm
Hi
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.
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. In the shuffling of the user interface from 2007 onwards, File, Print is
effectively the equivalent of the old Print Preview and the Page Setup options in the Page Layout tab the equivalent of the "old" File Page Setup.
Hope this helps
November 30th, 2012 3:49pm
G North I see you have 8,175 points. You are being short changed. I have read many others who have tried to answer and offer a solution to this simple problem. They all used a lot of words, and said absolutely nothing. You used 132 words, and solved my
problems. Thanks for your help!
November 30th, 2012 4:19pm
Glad to help. (not here for the points)
November 30th, 2012 4:22pm
Hi,
Thanks to both of you to share the helpful information to us. This will help the others who meet the same issue.
December 4th, 2012 9:59am
Thanks,
You saved my sanity (what's left of it.)
May 3rd, 2013 1:42pm
You could also save a Macro to do this and add a button that calls the macro. For example:
Sub macro_Paginate_RepeatTitleRow()
'
' macro_Paginate_RepeatTitleRow Macro
' Repeat title (first) row on all printed pages
'
Application.PrintCommunication = False
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
End With
Application.PrintCommunication = True
End Sub
July 12th, 2013 6:23pm
I have always understood that glitch between accessing the Rows To Repeat via Print Preview and straight from the spreadsheet Menu.
Today, it was greyed out via BOTH pathways and I cannot get the titles to print on a multi-page document.
Any thoughts / ideas?
Thanks
January 15th, 2014 8:14pm
Here we are 15 months later and Microsoft Excel 2013 has the SAME ERROR
If one chooses:
- Print Preview
- Page Setup
- Sheet
Then the print area and print titles (Rows to repeat at top, columns to repeat at top)
are all grayed out and cannot be selected.
If, however, I choose the
page layout bar and click print titles then
everything works fine.
Thanks for the solution!!!
February 14th, 2014 8:28am
Do you have multiple sheets highlighted? I just had the exact same problem and when I chose only one sheet, it cleared it right up!
March 11th, 2014 2:57pm
Dear Sir,
It is enabled through the option Page Layout-->Print Titles.
Please check this out......... and confirm...........
Keshav
April 7th, 2014 6:24am
Awesome! This helps! Thank you.
-
Proposed as answer by
Shreedhar Halli
Monday, July 07, 2014 9:05 AM
June 18th, 2014 8:01pm
Awesome! This helps! Thank you.
-
Proposed as answer by
Shreedhar Halli
Monday, July 07, 2014 9:05 AM
June 18th, 2014 8:01pm
Thank you very much. helped lot.
July 7th, 2014 9:06am
A+ response. Thanks!!
July 16th, 2014 6:58pm
This worked. Thanks Harold1953!
August 4th, 2014 9:07pm
A note for anyone else that might encounter this problem. Be sure you don't have print preview open in another Excel window, or you'll have the same problem.
I had two different spreadsheets open in two different Excel windows and I was trying to match up the page layout settings between them. I had to close the print preview on the first window before the fields would open up enabled on the second.
August 7th, 2014 9:46pm
I experienced the issue you described below and tried all of the solutions with no luck.
But, if you close the MS Excel Application and re-launch it it will also fix this bug.
August 12th, 2014 4:33pm
This is, to a degree. the solution to my problem. I had the File tab selected in another workbook. This saved the day :)
August 26th, 2014 11:26am
Thanks Mister, it worked!
October 24th, 2014 8:28pm
This was my issue, thanks! Was very frustrated!
November 14th, 2014 11:51pm
Brian Baker -- Your input proved extremely helpful to the problem I was searching.
Thank you!!
November 17th, 2014 8:07pm
Thanks for the fix!! I had multiple windows open as well.
December 11th, 2014 4:41pm
Spot on!
Working with Excel all these years and I couldn't think one through. Thanks
December 28th, 2014 9:28pm
Yes, that was the problem! Thank you thank you...I have been trying to fix it all day. I had multiple sheets open and I closed them and it didn't fix it, but I also had excel spreadsheets opened
and minimized. As soon as I closed them I was able to set my print titles.
January 14th, 2015 4:05am
Thank you, this was driving me mad, a relaunch solved it. So frustrating!
January 24th, 2015 11:31pm
Same problem (in Excel 2013), but I had only a single worksheet open and print preview was not open, and it still would not allow me to set the number of rows to repeat.
I saved the worksheet, closed Excel, then reopened the worksheet.
This time, it allowed me to set the number of rows to be repeated and it printed just as I wanted.
Save, close, & restart may be the key. I can't imagine this was intended, so perhaps it's a bug MS can fix.
July 24th, 2015 2:41pm
Thanks so much....I didn't have the print preview opened anywhere else but I did have a number of other Excel documents open. Once I closed most of those then the Print Titles Option was no longer blocked.
August 24th, 2015 12:50am
This was stumping me as well. Your suggestion to close any other open Excel worksheet worked. Thanks.
August 29th, 2015 2:02pm