print views
 

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.

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.

print views
 

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.

print views
 

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.

print views
 

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.

print views
 

Custom Views allows many views to be created and named but only one can
visible at a time.

You must use autofilter or some othe means to create the view you want then
save that view with a name.

Do many times if you have many views.

The Report.xla add-in for older versions was just the ticket for printing
reports using custom views.

Don't know if it is still available for 2007 if that's the Excel version
you're using.


Gord

On Tue, 23 Sep 2008 10:36:17 -0700, coffee gal
wrote:

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.

print views
 

I finally got this to work. I added a column and put a "A", "B","C" in it
depending on the view I wanted to see. Then used autofilter to filter for
either A,B or C. Then I hid that column and set up my views and printed it
that way. My boss swears that this used to be much simpler by just
specifying a range for printing ie A1:H8 and giving it a name, then A9:H16
etc.

Thanks for all your help Gord.

"Gord Dibben" wrote:

Custom Views allows many views to be created and named but only one can
visible at a time.

You must use autofilter or some othe means to create the view you want then
save that view with a name.

Do many times if you have many views.

The Report.xla add-in for older versions was just the ticket for printing
reports using custom views.

Don't know if it is still available for 2007 if that's the Excel version
you're using.


Gord

On Tue, 23 Sep 2008 10:36:17 -0700, coffee gal
wrote:

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.

print views
 

Your boss is correct..............maddening, eh?

Giving ranges names like A1:H8 and A9:H16 should still work without custom
views.

After the names are defined select a name from the namebox and
FilePrintPrint Selection.


Gord

On Tue, 23 Sep 2008 15:22:01 -0700, coffee gal
wrote:

I finally got this to work. I added a column and put a "A", "B","C" in it
depending on the view I wanted to see. Then used autofilter to filter for
either A,B or C. Then I hid that column and set up my views and printed it
that way. My boss swears that this used to be much simpler by just
specifying a range for printing ie A1:H8 and giving it a name, then A9:H16
etc.

Thanks for all your help Gord.

"Gord Dibben" wrote:

Custom Views allows many views to be created and named but only one can
visible at a time.

You must use autofilter or some othe means to create the view you want then
save that view with a name.

Do many times if you have many views.

The Report.xla add-in for older versions was just the ticket for printing
reports using custom views.

Don't know if it is still available for 2007 if that's the Excel version
you're using.


Gord

On Tue, 23 Sep 2008 10:36:17 -0700, coffee gal
wrote:

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.