page border in excel

[Guest]

How can I set border for all pages in an excel sheet, just as page border in
word? Thanks.

 

[David McRitchie]

Hi Trang,

Watch your terminology.
Pages do not exist until it comes to printing.
Worksheets (sheets) are what you see on the tabs at the bottom
you could have other sheets besides worksheets.
Workbook is the filename.

Borders and Gridlines are not the same.

Gridlines are 1 pixel wide and you can have them visible or not
you can have them print or not. Interior color will wipe out the
surrounding gridlines.

If you want to put borders on all cells in your current (activesheet) you
would select all cells (ctrl+A, except in Excel 2003) then
format, cells, borders, choose color, choose each border.

If you want to do the same for all sheets in the workbook then
right click on the worksheet tab, select all sheets
.... do the same as in previous paragraph...

Must ungroup the sheets as any change to the visible worksheet
will also be done to the other sheets in the group, and would destroy
the content of your workbook very quickly.
right click on worksheet tab, UNGROUP sheets

If you want to make this so that all future workbooks have borders
to start with you would create a book.xlt in your XLSTART directory
and if you want to add any more sheets to any existing or future workbooks
you would create a sheet.xlt worksheet as your default.


More information on Gridlines and Borders in
http://www.mvps.org/dmcritchie/excel/gridline.htm
--

 

[Guest]

Hi David,
Thanks a lot for your explanation.
Yes I really mean the page print-out, not single cell, not the whole sheet.
When I have a multiple-page sheet, I want each printed page has a border,
just as page border in Word. Can I do that in excel without going to each
single "page" to set border for the range on that page?

 

[David McRitchie]

You could do outside borders and that would put a border around the
spreadsheet portion only. Repeating the first row on each page
would include to top row with the border on top, so you would have
the sides down each page, but the bottom border only on the
last printed page to the extent of the of the last row printed.

Anything more would require a macro to find the page breaks
and to put a lower border on the row before the page break.

So if that is what you want it would be possible (not easy) for
a macro. At least you'd be able to run the macro and print
the entire worksheet. A lot of things like this require printing
one page at a time and restarting the print for the next page
after making changes.