Visible pages
 

I've set up a protected form (customer feedback questionnaire) with some
cells unlocked for entering comments ticking check boxes etc, the document
is only one page, saved to open as Page Layout and its set up to print at
100%.

When I view the document however greyed out pages (the ones that say click
here to add data when setting up the document), appear to the right and
below my form. I'd like for these not to be there when the client opens the
document for editing, so hopefully someone can tell me how to do this?
I'm sure the answer is sooo obvious, but being new to excel I don't have a
clue!

Thanks

Visible pages
 

Depending on what you want, you can either select the columns/rows,
right-click and "hide" them. (once you protect sheet, users will not be able
to unhide).

Or, if its the printing you're concerned about, go to View, Page Break
Layout, and drag the solid blue lines in so that only the area you want to
print is in the white area.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mich" wrote:

I've set up a protected form (customer feedback questionnaire) with some
cells unlocked for entering comments ticking check boxes etc, the document
is only one page, saved to open as Page Layout and its set up to print at
100%.

When I view the document however greyed out pages (the ones that say click
here to add data when setting up the document), appear to the right and
below my form. I'd like for these not to be there when the client opens the
document for editing, so hopefully someone can tell me how to do this?
I'm sure the answer is sooo obvious, but being new to excel I don't have a
clue!

Thanks

Visible pages
 

Do you have Comments that state "click here to add data" when you hover over
the cell?

If that's the case, you can choose to print or not print Comments.

FilePage SetupSheetComments: pick "none" from the 3 selections
available.


Gord Dibben MS Excel MVP

On Tue, 13 Jan 2009 09:11:01 -0800, mich
wrote:

I've set up a protected form (customer feedback questionnaire) with some
cells unlocked for entering comments ticking check boxes etc, the document
is only one page, saved to open as Page Layout and its set up to print at
100%.

When I view the document however greyed out pages (the ones that say click
here to add data when setting up the document), appear to the right and
below my form. I'd like for these not to be there when the client opens the
document for editing, so hopefully someone can tell me how to do this?
I'm sure the answer is sooo obvious, but being new to excel I don't have a
clue!

Thanks