Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2010, 06:04 AM
markg2 markg2 is offline Insert Excel sheet Windows 7 Insert Excel sheet Office 2007
Expert
Insert Excel sheet
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default Insert Excel sheet

Windows7 + Office '07



I clicked on the upper left corner of the spreadsheet that selected all, copied, selected paste special, Excel spreadsheet object in Word and the result was a light blue rectangle starting at ~1/3 into the vertical of the page, the balance of the sheet off the page and no contents.

It's likely the spreadsheet was too wide.

Isn't there a way to determine ahead of time if a sheet will fit?

What do I do in Word to give the imported sheet the widest possible target area assuming that Word will not do this on its own?

Doesn't Word have a mechanism to auto adjust import sizes?

Is there a better way of importing a spreadsheet in the manner that allows you to click on the sheet and the sheet then becomes an active worksheet?

Thanks,

Mark
Reply With Quote
  #2  
Old 12-15-2010, 12:19 PM
Ulodesk Ulodesk is offline Insert Excel sheet Windows 7 Insert Excel sheet Office 2007
Word 2013 Expert Cert
 
Join Date: Sep 2009
Location: Virginia
Posts: 866
Ulodesk is on a distinguished road
Default Excelling

Embedding the sheet as you have done is the way to go, as far as I know. As for layout, you can view page layout or print preview in Excel to see what will fit on a page. Viewing Excel on screen can otherwise be enormously deceptive.

I would also recommend setting a Print Area in Excel, to include only the part of the sheet you need. Select only this area and see how it falls on a page with the margins you have set for Word.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Excel sheet How to synchronize Excel Sheet over Network AmrMahmoud1982 Excel 1 09-24-2010 08:51 AM
Insert Excel sheet Any tutorial same as to this excel sheet with code? Learner7 Excel 1 05-18-2010 05:31 PM
Insert Excel sheet Excel sheet Sequence Number belloffice Excel 1 02-25-2010 02:41 PM
Word - Calculate and paste values from Excel sheet Augf87 Word 1 07-06-2009 10:26 AM
Insert Excel sheet Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft