Visually Turning a Row into Columns for Printing in Excel 1

[Guest_imported]

I have an excel worksheet that has 11,000 rows. If I printed it, it would be almost 300 pages in length. How can I get excel to print in a wrapping format so that it takes pieces of the row and prints it in a columnar format? Thanks.

 

[Hasit]

Not sure I understand the question, but take a look at this FAQ, which might give you some ideas: faq68-1161

 

[Guest_imported]

Thanks. I did read the tek-tip you referenced but I'm not sure it will save me much time. Basically what I want to do is this:

I have an excel worksheet that has 11,000 rows. If I printed it, it would be almost 300 pages in length. How can I get excel to print in a "wrapping format" so that it takes "sections" of the row and prints it in a columnar format? Here is a small example:

CPT Code
10000
11000
12000
13000
14000
15000

Instead of continuing to print down, how can I print like this:

CPT Code CPT Code
10000 13000
11000 14000
12000 15000

 

[dianemarie]

I don't think Excel does that. For a work-around, copy the column(s)into Word and set your document up as Columns. (Format-Columns). If you make your margins .25 all the way around, you can get at least 5-6 columns on one page, depending on how many Excel columns you are bringing over. It will paste as a table, unless you Paste Special as unformatted text, but that's OK. It still works fine.

 

[Dreamboat]

Actually, you can open the Excel file right into Word (no copy/paste required, but you'll want to save it as a Word file right away), then Format-columns as dianemarie describes. Excel files open right up from Word as tables. You'll probably want to choose landscape too.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[Guest_imported]

To dianemarie and Dreamboat:

THANK YOU! This is a fabulous workaround to solve my problem. Thanks so much for taking the time to read and respond.

 

[Dreamboat]

Let's give DianeMarie a star!

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[lode]

Hi,

I think with a little VBA-code the problem can be solved without going to Word.
But it might take some thinking.
Do you want me to do that or are you happy with the first solution ??