Found Page Border Template. But How Does it Work?

[Guy Hoffman]

I have been looking for a way in excel to put a border around each pag
printed (similar to Word's Page Border option). Apparently, so hav
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 accomplishes the bodering of eac
page?

I cannot sleep until I know

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

 

[Gord Dibben]

Guy

View>PageBreak Preview.

NOTE: this is just a preview. It won't print out like that.

Now go to bed<g>

Gord Dibben Excel MVP

 

[Guy Hoffman]

Gord,

I don't follow what you are trying to demonstrate. What I canno
figure out is how the boder is automatically placed around the define
print range. No matter what print range you define, It places a borde
around the entire selection. If the print range spans multiple pages
it puts a border at the bottom of each page.

How, how, how

 

[Gord Dibben]

Guy

I opened the file and you have View>PageBreak Preview set "on".

Go to View(on Menu Bar next to "Edit") and click on "Normal" and see what
happens.

When in "pagebreak view" Excel is showing you where the page breaks will
occur. You can set page breaks manually or let Excel do it for you after you
have set up the upper and lower margins in File>Print Setup>Margins.

As noted, it won't print out in this view, it is just a "preview".

Gord