excel - rows repeat on top

C

cxxper

office 2007, i can not activate the print setup, sheet, rows repeat on top.
there is icon, but can not activate. what is the problem
 
N

Niek Otten

You probably try to do this via Print Preview. That doesn't work
Use the Page Layout tab and choose the Print Titles menu. It gives you the same setup tabs, but now Rows to repeat at top does
work

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| office 2007, i can not activate the print setup, sheet, rows repeat on top.
| there is icon, but can not activate. what is the problem
 
C

cxxper

Niek Otten said:
You probably try to do this via Print Preview. That doesn't work
Use the Page Layout tab and choose the Print Titles menu. It gives you the same setup tabs, but now Rows to repeat at top does
work

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| office 2007, i can not activate the print setup, sheet, rows repeat on top.
| there is icon, but can not activate. what is the problem


thank you! it works!
 
A

amorfelici

i use rows to repeat at top in page set-up. but it adds pages to my worksheet.
Instead of having only 17 pages without the "rows to repeat at top" it
becomes 34 pages, the addition having no entries (blank).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top