I have a form on a excel worksheet. The headings on the form are fixed. The
required headings for the pages automatically appear on the following pages.
The content of each form varies. Some may be one page some twenty or more
pages.

The problem is that the form has three columns with a black line border. I
would like the form to have a horizontal border at the bottom of each page.

At present I have to put the horizontal border at the bottom of each page
before I can print it.

If I add a comment to the form I have to change the horizontal border on
each page. If the contents go onto the next page I have to insert rows to
push the horizontal border to the bottom of the page.


Can anyone advise how this can be completed automatically.

Many thanks

Excel isn't very nice when it comes to things like this.

And since it uses the printer that the end use is using, that last row on each
sheet can change (different printers can print more/fewer rows on the paper).

I think that the easiest way is to put manual page breaks in at conservative
intervals and just use excel as a typewriter--you format it exactly the way you
want.

If you insert/delete rows, you'll have to adjust the page breaks and formatting.

zephyr wrote:

I have a form on a excel worksheet. The headings on the form are fixed. The
required headings for the pages automatically appear on the following pages.
The content of each form varies. Some may be one page some twenty or more
pages.

The problem is that the form has three columns with a black line border. I
would like the form to have a horizontal border at the bottom of each page.

At present I have to put the horizontal border at the bottom of each page
before I can print it.

If I add a comment to the form I have to change the horizontal border on
each page. If the contents go onto the next page I have to insert rows to
push the horizontal border to the bottom of the page.

Can anyone advise how this can be completed automatically.

Many thanks

--

Dave Peterson