Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing 3 or more sheets into 1 page
Hi,
I have a problem trying to get a 3 page spreadsheet to merge into one spread sheet and have it still fit everything on it. Also still have it readable. I have tried the fit to page option. Though everything is there I can't read it properly. It's too small, when I try to keep the size to 100% it goes back to 3 pages instead of 1 page. When it prints, it does not completely fit the page. it leaves 75% of the page free. Why having a small version of the spreadsheet in the other 25%. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing 3 or more sheets into 1 page
Excel does not provide the facility you are looking for.
You option is to run a macro, an add-in, or Copy to MS Word and print from Word (DO NOT OPEN an Excel spreadsheet from Word). Take a look at Snake Columns to save Paper http://www.mvps.org/dmcritchie/excel/snakecol.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dijiman" wrote in - I have a problem trying to get a 3 page spreadsheet to merge into one spread sheet and have it still fit everything on it. Also still have it readable. I have tried the fit to page option. Though everything is there I can't read it properly. It's too small, when I try to keep the size to 100% it goes back to 3 pages instead of 1 page. When it prints, it does not completely fit the page. it leaves 75% of the page free. Why having a small version of the spreadsheet in the other 25%. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing 3 or more sheets into 1 page
assume your data goes to row 150
in the name box put in 151:65536 and hit enter then do Edit=Delete Now save the worksheet. Now check print preview (with fit to 1 by 1) and see if you get better results. An alternative would be to select just you data and do File=Print Area = Set Print Area. then do print preview ( print) with the fit to 1 page set. -- Regards, Tom Ogilvy "Dijiman" wrote in message ... Hi, I have a problem trying to get a 3 page spreadsheet to merge into one spread sheet and have it still fit everything on it. Also still have it readable. I have tried the fit to page option. Though everything is there I can't read it properly. It's too small, when I try to keep the size to 100% it goes back to 3 pages instead of 1 page. When it prints, it does not completely fit the page. it leaves 75% of the page free. Why having a small version of the spreadsheet in the other 25%. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing sheets with page numbers | Excel Discussion (Misc queries) | |||
printing page # on sheets | Excel Worksheet Functions | |||
Page numbers when printing multiple sheets | Excel Discussion (Misc queries) | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Printing 2 sheets on 1 page | Excel Discussion (Misc queries) |