![make text shrink to fit in word make text shrink to fit in word](https://sourcedaddy.com/ms-powerpoint/images/tbtf75.gif)
My scenario is that I'm regularly pasting pictures (typically screen clippings) into a template that has a table which is always the same width.
#Make text shrink to fit in word code
I ran into the same problem and have created some simple VBA code which seems to solve it for me - thought I'd post it in case it's helpful.
![make text shrink to fit in word make text shrink to fit in word](https://oztechblog.files.wordpress.com/2011/04/qat2.jpg)
It doesn't pay attention to cell width, table width, margins, page orientation or anything of use - the horizontal scaling will always be 100% until the image is over 16.5cm wide and any image wider than that will be scaled down until it is 16.5cm wide. I assume this is based on an 8.5" wide page with 1" margins). The horizontal scaling is based on a fixed maximum image width of about 16.5cm (or 6.5". If the table contains multiple columns, it doesn't work properly.ĮDIT: Actually, looking at it a little further, it's behaving even worse than I expected. If the width of the image being pasted is larger than the entire row (and thus the cell being pasted into), then the image is scaled down proportionally to a width that would fit the row, but not down enough to fit within the cell.Īs a result, the pasting works but only when the table is one cell wide. If the width of the image being pasted is larger than the cell being pasted into, but smaller than the width of the entire row, then no scaling is done - which is incorrect behaviour. If the width of the image being pasted is smaller than the cell being pasted into, then no scaling is done - and this is right. Width of the entire table, rather than the width of the cell it is being pasted into. Looking at the behaviour in Word 2010 with some limited testing, it appears that while Word will ensure that the column does not automatically resize and instead scales the image, it appears to base the horizontal scaling of the pasted image on the This can be beneficial to other community members reading the thread.Īs Jay stated, this workaround doesn't work. Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. One Caveat the cell margins do appear to be incorrect. Now pasting larger pictures in does resize the image.
![make text shrink to fit in word make text shrink to fit in word](https://venturebeat.com/wp-content/uploads/2018/08/unnamed-2.jpg)
On the Table tab, click the Options button in that dialog, uncheck the "Automatically resize" option On the Column tab of the dialog, set the column widths to 1 then set the preferred width to 1.0 I will enter this issue into our database for future review for product issues.Ĭurrently, the following workaround is available: Which allows us to test the issue within our product. We appreciate the time and effort you took in providing clear and accurate information Thank you for reporting your concern and bringing this issue to our attention. Original height of the picture (again maintaining the aspectĪ comparison of the results can be seen in these screen shots: Īs mentioned before, both versions behave the same (resizing the picture to fit the cell) if I use Insert > Picture instead of pasting from the clipboard. Result in Word 2010: The picture is not resized it's truncated at the fixed column width. The height of the cell increases to the resized height of the picture (the aspect ratio is maintained). Result in Word 2007: The picture is resized smaller so its width fits within the cell's width. Return to Word and paste the picture into the cell. In any other program (I'm using IrfanView), open a picture whose width would be greater than 2" at its current pixel count and native resolution. Click Table Tools > Layout > AutoFit > Fixed Column Width.ĥ. Insert a 3x3 table in a new blank document (US letter, portrait) giving 2" column widths.ģ.