I have an Excel document that has 5 columns and 336 rows that ends up
being 30+ pages when printed. However, I only need to print column A.
Is there a way that I can print column A without being on the 30+ pages
by having all of the column A's stack next to one another on the same
page. I realize I will only get 7-8 'column A's' on the same page, but
8 or so pages is better than 30+. Said another way is it possible for
me to...

- move column A from page 2 into column B on page 1
- move column A from page 3 into column C on page 1
...and so on

I do realize this can be accomplished by copying and pasting; but I
can't imagine I am the first person that has ever needed to do this. I
am looking for a more automated way to accomplish this.

Thank you,
TheoryThree


--
theorythree
------------------------------------------------------------------------
theorythree's Profile: http://www.excelforum.com/member.php...o&userid=24607
View this thread: http://www.excelforum.com/showthread...hreadid=381936

AFAIK the only other option to copy & paste is to create formulas in another
location that refer to the respective sections of column A & set that as your
print area. Probably just as much trouble, though.

Regards |:)

"theorythree" wrote:


I have an Excel document that has 5 columns and 336 rows that ends up
being 30+ pages when printed. However, I only need to print column A.
Is there a way that I can print column A without being on the 30+ pages
by having all of the column A's stack next to one another on the same
page. I realize I will only get 7-8 'column A's' on the same page, but
8 or so pages is better than 30+. Said another way is it possible for
me to...

- move column A from page 2 into column B on page 1
- move column A from page 3 into column C on page 1
...and so on

I do realize this can be accomplished by copying and pasting; but I
can't imagine I am the first person that has ever needed to do this. I
am looking for a more automated way to accomplish this.

Thank you,
TheoryThree


--
theorythree
------------------------------------------------------------------------
theorythree's Profile: http://www.excelforum.com/member.php...o&userid=24607
View this thread: http://www.excelforum.com/showthread...hreadid=381936

Can you copy column A and paste into MSWord.

You can use format|columns to make it look pretty.

theorythree wrote:

I have an Excel document that has 5 columns and 336 rows that ends up
being 30+ pages when printed. However, I only need to print column A.
Is there a way that I can print column A without being on the 30+ pages
by having all of the column A's stack next to one another on the same
page. I realize I will only get 7-8 'column A's' on the same page, but
8 or so pages is better than 30+. Said another way is it possible for
me to...

- move column A from page 2 into column B on page 1
- move column A from page 3 into column C on page 1
..and so on

I do realize this can be accomplished by copying and pasting; but I
can't imagine I am the first person that has ever needed to do this. I
am looking for a more automated way to accomplish this.

Thank you,
TheoryThree

--
theorythree
------------------------------------------------------------------------
theorythree's Profile: http://www.excelforum.com/member.php...o&userid=24607
View this thread: http://www.excelforum.com/showthread...hreadid=381936

--

Dave Peterson