Printing Issues when distributing a form to multiple users

[Dave K]

I am distributing a spreadsheet to multiple users. The spreadsheet is
being used as a form for data entry.

The problem i am having is that when it is being printed, the users
are getting varying page layouts where the page breaks have changed,
due the changes to the length of the document growing from the free
text they are entering. The page breaks that excel chooses don't seem
to be spaced well, leading to one or two of the pages being very short
(i.e., leaving a lot of free white space), whereas the other pages are
taking up the entire page.

Is there a particular page layout selection I can use (or perhaps
protection of some sort) that may alleviate this printing problem?

Thanks for any suggestions.

 

[GS]

Dave K was thinking very hard :

I am distributing a spreadsheet to multiple users. The spreadsheet is
being used as a form for data entry.

The problem i am having is that when it is being printed, the users
are getting varying page layouts where the page breaks have changed,
due the changes to the length of the document growing from the free
text they are entering. The page breaks that excel chooses don't seem
to be spaced well, leading to one or two of the pages being very short
(i.e., leaving a lot of free white space), whereas the other pages are
taking up the entire page.

Is there a particular page layout selection I can use (or perhaps
protection of some sort) that may alleviate this printing problem?

Thanks for any suggestions.

Remove all existing page breaks and let Excel manage them as follows:

In PageSetup dialog:
Set to print 1 pages wide, leave pages tall empty.