Solved

Printing Excel - Rows to repeat on top not available

Posted on 2000-02-14
4
1,934 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

930 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

12 Experts available now in Live!

Get 1:1 Help Now