View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Printing Selected Sheet Tabs

Group the tabs that you want to print.

Hold <Ctrl and click on each tab you wish to print before you click on
<Print.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"billbrandi" wrote in message
...
Is there a way to select which sheet tabs to print in a workbook when
selecting the "print entire workbook" option? I have a workbook with tabs
that I would like to print; others that are used for reference only. I

would
like to print certain tabs without printing them one at a time (my

workbook
has over 30 sheet tabs that I want to print with an equal number of others
that I do not want to print).

Thanks