Visible pages

[mich]

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

 

[Luke M]

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.

 

[Gord Dibben]

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.

File>Page Setup>Sheet>Comments: pick "none" from the 3 selections
available.


Gord Dibben MS Excel MVP