Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
This has been asked, but not answered...
I am needing to set a page border in excel. If I just draw a border around
the whole page, it works, until I have to go back and insert a record later. Obviously it moves everything down, including the drawn border. What I need is to basically have a permanent border around a set print area. Can this be done? I have searched this topic and it has been asked, but not clearly answered. I know you geniuses know the answer!!! Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
This has been asked, but not answered...
How about drawing your border, and then set the Print Area to include only
that area. Next under Page Setup, set it to "Fit to 1 Pg wide by 1 Pg Tall". You will be albel to insert new rows and keep the border. Once you reach a row count that would normaly cause a addition of a new page, the area will be reduced in size (font and all) to keep fitting on oen page. If this is not acceptabel, the only other way i knwo of doing it would be to create a macro. Or just redraw the border when you add records. "Kycajun" wrote: I am needing to set a page border in excel. If I just draw a border around the whole page, it works, until I have to go back and insert a record later. Obviously it moves everything down, including the drawn border. What I need is to basically have a permanent border around a set print area. Can this be done? I have searched this topic and it has been asked, but not clearly answered. I know you geniuses know the answer!!! Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
This has been asked, but not answered...
I'm not sure if this answers your question, but it may be helpful.
If you display page breaks, it looks like a border on the worksheet, in that it delineates the printed area with a dashed line. You can automatically show page breaks on all worksheets within a workbook by pasting the following subroutine into a module of the workbook. Sub Auto_Open() Dim wksht As Worksheet For Each wksht In Worksheets wksht.DisplayPageBreaks = True Next wksht End Sub "Kycajun" wrote: I am needing to set a page border in excel. If I just draw a border around the whole page, it works, until I have to go back and insert a record later. Obviously it moves everything down, including the drawn border. What I need is to basically have a permanent border around a set print area. Can this be done? I have searched this topic and it has been asked, but not clearly answered. I know you geniuses know the answer!!! Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
This has been asked, but not answered...
I'm gonna go with Wiley's suggestion for now. It works ~ somewhat ~ how I
want it to. Thanks for the responses! "Wiley" wrote: How about drawing your border, and then set the Print Area to include only that area. Next under Page Setup, set it to "Fit to 1 Pg wide by 1 Pg Tall". You will be albel to insert new rows and keep the border. Once you reach a row count that would normaly cause a addition of a new page, the area will be reduced in size (font and all) to keep fitting on oen page. If this is not acceptabel, the only other way i knwo of doing it would be to create a macro. Or just redraw the border when you add records. "Kycajun" wrote: I am needing to set a page border in excel. If I just draw a border around the whole page, it works, until I have to go back and insert a record later. Obviously it moves everything down, including the drawn border. What I need is to basically have a permanent border around a set print area. Can this be done? I have searched this topic and it has been asked, but not clearly answered. I know you geniuses know the answer!!! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
On Exit, always asked to save | Excel Worksheet Functions | |||
Help window will open when asked, but no text. Why? | Excel Discussion (Misc queries) | |||
I bet this has been asked before | Excel Discussion (Misc queries) | |||
An FAQ that never seems to be answered: autofiltering with protection on... | Excel Worksheet Functions | |||
How to link cells so that if one is not answered then the other cannot be filled in | Excel Worksheet Functions |