Printing Multiple Columns in Excel

[mep1]

Hi,
I am trying to print columns A, B, and C from an Excel spreadsheet. I would like to add two "columns" to the printout so that the first 25 rows are on one side of the printout and the next 25 rows are on the other side of the printout. Similar to Tools->Columns in Word. Thanks for the help.

MEP

 

[SkipVought]

MEP,

You can select the print area in menu item File/Print Area/Set print area

You can set page breaks in menu item Insert/Pagebreak.. Using the View/Page Break Mode is handy -- you can drag page breaks.



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[mep1]

Skip,
I have ~500 cells in each column and ~25 worksheets. I don't want to manually create the columns. Is there an easier way to have the columns loop.

Eric

 

[SkipVought]

What's magic about 25 rows?

I'd macro record setting up one sheet the way I want it to print and use that macro on each sheet.



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[mep1]

Skip,
Thanks for the help. I have ~25 sheets, not rows. And each sheet has a different number of rows. I think I will have to write a macro.

Eric

 

[SkipVought]

I guess I do not understand your requirement. It sounds pretty straight forward???

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[KenWright]

You might want to take a look at Dave McRitchie's SnakeCols routine, though it will need some editing:-

http://www.mvps.org/dmcritchie/excel/snakecol.htm

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------