• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 88
  • Last Modified:

Print page header in Excel

Under Excel 2013  page setup, the "Rows to repeat at top" is grey out. Any idea ? I want to print out heading for each Excel page.

Tks
Setup01.png
Setup02.png
0
AXISHK
Asked:
AXISHK
  • 2
1 Solution
 
helpfinderCommented:
In page setup in Sheet tab just click the right icon in the "Rows to repeat on the top" and choose the area you wan to print on each paper (e.g. A1:A8).
Then this cells selection should be printed on each paper you print
0
 
AXISHKAuthor Commented:
Under File -> Info -> Print -> Page Setup --> Sheet tab, these option is grey out and I can select it... Tks
0
 
Adelaido JimenezDevOpsCommented:
Are you in Print Preview mode  or are you trying to change the setting by going to file >Print > Page setup? either of those will have the options grayed out. Try changing the setting by using the ribbon  instead. Go to Page Layout > Page Setup > Print Titles .
Here is a link to help you https://support.office.com/en-us/article/Print-rows-with-column-headers-on-top-of-every-page-d3550133-f6a1-4c72-ad70-5309a2e8fe8c?CorrelationId=2fac9ac2-5616-42da-9ff3-06147105dd89&ui=en-US&rs=en-US&ad=US
0
 
AXISHKAuthor Commented:
Tks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now