Printing Long Narrow Excel Worksheets

**Bertie Byker** · 06-01-2007, 05:58 AM

I often need to print an Excel worksheet many rows (a few hundred) long but only a few (2 or 3) columns wide. Is it possible to print the "pages" side by side on one sheet of paper?

Same applies to very wide but short sheets - can they be printed below one another on the same sheet?

**oldchippy** · 06-01-2007, 10:17 AM

Take a look at previous link

http://www.excelforum.com/showthread...63#post1781263

**Bertie Byker** · 06-05-2007, 06:22 AM

Originally Posted by oldchippy

Take a look at previous link

http://www.excelforum.com/showthread...63#post1781263

Thanks for the response, but I fail to see how the Offset function is of use in solving my problem.

B

**oldchippy** · 06-05-2007, 07:04 AM

Hi Bertie,

Take a look here there are some interesting options, by try the one using Word, that seems to work.

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