Thread: print views
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
FloMM2 FloMM2 is offline
external usenet poster
 
Posts: 207
Default print views

coffee gal,
In a word, yes.
The easiest way for me is as follows:
Put each year on a separate sheet in the same workbook.
Then label each sheet as a year(i.e., 2008, 2009,...)

If you want to print multiple years, select a worksheet, hold the Ctrl key
and select another worksheet. Then select file, print selected worksheets.
hth
:-)


"coffee gal" wrote:

I have a spreadsheet with info for multiple years. Is there a way to set it
up so that I can print each year independently without having to highlight
that particular section each time I need to print it? Thanks.