Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Bottom Border On Each Page
I have a long worksheet. I want the bottom line on each page to be bold. I
know I could go in and format, but then every time I change the number of lines, I have to change the format of each page since the bottom line may change. I really want a line that will go at the bottom of each page, like the line at the top of each page in the print setup. Thanks for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Bottom Border On Each Page
That capability isn't inherent. You would need to use the BeforePrint event
to remove all previous bold lines, then find all the pagebreaks and format the row above. -- Regards, Tom Ogilvy "mcambrose" wrote: I have a long worksheet. I want the bottom line on each page to be bold. I know I could go in and format, but then every time I change the number of lines, I have to change the format of each page since the bottom line may change. I really want a line that will go at the bottom of each page, like the line at the top of each page in the print setup. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bottom Border at Page Break Won't Print | Excel Discussion (Misc queries) | |||
Border at bottom of worksheet | Excel Discussion (Misc queries) | |||
Repeat bottom Border | Excel Discussion (Misc queries) | |||
Double Underline / Bottom Border | Excel Discussion (Misc queries) | |||
only last cell on page to have bottom border (cell area outline) | Excel Worksheet Functions |