A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Printing a worksheet in two (or more) columns



 
 
Thread Tools Display Modes
  #1  
Old March 30th, 2010, 11:45 PM posted to microsoft.public.excel.misc
OftenConfuddled
external usenet poster
 
Posts: 2
Default Printing a worksheet in two (or more) columns

Hi,

I've got an extremely long spreadsheet table comprising two columns of data.

I'd like to print these data in a more compact form - in the same way that
the entries are organised in a telephone directory.

Say on average my page is 50 rows high - my first two columns on page 1
would appear on the left hand side and be rows 1 through 50, row 51 would
continue at the top of the page, but on the right-hand side. Row 101 would
appear at the top left hand side of page 2, etc.

I'd like to keep the orientation of the columns in portrait (I did find a
printer-associated setting that did print the two sets of two columns
side-by-side, but the overall page was in landscape).

I have tried manual repagination...but it's VERY slow, laborious, prone to
error, and if you make any changes (e.g. font size, column width, header
footer size, margins) everything immediately gets all out of
kilter/whack/alignment.

Can anyone please help?

Thanks and Best Regards
  #2  
Old March 31st, 2010, 02:34 AM posted to microsoft.public.excel.misc
Jim Cone[_2_]
external usenet poster
 
Posts: 434
Default Printing a worksheet in two (or more) columns


There is no built-in way to do that in Excel.
You have to paste the data into Word and use Format | Columns
-or -

Build your own method with VBA code...
http://www.mvps.org/dmcritchie/excel....htm#snakecols
-or -

Try my commercial "Special Print" Excel add-in with its "Side by Side" utility.
(free three week trial)
It creates 2, 3 or 4 up column groupings across the worksheet page (from single or multiple columns)
and maintains data continuity across all pages and accounts for any header area.
A new sheet with the column arrangement is created, your original data is not affected.
Just email and ask for it.
Remove XXX from my email address... james.coneXXX at comcast.netXXX
Please include your real name and geographic area.
--
Jim Cone
Portland, Oregon USA
(Special Sort... http://www.contextures.com/excel-sort-addin.html)




"OftenConfuddled"
wrote in message ...
Hi,
I've got an extremely long spreadsheet table comprising two columns of data.

I'd like to print these data in a more compact form - in the same way that
the entries are organised in a telephone directory.

Say on average my page is 50 rows high - my first two columns on page 1
would appear on the left hand side and be rows 1 through 50, row 51 would
continue at the top of the page, but on the right-hand side. Row 101 would
appear at the top left hand side of page 2, etc.

I'd like to keep the orientation of the columns in portrait (I did find a
printer-associated setting that did print the two sets of two columns
side-by-side, but the overall page was in landscape).

I have tried manual repagination...but it's VERY slow, laborious, prone to
error, and if you make any changes (e.g. font size, column width, header
footer size, margins) everything immediately gets all out of
kilter/whack/alignment.

Can anyone please help?
Thanks and Best Regards
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.