Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up Excel so there is a border on every page?
I need to make a multi-page spreadsheet that is professional-looking and has
a dark black border around the table on every page. Using the normal border function on the toolbar doesn't work as a) the heaviest border is not heavy enough and b) every time a row is inserted or deleted the border moves! Is it possible to do this? Thanks, Laurie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up Excel so there is a border on every page?
There is no built-in way to do this. If I had to do it I might try creating
an empty sheet with a border exactly around the perimeter and print multiple copies of it. Then put that paper back in the printer and print the report on it. -- Jim "Laurie M" <Laurie wrote in message ... |I need to make a multi-page spreadsheet that is professional-looking and has | a dark black border around the table on every page. Using the normal border | function on the toolbar doesn't work as a) the heaviest border is not heavy | enough and b) every time a row is inserted or deleted the border moves! | | Is it possible to do this? | | Thanks, | Laurie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up Excel so there is a border on every page?
Hi Jim,
Thanks for your reply. Sounds like a good idea but it won't work in my case as I am making a template that is to be filled in with different data every month! Cheers, Laurie "Jim Rech" wrote: There is no built-in way to do this. If I had to do it I might try creating an empty sheet with a border exactly around the perimeter and print multiple copies of it. Then put that paper back in the printer and print the report on it. -- Jim "Laurie M" <Laurie wrote in message ... |I need to make a multi-page spreadsheet that is professional-looking and has | a dark black border around the table on every page. Using the normal border | function on the toolbar doesn't work as a) the heaviest border is not heavy | enough and b) every time a row is inserted or deleted the border moves! | | Is it possible to do this? | | Thanks, | Laurie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up Excel so there is a border on every page?
In another program like MS Word create a box about the size you want, select
and copy the box (border) into MS Paint and save with a name like border with a .bmp extension. In Excel go to page setup, select custom header and in the middle area select the picture option and insert the border.bmp file. The border will now show up on every printed page. You will have to experiment to get a border to fit your excel page format. Gary "Laurie M" wrote: I need to make a multi-page spreadsheet that is professional-looking and has a dark black border around the table on every page. Using the normal border function on the toolbar doesn't work as a) the heaviest border is not heavy enough and b) every time a row is inserted or deleted the border moves! Is it possible to do this? Thanks, Laurie |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up Excel so there is a border on every page?
Color the cells around the periphery of the table. Set the colored column width to ~0.88 and the colored row height to ~9. If you insert rows or columns the border persists. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Laurie M" <Laurie wrote in message I need to make a multi-page spreadsheet that is professional-looking and has a dark black border around the table on every page. Using the normal border function on the toolbar doesn't work as a) the heaviest border is not heavy enough and b) every time a row is inserted or deleted the border moves! Is it possible to do this? Thanks, Laurie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
cell border colors in Excel | Excel Discussion (Misc queries) | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
How to place a border on every page in excel? | Excel Worksheet Functions |