problem excel 2013 print preview show margins

This seems to me just wrong - if you write in code 'windows('whatever').

Window, click on the window zooms it) but that is not enough.Īs far as I can see this problem exists in Excel 2013, but not in Excel 2010.Ĭan someone tell me what I am doing wrong? Or how to work around this?Īt this opportunity I also ask: according to the excel vba documentation, PrintPreview is also a method of the window object. There are some substitutes (escape lets you close the print preview The print preview appears, but the icons above it (print, setup, zoom, close) are inactive.

If the open window is Report1.xls and one calls this routine, everything works fine.īut if the open window is Program1.xls and one calls this routine, there are problems. That is enough code to illustrate the problem (and probably some of that superfluous). Select the desired margin size from the Page Margins drop-down menu. You can modify page margins from the Print pane. Sometimes you may need to adjust the margins to make your data fit more comfortably. In a module in workbook 'Program1.xls' there is simple code: To modify margins in the Preview pane: A margin is the space between your content and the edge of the page. Open with the proper print margins in Microsoft® Excel® for Mac 2011 Version 14.1.0 (110310) Latest Installed Update: 14.1.Two or more workbooks are open - say Report1.xls and Program1.xls (yes, 2003 workbooks but I do not think this is the problem). How can I get a Office 2008 documents to: Now it dismantles my Excel® spreadsheet into modules and scatters them across a multitude of pages…. xlsxs document SAME ISSUE with something new. xlsx file type in Office 2008 and saved it down to a. xls file in Office 2008 and saved it down to a. So I figured it must have been a file type issue, so I’ve done the following:ġ. However now in the new Excel® from Office 2011 the print margins are over 3”, yet the settings are still accurate. In the 2004 version of Excel® the margins generally give a 1” border around the document. I’ve noticed that the print margins are all wrong. xls file is created in Excel® - Office 2004 and you open it up directly in:

Quick Access Toolbar (QAT) The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the. I’m running a MacBook Pro, Version 10.6.7 and have found the following that I can’t seem to figure out how to fix it. Environment Quick Access Toolbar Customizable toolbar for one-click shortcuts Tabs Backstage View Tools located outside the document viewing window.

Problem excel 2013 print preview show margins