Gord,

I only used the "year" as an example. This is a complicated sheet and it's
not as easy as just selecting the year. I thought I could use Custom Views
but I can only get one view at a time to work. Is there a trick to get
multiple views using Custom Views? If so, could you please walk me through
it? Thanks so much.

"Gord Dibben" wrote:

Don't put the data on separate sheets. You will regret it later.

Just use Autofilter to select the year to print.

Note: you can always set up different views using ViewCustom Views


Gord Dibben MS Excel MVP

On Tue, 23 Sep 2008 08:58:05 -0700, coffee gal
wrote:

Thanks FloMM2,
But what if the data was all on one sheet, would there be a way to do this?

"FloMM2" wrote:

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.