Solved

Printing Excel - Rows to repeat on top not available

Posted on 2000-02-14
4
1,933 Views
Last Modified: 2008-03-10
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
Comment
Question by:ept68
  • 2
4 Comments
 
LVL 22

Accepted Solution

by:
ture earned 150 total points
ID: 2519436
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
 

Author Comment

by:ept68
ID: 2520548
Thanks for the suggestion Ture - but that didnt make any difference!
0
 
LVL 1

Expert Comment

by:tfspry
ID: 2520920
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
 

Author Comment

by:ept68
ID: 2522153
Ture

You were right!! sorry for my ignorance and thanks again!!!!
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

How many times recently have you prepared a presentation or emailed a document to a client and you have found that they have older versions of MS Office and they can not open the file you have prepared.  Although most visitors to this site are exper…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now