Page Bordering In Excel?

[Guy Hoffman]

I have been looking for a way for excel to print a border around eac
page printed (similar to Word's Page Border option). Apparently, s
have many other users.

I found the attached excel file in response to a similar post b
another user on this site but for the life of me a cannot figure ou
how it does it.

Are their any excel wizard's that can look at the attached excel fil
and help me figure out how this file prints a border around the define
print range (i.e., print a hard copy and your will see a border aroun
the defined print range. Re-define the print range and you still get
border around the newly defined range)?

How? How? How?

Note: I am not talking about Page Break Preview vs Normal view on th
View Menu. I'm talking about the hard copy having a box around wha
ever print range is defined

Attachment filename: page border template.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=48985

 

[Debra Dalgleish]

Cells are filled with white colour, and the print options have gridlines
turned on.

When the page prints, only the outer border of the gridlines is visible.
The other gridlines are covered by the white fill.

To see all the gridlines in print preview, change the fill to 'No Fill'

 

[Guy Hoffman]

So simple I feel really stupid. Thank you

 

[Debra Dalgleish]

You're welcome! Now you can use the page border trick to amaze and
confuse your friends. <g>