flow columns on one page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shari@officeformac.com - 29 Apr 2008 16:37 GMT

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

I have a lot of data to enter with just two columns. I want to lay the page out so that I can get as much info as possible on one page. I would like to flow info from one column to the next, side by side, on one 8-1/2 x 11 page. How can I do this so that the columns continue up to the next column on the same page and not down to a new page?

Reply to this Message

JE McGimpsey - 29 Apr 2008 17:00 GMT

> Version: 2008
> Operating System: Mac OS X 10.4 (Tiger)
[quoted text clipped - 5 lines]
> How can I do this so that the columns continue up to the next column on the
> same page and not down to a new page?

One way:

http://www.rondebruin.nl/print.htm#non-contiguous

(use the Excel 97-2003 method)

Otherwise, you can use another sheet and enter something like:

A1: =INDEX(Sheet1!$A:$B,INT((COLUMN()-1)/2)*x+ROW(),2-MOD(COLUMN(),2))

where 'x' is the number of rows to print. Copy down 'x' rows, and across
as far as needed.

Reply to this Message

Mac Forum / Applications / Excel / April 2008

flow columns on one page