flow columns on one page

S

Shari

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?
 
J

JE McGimpsey

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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top