Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1964
  • Last Modified:

Printing Excel - Rows to repeat on top not available

Hi there

Just got a new PC and installed Excel 2000 on it. I have prepare a worksheet and want the top row to print on every page. I have gone into page setup but the option is shaded out and unavailable.

I opened some older documents that I knew I had used the same options on before and they were available!!! However, if I disabled or deselected to repeat the rows, the option was not available again!!!! Please help ASAP!!

PS Hope this all makes sense - BTW Win98 environment using Office Prof 2000
0
ept68
Asked:
ept68
  • 2
1 Solution
 
tureCommented:
ept68,

This option is dimmed out if you go into Page Setup by clicking 'Setup' in Print Preview.

Do File - Page Setup directly from the workssheet instead.

Better?

Ture Magnusson
Karlstad, Sweden
0
 
ept68Author Commented:
Thanks for the suggestion Ture - but that didnt make any difference!
0
 
tfspryCommented:
Hi ept68
Are you saying that when you click on "File" ... then the "Page Setup" option is shaded out? You can't get to "Page Setup" at all?

0
 
ept68Author Commented:
Ture

You were right!! sorry for my ignorance and thanks again!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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