Excel 2007 changes graphic size in print preview

Just started using Excel 2007 and in many documents I create I need to paste screen capture graphics into the excel file. I use the !Quick Screen Capture software.

I noticed that when I am in print preview with margins showing, if I adjust the column widths in order to adjust areas with text the graphics I have pasted change size - they get really small. I have to exit print preview, right click on the graphic, select format picture and then click the reset picture button to get the graphic back to original size. This resizing does not happen if I adjust the column widths in normal view mode.

This never happened in Excel 2003 so I'm confused on how to fix it. Is this just normal and I'll have to adjust to it or is there a setting that will prevent the graphics from autosizing if I adjust columns while in print preview mode?

Many thanks for your help.

Dawn

Originally Posted by shg

Welcome to the forum.

Right-click > Size and Properties, Properties tab, tick Don't move or size with cells

Thanks for the tip. I did that and it still changes the size AND it moves the graphic to the top of the page.