#1   Report Post  
Posted to microsoft.public.word.docmanagement
Rick
 
Posts: n/a
Default Word Copy & Paste

This question may be posted in the wrong section but here goes anyway.
How do I or can I, get an Excel spreadsheet to fit onto 1 page in Word?
I have tried copy, paste, and autofit to no avail. It gets it 1 page wide
(wraps text on some cells) and 2 or more pages long, depending on the size of
the spreadsheet.

Any suggestions?
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Carol
 
Posts: n/a
Default Word Copy & Paste

Hi Rick,

In Excel you can click on File and Page Set Up and under Scaling where it
says pages wide by delete the number.

Also, if you just want someone to see the sheet, you can highlight all the
data in Excel and depress your Shift key and click on Edit and Copy as
Picture and then paste the picture into your Word document. That way you can
reformat the picture to fit on the page.

I hope this has been helpful to you.

"Rick" wrote:

This question may be posted in the wrong section but here goes anyway.
How do I or can I, get an Excel spreadsheet to fit onto 1 page in Word?
I have tried copy, paste, and autofit to no avail. It gets it 1 page wide
(wraps text on some cells) and 2 or more pages long, depending on the size of
the spreadsheet.

Any suggestions?

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
garfield-n-odie
 
Posts: n/a
Default Word Copy & Paste

If your Excel spreadsheet is more than 2 pages long, then
shrinking it to fit onto 1 page in Word will probably make it too
small to read without the aid of a microscope.

When pasting into Word, click on Edit | Paste Special | Paste:
As: Picture | OK. Pasting as a picture means that you cannot
edit the Excel spreadsheet from Word, and the pasted picture is
not linked to the original Excel spreadsheet. If it becomes
necessary to change the Excel spreadsheet, then you'll need to do
that in Excel, and then copy and paste the revised spreadsheet
into Word.

In Word 2000 and earlier, there is a limit to how much you can
paste as a picture from Excel. Word cannot shrink the selected
Excel range to less than 69% of its original size. If the
selected range must be smaller than 69% of original to fit on the
Word page, then the selected range is shrunk to 69% and any extra
columns or rows are truncated.

Rick wrote:

This question may be posted in the wrong section but here goes anyway.
How do I or can I, get an Excel spreadsheet to fit onto 1 page in Word?
I have tried copy, paste, and autofit to no avail. It gets it 1 page wide
(wraps text on some cells) and 2 or more pages long, depending on the size of
the spreadsheet.

Any suggestions?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Does Word have a QuickCorrect/Quick Word option like WordPerfect? CW New Users 2 December 20th 05 05:54 PM
In Word, how do I surpress headers and footers on page 2 Bill Microsoft Word Help 1 December 15th 05 06:13 PM
Macros - Keyboard Commands Janet Microsoft Word Help 6 April 11th 05 05:28 AM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 12th 05 11:30 PM


All times are GMT +1. The time now is 09:33 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"