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