Attaching print area to a drawing object

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Hello, I have created a border in Excel using the drawing
toolbar. Now, I want the border to stay in place when rows
& columns are adjusted, which it does. However, I also
want Excel to always ONLY print the extents of that
border, as opposed to the cells to which the print area is
applied. So is there a way to tell Excel to print just the
border and everything inside of it? I guess I'm asking, is
it possible to attach a print area to a drawing object,
and, if so, can you lock the print area to that object?
Thanks!!!!!
 
use a defined name to determine your print area
insert>name>define
myprintarea
in the refers to:
=offset($a$1,0,0,counta($a:$a),4)
will do $a$1:$d$whaterver row
 
I'm sorry, but I don't follow. How does that attach the
print area to a drawing object, not a range of cells? I
need to attach it to a drawing object. Or is there a way
to tell it to print a range of pixels or something like
that?
 
Back
Top