Displaying long lists on one page

Feb 27th, 2002, 06:18 PM

I have a list of hundreds of names/phone numbers (2 columns wide). I would like to display these entries on a few sheets of paper. Not just fitting the data to page. When columns reach the bottom of the page, is it possible to wrap the data so it displays the next block of data to the right of the previous column. You know, kinda like columns in a word processor? Rather not print multiple pages with only 2 columns on each page. Thanks!

Mark W. · Feb 27th, 2002, 06:24 PM

ASAP Utilities freeware add-in supports this request using its Format | Paper saver... menu command. See http://www.asap-utilities.com.

[ This Message was edited by: Mark W. on 2002-02-27 17:26 ]

Anne Troy · Feb 28th, 2002, 04:05 AM

You can create a multiple-column layout in Word and copy/paste your cells there. It'll do it automatically as a Word table.

Feb 28th, 2002, 04:05 AM	#3
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	You can create a multiple-column layout in Word and copy/paste your cells there. It'll do it automatically as a Word table. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 06:18 PM	#1
Guest Posts: n/a	I have a list of hundreds of names/phone numbers (2 columns wide). I would like to display these entries on a few sheets of paper. Not just fitting the data to page. When columns reach the bottom of the page, is it possible to wrap the data so it displays the next block of data to the right of the previous column. You know, kinda like columns in a word processor? Rather not print multiple pages with only 2 columns on each page. Thanks!

Feb 27th, 2002, 06:24 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	ASAP Utilities freeware add-in supports this request using its Format \| Paper saver... menu command. See http://www.asap-utilities.com. [ This Message was edited by: Mark W. on 2002-02-27 17:26 ]