excel 2013 print preview bottom border missing

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). In a module in workbook 'Program1.xls' there is simple code: Set or clear the Show White Space between Pages in Print Layout View checkbox, as desired.Two or more workbooks are open - say Report1.xls and Program1.xls (yes, 2003 workbooks but I do not think this is the problem).The Display options of the Word Options dialog box.

At the left side of the dialog box, click Display.

In Word 2010 or later versions, display the File tab of the ribbon and then click Options.) (In Word 2007 click the Office button and then click Word Options. If you prefer, you can also change the settings by using Word's dialog boxes: If you double-click on the mouse when the pointer is in this condition, Word toggles the display of the top and bottom white space. If you move the mouse pointer to the top or bottom border of the on-screen page representation, you'll notice that it changes to a small icon that has two arrows facing each other vertically. This feature provides a way to display more real information on the screen and is particularly useful if you have a document that uses a lot of white space at the top and bottom of the page. What Rodney is seeing is actually a feature of Word that hides white space (including headers and footers) at the top and bottom of a page. Rodney is wondering why this is happening.

The 'pages' of paper shown on-screen in Print Layout view show no top and bottom margin at all. Rodney notes that when he opens a new document in Word the on-screen display of the pages shows the correct left and right margins, but not the correct top and bottom margins.

Excel 2013 print preview bottom border missing