Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2015, 03:57 PM
wjmj wjmj is offline Copy excel data Windows 7 64bit Copy excel data Office 2013
Novice
Copy excel data
 
Join Date: Dec 2015
Posts: 1
wjmj is on a distinguished road
Default Copy excel data


Hello I am trying to copy a spreadsheet from Excel over to my word document. If i select the cells and paste as a spreadsheet object, I end up with entire workbook. How do I copy and paste only the selected cells that contain data, format, formulas etc? The problem I have is when I double click on the data of my document, I can scroll down thru pages of empty cells. I hope I explained it well enough what my issue is. Any help is appreciated.
Reply With Quote
  #2  
Old 12-18-2015, 10:10 PM
gmayor's Avatar
gmayor gmayor is offline Copy excel data Windows 10 Copy excel data Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The problem is that you are embedding a worksheet so if you double click it you are back to the source worksheet. Paste as bitmap with the link option set. It will shrink to fit the space available, and being a link, any changes you make in Excel will be available to the document.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
a macro that can copy data from copy.xls to our current excel macro.xls based on criteria: udhaya Excel Programming 1 11-12-2015 10:12 AM
How to copy all data from a website to excel sheet? Plz plz plz plz plz help...urgent Sam123 Excel 0 07-19-2014 02:12 AM
Copy data from Word into Excel chinchee Word VBA 18 05-23-2014 05:25 AM
Copy Excel data into an existing Word Table JJG Word 1 12-18-2013 05:41 PM
How to Copy data from Outlook mail and Paste it in a Excel sheet? padhu1989 Outlook 0 09-11-2012 04:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:34 PM.


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