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?

_______________

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.


--
JBratcher
------------------------------------------------------------------------
JBratcher's Profile: http://www.excelforum.com/member.php...o&userid=33547
View this thread: http://www.excelforum.com/showthread...hreadid=531164