problem excel 2013 print preview show margins

Microsoft Office Excel 2003 and earlier versions of Excel On the Size tab, adjust the size of the image to fit inside the header or footer section. On the Design tab under Header & Footer Tools, click Format Picture in the Header & Footer Elements group. Microsoft Office Excel 2007Ĭlick in the header or footer section where the image is located.Ĭlick in the & text of the image. To do this, follow these steps, as appropriate for the version of Excel that you are running. To resolve this issue, resize the image that you place in a header or a footer to fit inside the area of the header or footer section. Additionally, the image is not resized when header or footer margins are subsequently changed. This issue occurs because the image is not automatically resized to fit inside the header or footer section when you place an image in a header or a footer. When you insert an image in the header or the footer in a Microsoft Excel worksheet, the image may overlap into the data area of the worksheet. I've attached an example of a worksheet that's doing this.An image in a header or a footer may overlap into the data area of a worksheet in Excel Symptoms (We're all using the most up-to-date drivers for our physical printers.) For example, an item will display on the screen as wrapping to two lines within a single cell, but in Print Preview, the display seems to have narrowed so that the item now needs three lines to display properly - but cuts it off at two, so that the final part of the text is missing.

We've got numerous printers including Adobe PDF, and they all display the same. We are repeatedly coming up against a problem where the information displays perfectly on the screen, but cuts off text in the cells when printing (or print previewing). The new sheet is created with a defined print area (a single column), defined margins (.5 all around), and uses Paste Special to paste the values and the formats (including wrap text), as well as column widths.

I have a workbook that my users use to create construction work orders there's a button on the main sheet that runs a (lengthy) macro to create new worksheets based on data that is entered, and copy and paste data from the main sheet to the new ones.

Problem excel 2013 print preview show margins