Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

Northendzone · 10-15-2010, 08:34 PM

does anyone know if you can create several named ranges in excel, and then tell excel to print each names range in that order. for example:

Sheet 1 has the named ranges red, blue and green
sheet 2 has the named ranges red1, blue1 and green1
sheet 3 has the named ranges red2, blue2, and green2

i like to print the ranges red, red1, red2, blue, blue1, blue2, green, green1 and then green2 - i am actually trying to print this worksheet to a pdf file.

do to the layout of each worksheet, i cant move all the raanges to reside on one worksheet and then change the print order to across, then down.

i can manipulate the order of the worksehets in adobe - that that is a painful process......

i miss the simplcity of lotus 1-2-3........

10-15-2010, 08:34 PM	#1
Northendzone Franchise Player Join Date: Aug 2009 Exp:	Another Excel Question does anyone know if you can create several named ranges in excel, and then tell excel to print each names range in that order. for example: Sheet 1 has the named ranges red, blue and green sheet 2 has the named ranges red1, blue1 and green1 sheet 3 has the named ranges red2, blue2, and green2 i like to print the ranges red, red1, red2, blue, blue1, blue2, green, green1 and then green2 - i am actually trying to print this worksheet to a pdf file. do to the layout of each worksheet, i cant move all the raanges to reside on one worksheet and then change the print order to across, then down. i can manipulate the order of the worksehets in adobe - that that is a painful process...... i miss the simplcity of lotus 1-2-3........