Hello,
MS Excel 2003 on XP PRo.

I have an excel document that has several tabs. Printing all (or a subset)
of those tabs forms a single handout. I would like to rig it so that they
are all page numbered, but with the same order.

Tab A has 3 pages, B has 5 and C has 6

Instead of numbering them A-1, A-2, A3, B-1, B-2, B-3, etc
I would like to number them 1,2,3,4,5,6,7,8,9,10,11,12,13,14 etc.

I don't want to use Acrobat and combine files, and I am hoping this can be
done without VBA.

Thank you
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!

Select the sheets to print by CTRL + point or SHIFT + point

FilePage SetupHeaders/Footers

From the built-ins select Page 1 or Page 1 of ?


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 09:35:04 -0700, BlueWolverine
wrote:

Hello,
MS Excel 2003 on XP PRo.

I have an excel document that has several tabs. Printing all (or a subset)
of those tabs forms a single handout. I would like to rig it so that they
are all page numbered, but with the same order.

Tab A has 3 pages, B has 5 and C has 6

Instead of numbering them A-1, A-2, A3, B-1, B-2, B-3, etc
I would like to number them 1,2,3,4,5,6,7,8,9,10,11,12,13,14 etc.

I don't want to use Acrobat and combine files, and I am hoping this can be
done without VBA.

Thank you

Do you need to right click "Select all sheets"? A coworker found a way to do
this and I wanted to see if there is another way...

Thank you though.
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!


"Gord Dibben" wrote:

Select the sheets to print by CTRL + point or SHIFT + point

FilePage SetupHeaders/Footers

From the built-ins select Page 1 or Page 1 of ?


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 09:35:04 -0700, BlueWolverine
wrote:

Hello,
MS Excel 2003 on XP PRo.

I have an excel document that has several tabs. Printing all (or a subset)
of those tabs forms a single handout. I would like to rig it so that they
are all page numbered, but with the same order.

Tab A has 3 pages, B has 5 and C has 6

Instead of numbering them A-1, A-2, A3, B-1, B-2, B-3, etc
I would like to number them 1,2,3,4,5,6,7,8,9,10,11,12,13,14 etc.

I don't want to use Acrobat and combine files, and I am hoping this can be
done without VBA.

Thank you

That's the best way to select "all sheets".

You could also select first sheet then hold SHIFT and click on last sheet.

For non-contiguous sheets use CTRL + click

I stated CTRL + point and SHIFT + point in my first reply.

Maybe you did not understand "point"


Gord

On Tue, 8 Jul 2008 10:50:04 -0700, BlueWolverine
wrote:

Do you need to right click "Select all sheets"? A coworker found a way to do
this and I wanted to see if there is another way...

Thank you though.