#Excel 2013 print preview code#
Here is the code that I used, just in case you run into a similar problem. I don’t know why the problem occurred, but I added a bit of code to the project, to increase the zoom level, then set it back to the previous zoom setting. I have tried using Word 2013 I have no problems using the print preview. Thus i can't use the page break view and can't do my editing. The picture immediately went back to the correct size, and stayed that size, when I put the zoom back to 100%. Created on SeptemI can't print preview in Microsoft Excel 2013 I have a few printer installed in my computer including pdfcreator but i can't print preview in excel 2013. But this time, I didn’t delete the picture, I just increased the zoom level, from 100% to 110%. If you dont see the paper size you need, select More Paper Sizes. Ill bring up VL03n and pull up a delivery note in print preview by. I tried previewing again, and the image got larger, just as it did before. Once that happens, your SAP data will be exported to Excel without a problem. The picture disappeared after pasting, and only appeared when I zoomed. But, it was in the range of cells where it should have been visible, without zooming. When I could see the pasted picture, it was the right size, instead of oversized. The Disappearing Pictureįinally, I noticed something odd, as I pasted the logo onto the problem sheet – after I pasted, I had to zoom out a bit, to find the pasted picture. Also, I found that the problem occurred whether I manually opened the Print Preview window, or used VBA to open it. I tried deleting and copying a few more times, and the result was the same each time. How can I change this Attached Images xlsx layout.PNG (65.6 KB, 3 views) xlsx layout preview.PNG (30.9 KB, 3 views) Attached Files Pens b.xlsx (420.
#Excel 2013 print preview pdf#
Yikes! The new copy looked just as big as the oversized one, even though it was the correct size on the sheet where I’d copied it. pdf doesn't show images correctly in Excel 2013. There was a copy of the logo on another sheet in the file, so I deleted the oversized one, and pasted in a new copy. I Googled, but that didn’t help – the only suggestions were to check the image properties. That setting was okay, so I didn’t know why the size changed. When you press this keyboard shortcut (this is the same key that we use to print). Then, in the Properties category, make sure the image is set to “Don’t move or size with cells.” To get the print preview, you can use the keyboard shortcut Control + P. The first thing I did was check the picture settings – right-click on the picture, and click Size and Properties That is not what I wanted it to look like! Here is a screen shot of the logo image after the Preview. Here’s how my company logo image looked before the Preview – just a nice, small-sized logo, at the top left of the sheet. I ran into an odd problem with images in Excel 2010 last week – after looking at the sheet in Preview, a small logo graphic grew big enough to cover the most of the data on the sheet! Have you run into the problem where Excel images change size after Preview?