I am not in print preview mode. But considering the suggestion, I tried that
as well. Same result. It is as if these buttons have been turned off
purposely.

Now for what I discovered and the resolution..... when I do print this
sheet, it prints 6 pages when there are only 3. The data on the other 3 pages
is made up of some of the columns on the first three pages but without
formatting. Like a ghost set of pages. I checked further and found that the
"ghost data" was located on worksheet 2. I was only using worksheet 1. But I
had copied materials into this sheet using copy and paste CTRL keys. After
deleting all the data in worksheet 2, I was able to print properly on
worksheet 1.

I do not know what caused the information to be placed on worksheet 2, as I
am almost positive I pasted only into worksheet 1. But I guess it was user
error. My bad.

I still do not know what data if any, on worksheet 2 was disabling the
printer functions but now it seems to work fine.

I still appreciate your time.

Now back to work for me. Thanks again.


"Gord Dibben" wrote:

Are you actually in Print Preview mode?

If so, go into setup from FilePage Setup


Gord Dibben MS Excel MVP

On Thu, 17 Jul 2008 05:05:01 -0700, Bill D - Hubbard & Co <Bill D - Hubbard &
wrote:

I am trying to control page breaks and the print area of a worksheet. When I
access the page layout menu, page setup area, the print area butons is
diabled. Additionally I cannot set the print area, columns and rows toprint
at the top and side of each page and I cannot move the automatic page breaks.
Why is this disabled and how do I enable it?