Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Step-by-step fit to page
Hi I'm an english-only speaker unfortunately forced to use a russian version
of excel right now. The problem is that I have a lovely spreadsheet all ready to go, but it is not very tall (i.e. low in rows) and quite wide (i.e. high in columns). Solution: print it on two pages and then fix them together. so far so good. However, having arranged the sheet over two pages in print preview mode, its only printing out on the top left corner of each of the two printed pages. destroys the effect of having on two pages. Help! how can I tell excel to fit each half of the sheet to its respective page? I need step-by-step, idiot-proof instructions (e.g. third menu from the left, second option down etc.) Thanks. A. |
#2
|
|||
|
|||
Making two pages print on one page is a printer function not an Excel function to do it in Excel I feel your best bet is to set up a print only sheet if for example your main sheet has 16 columns and 4 rows on the print sheet in A1 enter =main!A1 and copy to H4 in A6 enter =main!I1 and copy to P9 "AAAA" wrote: Hi I'm an english-only speaker unfortunately forced to use a russian version of excel right now. The problem is that I have a lovely spreadsheet all ready to go, but it is not very tall (i.e. low in rows) and quite wide (i.e. high in columns). Solution: print it on two pages and then fix them together. so far so good. However, having arranged the sheet over two pages in print preview mode, its only printing out on the top left corner of each of the two printed pages. destroys the effect of having on two pages. Help! how can I tell excel to fit each half of the sheet to its respective page? I need step-by-step, idiot-proof instructions (e.g. third menu from the left, second option down etc.) Thanks. A. |
#3
|
|||
|
|||
A,
What you're describing sounds like two printouts (you've put 2 in the "Copies" box), and you're not using the "Next" button in print preview to see the next page. Have you actually printed it, or just looked in Preview? Note that "Page" refers to a printed page, and "sheet" refers to the entire sheet. I have no idea what that is in Russian. Also, check that the Print Area is cleared -- that could prevent part of the sheet from printing. -- Earl Kiosterud www.smokeylake.com "AAAA" wrote in message ... Hi I'm an english-only speaker unfortunately forced to use a russian version of excel right now. The problem is that I have a lovely spreadsheet all ready to go, but it is not very tall (i.e. low in rows) and quite wide (i.e. high in columns). Solution: print it on two pages and then fix them together. so far so good. However, having arranged the sheet over two pages in print preview mode, its only printing out on the top left corner of each of the two printed pages. destroys the effect of having on two pages. Help! how can I tell excel to fit each half of the sheet to its respective page? I need step-by-step, idiot-proof instructions (e.g. third menu from the left, second option down etc.) Thanks. A. |
#4
|
|||
|
|||
Can you use Page setup - Page - Fit to 2 pages wide by 1 page tall? You can go to Page Break Preview to adjust them as you like after. AAAA Wrote: Hi I'm an english-only speaker unfortunately forced to use a russian version of excel right now. The problem is that I have a lovely spreadsheet all ready to go, but it is not very tall (i.e. low in rows) and quite wide (i.e. high in columns). Solution: print it on two pages and then fix them together. so far so good. However, having arranged the sheet over two pages in print preview mode, its only printing out on the top left corner of each of the two printed pages. destroys the effect of having on two pages. Help! how can I tell excel to fit each half of the sheet to its respective page? I need step-by-step, idiot-proof instructions (e.g. third menu from the left, second option down etc.) Thanks. A. -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=389323 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page scaling & Page break preview prob | Excel Discussion (Misc queries) | |||
Can't delete a page break | Excel Discussion (Misc queries) | |||
Auto page numbering for several worksheets | Excel Worksheet Functions | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
excel 2003 page numbering | Excel Worksheet Functions |