Worksheet printing

Can I set sections in a worksheet? I have a Job Record to keep track of all
labor / equipment and materials per Job in worksheets.

The problem I am having is when I print the worksheet I print the entire
worksheet, sometimes 5-6 pages and really only have data I need on 2 of them.
I know I can set print areas, but it is not always the same areas I need, and
I have to set that every time I print.

I guess what I am trying to do is make sections - and just print that
section if possible. Or if there is any other suggestions, that would be
great as well.

Any other suggestions for different Job records in excel (Templates) are
always good too!!!

Thanks;

Maybe develop a macro that hides the rows you do NOT want to print.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tb" wrote in message
...
Can I set sections in a worksheet? I have a Job Record to keep track of
all
labor / equipment and materials per Job in worksheets.

The problem I am having is when I print the worksheet I print the entire
worksheet, sometimes 5-6 pages and really only have data I need on 2 of
them.
I know I can set print areas, but it is not always the same areas I need,
and
I have to set that every time I print.

I guess what I am trying to do is make sections - and just print that
section if possible. Or if there is any other suggestions, that would be
great as well.

Any other suggestions for different Job records in excel (Templates) are
always good too!!!

Thanks;

Check out Custom Views in help.


Gord Dibben MS Excel MVP

On Wed, 24 Feb 2010 10:44:01 -0800, tb wrote:

Can I set sections in a worksheet? I have a Job Record to keep track of all
labor / equipment and materials per Job in worksheets.

The problem I am having is when I print the worksheet I print the entire
worksheet, sometimes 5-6 pages and really only have data I need on 2 of them.
I know I can set print areas, but it is not always the same areas I need, and
I have to set that every time I print.

I guess what I am trying to do is make sections - and just print that
section if possible. Or if there is any other suggestions, that would be
great as well.

Any other suggestions for different Job records in excel (Templates) are
always good too!!!

Thanks;