Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2019, 08:17 AM
alexsimpson alexsimpson is offline Crop embedded Excel Document Windows 10 Crop embedded Excel Document Office 2010 32bit
Novice
Crop embedded Excel Document
 
Join Date: Nov 2016
Posts: 5
alexsimpson is on a distinguished road
Default Crop embedded Excel Document

I have embedded an excel document in word and I have deleted some rows on the excel document but the object is still huge in word (as per the attached). Is there a way of cropping it?
Attached Images
File Type: png Capture.PNG (17.0 KB, 19 views)
Reply With Quote
  #2  
Old 07-23-2019, 10:45 AM
Moonshine Moonshine is offline Crop embedded Excel Document Windows 10 Crop embedded Excel Document Office 2016
______________
 
Join Date: Apr 2018
Posts: 302
Moonshine is just really niceMoonshine is just really niceMoonshine is just really niceMoonshine is just really nice
Default

The Crop option in the Format tab comes into play when an image/photo is in the document.
The Excel document in your page is an object and the Crop option isn’t seen.
To get round this, right click in the Quick access Toolbar (QAT) > Customize Quick Access Toolbar > Choose commands from > All commands > Scroll down to Crop Picture/Crop Tools > select one > Add > OK.

Now, when the excel object is clicked and the ‘handles’ are showing, you can click the newly created Crop Picture/Crop Tools shortcut and opt to crop and crop as desired.
Click the image below to see a short video of how it’s done.

Reply With Quote
  #3  
Old 07-27-2019, 11:57 PM
Eowyn Eowyn is offline Crop embedded Excel Document Mac OS X Crop embedded Excel Document Office 2016 for Mac
Novice
 
Join Date: Jun 2019
Location: New York
Posts: 23
Eowyn is on a distinguished road
Default

If you right-click the embedded Excel and choose EDIT, rather than open, you may be able to drag the handles (the bottom middle handle for example) to resize the embedded object. This works best if the object is formatted as in-line with text, rather than any of the floating options (in front of text, behind text, square with text, etc.). You may have to right-click the embedded Excel and choose format (object?) to see these options.
Reply With Quote
Reply

Tags
embed excel spreadsheet

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I crop an excel chart pasted in powerpoint slide using Office 2011 as I could w/2003? Amack021 PowerPoint 0 12-02-2014 09:16 AM
Crop embedded Excel Document embedded links in protected document John147 Word 1 08-10-2014 04:18 AM
Embedded Links failing in word document jim_jim Word 0 02-05-2013 07:48 AM
Crop embedded Excel Document Embedded Excel functionality? markg2 Word 1 01-13-2011 02:17 PM
Not able to open the embedded 2007 docx in 2003 doc document jkjain.13 Word 1 01-07-2010 06:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:03 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