Cut spreadsheet

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

Hey there

I have a spread sheet document that when I print it off
only takes up half a page. I have another chunk I could
add onto it. They guy wants it to look like two seperate
spreadsheets but to print on one page. What I want to do
is basically insert a break line and create a new spread
sheet under that, but in the same document.
 
I have a spread sheet document that when I print it off
only takes up half a page. I have another chunk I could
add onto it. They guy wants it to look like two seperate
spreadsheets but to print on one page. What I want to do
is basically insert a break line and create a new spread
sheet under that, but in the same document.
Click to expand...

Are the column widths the same for the two sheets? Or can they be made to
be? If so, it's easier. For example, if Sheet1 is empty starting in row 20,
you can put the following in A21:
=IF(Sheet2!A1="","",Sheet2!A1)
Then extend to the right for as many columns as you need. Then extend that
row down for as many rows as you need. (The "IF" is to make sure empty
cells don't get interpreted as zero.)

If the column widths are different, you might try starting with two Excel
files, then using
Insert > Object > Create from file
To embed the second in the first.

To get the break line either way, you can select row 20 and use:
Format > Cells > Border
 
Back
Top