Worksheet printing

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

Guest

How can I prevent 3 tabs of a 6 tab workbook from being printed automatically
if someone clicks on print workbook - they are refernece tabs only which
shoudl never be printed.

Thanks
 
highlight only the cells you wish to have printed, then go to the file
menu>print settings>set print area, then save your file again with those new
settings. This should set it for every time the document gets opened.
 
Sorry I misread your question, to get the sheets you want to print, click on
the first sheet, then if it is the first three sheets, just hold the shift
key down and select the first 3 sheets, if the sheets are not directly beside
each other, hold down the ctrl key and choose the sheets you wish to print,
in the print preview window you can make sure you have what you want before
you print 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