Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / April 2007

Tip: Looking for answers? Try searching our database.

Worksheet printing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Laura - 19 Apr 2007 16:32 GMT
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
E Savard - 19 Apr 2007 17:14 GMT
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.

> 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
E Savard - 19 Apr 2007 17:40 GMT
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

> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.