how to fit picture in cell of excel for mac

How to fit picture in cell of excel for mac how to#

I've tried different DPIs, I've tried JPG as well as TIFF. I've tried images at 4'x4', 5'x5', 7.5'x9.5' and all of them distort and come out different sizes. I have spent hours and hours researching and checking every option I can find and nothing makes a difference, Excel just will not display the image at the correct size. I KNOW that if I print my border from Word, or from the exported PDF, or from the Photoshop document, or the TIFF export, they ALL come out identical in size, but only if I place the image in Excel I cannot get it to size right no matter what I do. I KNOW my Photoshop document was 600dpi, and I KNOW Excel Page property says 600dpi. And I KNOW my graphic is not being distorted, because in the image properties, scale is 100% and everything is original size. And I KNOW that an Excel sheet is 8.5x11. The question is, I KNOW my graphic is 7.45x9.605. To try and fix this, I played with margins and the ONLY way to see my graphic on a single sheet is to set all margins to ZERO! And even then, there is almost no room top to bottom, and the left and right sides are also wider, and if I try to print, it gets cropped.

This I don't understand, my graphic is smaller than 8.5x11 so why wouldn't it fit inside a page? Excel is widening it to a second page! My math may be weird, but 7.45' should fit on a sheet 8.5' wide and not need two pages right? You would THINK that because my graphic is 7.45x9.605, it would fit on a 8.5x11 sheet in Excel? It doesn't, the left and right part of the graphic are completely off page, and the top and bottom are are nearly squished to the far edges. I've inserted the picture into the header (which is what I need to do), and I've also set the image as the sheet background. Next, insert the graphic into Excel, I've done this three different ways for testing, and I have the problem in all cases. Note that I've tried to use 200dpi, and even lower as well, it happens at any dpi. This file was created in Photoshop and I export it as a TIFF.įirst thing to note is that in Excel, my page properties say that it will print at 600dpi, so that's why I'm working with that in Photoshop. The graphic I NEED to use happens to be 7.45' x 9.605' and is 4470x5763 pixels in size. Make the graphic something like 5'x5' at 600DPI, or any square or rectangle size that should fit in a 8.5x11 sheet in Excel. I won't bore you with all the details on the exact graphics I made, but if you want to duplicate this problem, simply create a graphic in Photoshop or someplace, and have a border on your graphic, used a grid pattern for testing if you can. It is easy to forget to select these options for images in the spreadsheet but it is very important because when you resize a column or row it can mess-up an image or shape that is not currently visible.ĭownload the workbook attached to this tutorial to test this out in Excel.The issue involves how Excel is distorting images when placed in a sheet. This is a simple but important tip to keep in mind when you are building your spreadsheets, especially when they get large and complex. Move but don't size with cells: the items will NOT be resized but they will move in the spreadsheet when you change column and row sizes.ĭon't move or size with cells: the items will essentially freeze within the spreadsheet and will not move or resize unless you specifically resize or move them using the mouse.īefore we selected the option not to resize, we could have ended up with a spreadsheet that looked like this when we went to resize columns and rows:

In the window that opens, go to the Properties section from the left hand menu.

Right-click the image or shape and then click Size and Properties.Steps to Prevent Images and Shapes from Changing Size or Moving This will allow you to keep the dimensions of your images and shapes while allowing them to move with the spreadsheet when you change its size, or to freeze them in place.

How to fit picture in cell of excel for mac how to#

How to stop Images and Shapes from resizing in Excel when you change the size of rows and columns.