Printing w/o text boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to set up individual sheets to print without the text boxes
included? We have instructions that we would like not to print.
 
Select the area(s) you do want to print and then go File>Print Area>Set Print
Area when you save this information will remain with the file.
 
Select your text boxes. If you have lots & lots of them, you can do this
quickly by pressing the F5 key, clicking on the Special button, and selecting
'Objects' from the dialog box. This will select ALL objects, not just text
boxes, so be careful. The next step will cause all selected objects to not
print.

One they're sleected, right click ON THE BORDER of one of the text boxes to
bring up a menu. Choose Format Text Box then, on the Property tab, uncheck
the Print Object box

Duke
 
You must log in or register to reply here.

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

Similar Threads

Print Area to include text box 10
Print selected worksheets in multiple workbooks? 1
I can not get a text box to print. 2
Text Box Issues for 2003 vs. 2007 1
Text Box Not Same Width on Screen As When Print 3
White text prints as black 3
Excel Move or Copy Stopped Working? 0
Printing Sheets in a Workbook 3

Back
Top