spreading items across the page

kerrysr · Mar 8th, 2002, 11:12 AM

If I have several hundred items and rather than print many pages with say 40 items per page, how can I get excel to take the next 40 items and bring it to the top of the 1st page spread sheet and across so that it "fills" the printed page. In other words you have 3 columns of items 1-40 top to bottom and then another 40 items to the right of the 1st 40 items so that you utilize the enitire page?

Mark W. · Mar 8th, 2002, 11:25 AM

Get the ASAP Utilities free add-in at www.asap-utilities.com

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

Mar 8th, 2002, 11:12 AM	#1
kerrysr New Member Join Date: Mar 2002 Posts: 11	If I have several hundred items and rather than print many pages with say 40 items per page, how can I get excel to take the next 40 items and bring it to the top of the 1st page spread sheet and across so that it "fills" the printed page. In other words you have 3 columns of items 1-40 top to bottom and then another 40 items to the right of the 1st 40 items so that you utilize the enitire page?

Mar 8th, 2002, 11:25 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Get the ASAP Utilities free add-in at www.asap-utilities.com