Keri
You can't print two worksheets on one page. You have to put the two
tables on one sheet by creating pictures of the tables first. Here is a
write-up I have on this subject from several people in these newsgroups.
HTH Otto
'From Jim Rech:
'Excel ejects the page after each print area. The only solution I know of
is to paste
'pictures of each print area on to a third sheet and print that. To copy a
picture of a
'range to the clipboard, select the range, hold Shift down and select Edit,
Copy Picture.
'Than switch to the print sheet and do a Ctrl-v. Another way is to do a
normal Copy and
'then a Shift-down, Edit, Paste Picture. Yet another way is the Camera
toolbutton, if you
'can find it. That's for babies who can't hold shift down and click a menu
at the same
'time<g>.
'
'Another response:
'one approach:
'-Create a new sheet
'-Copy Table 1
'-On the new sheet, hold down shift while invoking Edit>PastePictureLink on
'the main menu.
'-Copy Table 2
'-On the new sheet, hold down shift while invoking Edit>PastePictureLink on
'the main menu.
'NOTE: holding down shift is critical. PastePictureLink won't appear as an
'option otherwise.
'
'You now have pictures of the 2 tables on a single sheet. Any changes to the
'original tables (cell contents OR formatting) will be reflected on the
'pictures because they are linked.
'
'Since you are dealing with pictures that "float" on top of your new
'worksheet, matching column widths is a non-issue (other than a potential
'aesthetic one). You will probably need to play around with formatting to
'get a satisfactory combination (i.e., gridlines on/off vs. borders, format
'the pictures to have a fill, etc.), but once you do, you only have to keep
'the original tables updated and your "combo page" is automatically ready to
'print.
'
'Hope this helps,
Keri said:
Thanks, Mark. How about printing two worksheets on one page? Would I be
able to create my varying tables in two sheets, then just print them
together?
TIA (just figured that one out),
Keri
----- Mark Graesser wrote: -----
Keri,
Your ouot of luck on this. Every cell in a column has the same width
and every cell in a row has the same height. You could use cell merging but
this usually presents many more headaches then it solves.
Good Luck,
Mark Graesser
(e-mail address removed)
----- Keri wrote: -----
I am creating short, wide tables (landscape shape.) Two could
fit on one sheet, except that the column widths are to be different. Does
anyone know how to do some sort of "format break" between tables in a sheet,
so that I can start fresh with standard column widths? Thank you.
