Printing frames in excel

  • Thread starter Thread starter steven_flax
  • Start date Start date
S

steven_flax

How do I automotically print Excel worksheets with a frame /borde
around them
 
I don't think that this is built into excel.

But a lot (a few???) printers can print borders (as well as watermarks). You
may want to check your printer to see if that's built in.

If it's not you could add borders to each sheet.

I would think the easiest way would be to:
View|Page Break Preview
(reduce the zoom factor--big enough to see, but small enough to see lots)

Then select the range on each page and format|cells|border tab|Outline.

Remember if you add/delete rows (or anything that will change the page
layout--like increasing the rowheight), you may have to redo your borders.

======

How about another option: Use MSWord to print a bunch of sheets with just the
borders. Then adjust your margins in excel to stay away from those borders and
just print on to the sheets of preprinted forms.

(That sounds lots easier to me--if your printer doesn't support it.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top