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?

Lots of things are disabled if you use File|Print Preview then clicked page
setup.

Try going through
File|page setup
directly.

Bill D - Hubbard & Co 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?

--

Dave Peterson

Sorry - I was not clear in my first posting. I am using Excel 2007. I do not
have a File | Print menu. If I choose the Office Button, I can select Print.
This gives me Print - Quick Print - Print Preview. Selection 1 or 3 will not
let me use the print range input field, the rows/columns to repeat fields. If
I choose Page Layout from the ribbon and use the Page Setup area, the Print
Area button is disabled, and the Print Titles buttons is active. If I select
Print Titles a dialog opens but I am not able to change the rows or columns
repeat input values and they are blank.

I received another worksheet from a 2003 version and when I open that
worksheet in compatibility mode, these buttons work fine. It seems to be
related to the Excel 2007 sheet. I am trying to find out what check boxes,
controls, or options control whether these buttons are on or off.

I thank you for trying to help me and hopefully this is clearer. Where do
you think I should look?

"Dave Peterson" wrote:

Lots of things are disabled if you use File|Print Preview then clicked page
setup.

Try going through
File|page setup
directly.

Bill D - Hubbard & Co 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?

--

Dave Peterson

I don't use xl2007 enough to know.

Maybe someone else will chime in.

Bill D - Hubbard & Co wrote:

Sorry - I was not clear in my first posting. I am using Excel 2007. I do not
have a File | Print menu. If I choose the Office Button, I can select Print.
This gives me Print - Quick Print - Print Preview. Selection 1 or 3 will not
let me use the print range input field, the rows/columns to repeat fields. If
I choose Page Layout from the ribbon and use the Page Setup area, the Print
Area button is disabled, and the Print Titles buttons is active. If I select
Print Titles a dialog opens but I am not able to change the rows or columns
repeat input values and they are blank.

I received another worksheet from a 2003 version and when I open that
worksheet in compatibility mode, these buttons work fine. It seems to be
related to the Excel 2007 sheet. I am trying to find out what check boxes,
controls, or options control whether these buttons are on or off.

I thank you for trying to help me and hopefully this is clearer. Where do
you think I should look?

"Dave Peterson" wrote:

Lots of things are disabled if you use File|Print Preview then clicked page
setup.

Try going through
File|page setup
directly.

Bill D - Hubbard & Co 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?

--

Dave Peterson


--

Dave Peterson

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?

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?

I had the same problem, until I realized that I did not set up a printer. Once you have a default printer, you can set print areas



Bill D - Hubbard & C wrote:

Page layout - page setup - items disabled
17-Jul-08

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?

Previous Posts In This Thread:

On Thursday, July 17, 2008 8:05 AM
Bill D - Hubbard & C wrote:

Page layout - page setup - items disabled
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?

On Thursday, July 17, 2008 1:34 PM
Dave Peterson wrote:

Lots of things are disabled if you use File|Print Preview then clicked
Lots of things are disabled if you use File|Print Preview then clicked page
setup.

Try going through
File|page setup
directly.

Bill D - Hubbard & Co wrote:

--

Dave Peterson

On Thursday, July 17, 2008 1:55 PM
BillDHubbardC wrote:

Sorry - I was not clear in my first posting. I am using Excel 2007.
Sorry - I was not clear in my first posting. I am using Excel 2007. I do not
have a File | Print menu. If I choose the Office Button, I can select Print.
This gives me Print - Quick Print - Print Preview. Selection 1 or 3 will not
let me use the print range input field, the rows/columns to repeat fields. If
I choose Page Layout from the ribbon and use the Page Setup area, the Print
Area button is disabled, and the Print Titles buttons is active. If I select
Print Titles a dialog opens but I am not able to change the rows or columns
repeat input values and they are blank.

I received another worksheet from a 2003 version and when I open that
worksheet in compatibility mode, these buttons work fine. It seems to be
related to the Excel 2007 sheet. I am trying to find out what check boxes,
controls, or options control whether these buttons are on or off.

I thank you for trying to help me and hopefully this is clearer. Where do
you think I should look?

"Dave Peterson" wrote:

On Thursday, July 17, 2008 2:01 PM
Dave Peterson wrote:

I don't use xl2007 enough to know.Maybe someone else will chime in.
I do not use xl2007 enough to know.

Maybe someone else will chime in.

Bill D - Hubbard & Co wrote:

--

Dave Peterson

On Thursday, July 17, 2008 2:08 PM
Gord Dibben wrote:

Are you actually in Print Preview mode?
Are you actually in Print Preview mode?

If so, go into setup from FilePage Setup


Gord Dibben MS Excel MVP

On Thursday, July 17, 2008 3:06 PM
BillDHubbardC wrote:

I am not in print preview mode.
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:


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to make your Web Site More Googly
http://www.eggheadcafe.com/tutorials...-web-site.aspx