how page setup pages wide by works?

guest · May 2nd, 2002, 10:44 AM

Hi I have a report when it spans 20 pages and fit to 1 pages wide by 100 pages fits perfectly and print preview looks nice at 74% but when my report has 15000+ lines it shows the report by 10% level how to adjust it so as it always prints at 74% invariably of the length of report.

Anne Troy · May 2nd, 2002, 11:14 AM

In the Fit to 1 wide by X tall:

Delete the number in the tall and leave it blank.

guest · May 3rd, 2002, 10:11 AM

Thanks !!!
That works great.

May 2nd, 2002, 11:14 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	In the Fit to 1 wide by X tall: Delete the number in the tall and leave it blank. __________________ ~Anne Troy

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

May 2nd, 2002, 10:44 AM	#1
guest Board Regular Join Date: Feb 2002 Posts: 91	Hi I have a report when it spans 20 pages and fit to 1 pages wide by 100 pages fits perfectly and print preview looks nice at 74% but when my report has 15000+ lines it shows the report by 10% level how to adjust it so as it always prints at 74% invariably of the length of report.

May 3rd, 2002, 10:11 AM	#3
guest Board Regular Join Date: Feb 2002 Posts: 91	Thanks !!! That works great.