Creating 9x6 Word2003 book. Need excel worksheet placed sideways into that
page size.

Bob was telling us:
Bob nous racontait que :

Creating 9x6 Word2003 book. Need excel worksheet placed sideways
into that page size.

....and with which part of the process are you having difficulties?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

Unable to rotate text box in Word2003. Copy and Paste into Word with data
only creates a page that overflows to right, and is unreadable. Rotate
unavailable in Word, if text box and linked boxes created. Was able to
create text boxes with links, re-oriented text [bottom-up], but pasting data
removed all formatting, and spreadsheet header data.

"Jean-Guy Marcil" wrote:

Bob was telling us:
Bob nous racontait que :

Creating 9x6 Word2003 book. Need excel worksheet placed sideways
into that page size.

....and with which part of the process are you having difficulties?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

Bob was telling us:
Bob nous racontait que :

Unable to rotate text box in Word2003. Copy and Paste into Word with
data only creates a page that overflows to right, and is unreadable.
Rotate unavailable in Word, if text box and linked boxes created.
Was able to create text boxes with links, re-oriented text
[bottom-up], but pasting data removed all formatting, and spreadsheet
header data.

If you paste data from Excel, you need to use Paste Special from the Edit
menu.
Then, if you do not need a linked object, use any of the Picture format, if
you need a linked object, use the Bitmap format. Finally, make sure that the
pasted object is not inline with the text and then you will be able to
rotate it.

If all this is too much trouble, why not create a page that is 6x9 instead
of 9x6?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

Okay - Paste Special, using picture format = That works, but very small type,
and header is lost. Paste places whole spreadsheet, which is really 3 pages
long onto one page, very small type (maybe 4). Rotating works, but font size
does not change, and last 2 pages off page.



"Jean-Guy Marcil" wrote:

Bob was telling us:
Bob nous racontait que :

Unable to rotate text box in Word2003. Copy and Paste into Word with
data only creates a page that overflows to right, and is unreadable.
Rotate unavailable in Word, if text box and linked boxes created.
Was able to create text boxes with links, re-oriented text
[bottom-up], but pasting data removed all formatting, and spreadsheet
header data.

If you paste data from Excel, you need to use Paste Special from the Edit
menu.
Then, if you do not need a linked object, use any of the Picture format, if
you need a linked object, use the Bitmap format. Finally, make sure that the
pasted object is not inline with the text and then you will be able to
rotate it.

If all this is too much trouble, why not create a page that is 6x9 instead
of 9x6?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

Bob was telling us:
Bob nous racontait que :

Okay - Paste Special, using picture format = That works, but very
small type, and header is lost. Paste places whole spreadsheet,

I do not think you can copy/paste a spreadsheet AND include the Excel header
at the same time.
I have never seen it done. You should probably ask in an Excel group (unless
someone here knows how to do this) about this (and, if they tell you it is
possible, please, report back here!)

which is really 3 pages long onto one page, very small type (maybe

How can you put a spreadsheet worth 3 pages on a 9x6 page?
If it is too big, all you can do is reduce the pasted object so that it
fits. A pasted object cannot overflow on to another page. If you must do
that, divide your spreadsheet in three areas, and do 3 paste actions.

4). Rotating works, but font size does not change, and last 2 pages
off page.

Please, it would help if you wrote complete sentences...
Sometimes, if we guess the missing words, we can get it wrong., and
consequently give inappropriate advice, thereby wasting everybody's time. Do
not forget that everybody involved here is a volunteer...

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

Change page size to 9x6 causes two problems. Page number footer also changes
to the 9 size (right side on book). Headers also missing, and data overflows
to bottom.

"Jean-Guy Marcil" wrote:

Bob was telling us:
Bob nous racontait que :

Unable to rotate text box in Word2003. Copy and Paste into Word with
data only creates a page that overflows to right, and is unreadable.
Rotate unavailable in Word, if text box and linked boxes created.
Was able to create text boxes with links, re-oriented text
[bottom-up], but pasting data removed all formatting, and spreadsheet
header data.

If you paste data from Excel, you need to use Paste Special from the Edit
menu.
Then, if you do not need a linked object, use any of the Picture format, if
you need a linked object, use the Bitmap format. Finally, make sure that the
pasted object is not inline with the text and then you will be able to
rotate it.

If all this is too much trouble, why not create a page that is 6x9 instead
of 9x6?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

Excel spreadsheet is three pages long, 16 x 91 cells, header is three lines.

Word document will be 6x9, with a page number footer.

Since the spreadsheet is so wide, traditionally these spreadsheets have been
printed, and scanned into camera ready material, and the printer inserts this
hardcopy into printer layouts.

I was hoping to copy spreadsheet into Word document, and get the same output
as printing spreadsheet does, three page long (landscape), with header.

Creating a new Word section, with page 9x6 fails. Header is lost, and page
number footer in Word rotates to right side of page.

Creating a text box, and pasting into text box fails because data overflows
to right, and rotate is not available with text box.

Creating text box, and rotating text left 90 fails because paste only allows
unformatted text, spreadsheet headers are lost.

Creating text boxes with link-text fails, because paste of data removes
excel headers, and formats as text, removing the right justification of each
column.

Special Paste (any picture format) fails, because picture reduces the three
page spreadsheet to very small font (maybe 4).

Outputting spreadsheet into three pages on pdf, and pasting each page
seperately creates a fuzzy look, even at 600 dpi.

Any other possibilities?

Thanks,
Bob

"Jean-Guy Marcil" wrote:

Bob was telling us:
Bob nous racontait que :

Okay - Paste Special, using picture format = That works, but very
small type, and header is lost. Paste places whole spreadsheet,

I do not think you can copy/paste a spreadsheet AND include the Excel header
at the same time.
I have never seen it done. You should probably ask in an Excel group (unless
someone here knows how to do this) about this (and, if they tell you it is
possible, please, report back here!)

which is really 3 pages long onto one page, very small type (maybe

How can you put a spreadsheet worth 3 pages on a 9x6 page?
If it is too big, all you can do is reduce the pasted object so that it
fits. A pasted object cannot overflow on to another page. If you must do
that, divide your spreadsheet in three areas, and do 3 paste actions.

4). Rotating works, but font size does not change, and last 2 pages
off page.

Please, it would help if you wrote complete sentences...
Sometimes, if we guess the missing words, we can get it wrong., and
consequently give inappropriate advice, thereby wasting everybody's time. Do
not forget that everybody involved here is a volunteer...

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

Bob was telling us:
Bob nous racontait que :

Excel spreadsheet is three pages long, 16 x 91 cells, header is three
lines.

Word document will be 6x9, with a page number footer.

Since the spreadsheet is so wide, traditionally these spreadsheets
have been printed, and scanned into camera ready material, and the
printer inserts this hardcopy into printer layouts.

I was hoping to copy spreadsheet into Word document, and get the same
output as printing spreadsheet does, three page long (landscape),
with header.

Creating a new Word section, with page 9x6 fails. Header is lost,
and page number footer in Word rotates to right side of page.

Creating a text box, and pasting into text box fails because data
overflows to right, and rotate is not available with text box.

Are you saying that with this method the Excel header was pasted along with
the spreadsheet? How did you do it?

Creating text box, and rotating text left 90 fails because paste only
allows unformatted text, spreadsheet headers are lost.

Excel header lost, as expected.

Creating text boxes with link-text fails, because paste of data
removes excel headers, and formats as text, removing the right
justification of each column.

Excel header lost, as expected.

Special Paste (any picture format) fails, because picture reduces the
three page spreadsheet to very small font (maybe 4).

Excel header?


Outputting spreadsheet into three pages on pdf, and pasting each page
seperately creates a fuzzy look, even at 600 dpi.

Any other possibilities?

As I wrote in an earlier reply:

"divide your spreadsheet in three areas, and do 3 paste actions"

i.e., select one third of the spreadsheet, copy/paste, add a page in Word,
come back, select the second third, etc.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

If you really want the page header from Excel, you can create a PDF of
the page from Excel, then export the page from Acrobat to EPS or TIFF,
etc.
That will give you a graphic of the entire page, with good resolution.
If you don't have Acrobat, then there are alternatives.
You may wish to re-examine the need for the Excel header.
Obviously, when you cram an entire page from Excel into a Word page,
things (including text) may get scaled down.
Maybe that page needs to be a foldout, sized for the spreadsheet you're
trying to display?

If you put a section break (next page) before and after the part where you
want the landscape pages you can turn off the page numbering in that section
so you don't get any numbers at all, you can then restart the numbering after
the last section break.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"Bob" wrote:

Change page size to 9x6 causes two problems. Page number footer also changes
to the 9 size (right side on book). Headers also missing, and data overflows
to bottom.

"Jean-Guy Marcil" wrote:

Bob was telling us:
Bob nous racontait que :

Unable to rotate text box in Word2003. Copy and Paste into Word with
data only creates a page that overflows to right, and is unreadable.
Rotate unavailable in Word, if text box and linked boxes created.
Was able to create text boxes with links, re-oriented text
[bottom-up], but pasting data removed all formatting, and spreadsheet
header data.

If you paste data from Excel, you need to use Paste Special from the Edit
menu.
Then, if you do not need a linked object, use any of the Picture format, if
you need a linked object, use the Bitmap format. Finally, make sure that the
pasted object is not inline with the text and then you will be able to
rotate it.

If all this is too much trouble, why not create a page that is 6x9 instead
of 9x6?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

Andrea Jones was telling us:
Andrea Jones nous racontait que :

If you put a section break (next page) before and after the part
where you want the landscape pages you can turn off the page
numbering in that section so you don't get any numbers at all, you
can then restart the numbering after the last section break.

If you had read the whole thread you might have noticed that the OP wanted
to preserve the headers/footers as they were, this is why he did not opt for
a landscape page, not because he did not know how or had trouble with
numbering.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

oh- multi page:
each page would become seperate graphic.
Lousy solution, but I don't know a better one-

If you find something, please post it back here!