Printing data with borders over more than one page

[Professor]

Hi

In excel when I have a data with borders and want to print it is there
anyway for the last line of data on each page to apply a border underneath?

_______________

[JBratcher]

If your rows are of the same height

The best solution I have found is

Select all

Go to Conditional Formating

Select "Formula is"

Enter "=mod(row(),52)=0" (For a bottom border every 52 rows, change the number based on our page size and content)

Click Format and Apply a bottom Border.

If your rows are all exactly the same height, then this will work.

Combine it selecting all the data, and applying a box to it, you will even get a bottom line on the last incomplete page.

BUT if you use the header repeat, to make it easier to read the data, then it will not work easily.

The work around there is to make the number of rows one less than you are able to (or more precisely, subtract the number of rows your "repeating row" takes up, you should keep the header row a multiple of the common row height), and then

under View Page

Shorten the First page by that space. This will put the end of the page onto the proper row, and allow for all subsegent pages to have the bottom row automatically.

This is only slightly better than applying a new border to each page individually, but worth it for long tables.


I am also trying to remember a method where you use the BOX border tool but cannot. If anyone remembers a way to use the box border tools to make the border appear on ever page, please let me know.