show margins in excel 2013 print preview

May offer a tip about this problem, but it won't insist on your fixing it. Your header and footer will print, come what may! The Office Assistant Excel will not hide the misbehaving header or footer like Wordĭoes. In the illustration below, the header is my Larger than the Bottom, or if your text size is too big to fit in the Margins Error: If you set the Header larger than the Top, or the Footer The default sizes for margins (in inches) Drag the mouse to change the margin sizes.There is a message about the line you are on and the margin it represents. Carefully hold down the left mouse button.With the margin lines showing, move the mouse pointer over one of the dotted lines until it turns.This button toggles on and off a set ofĭotted lines that mark the margins and the header and footer. Open the Print Preview with the toolbar button.Your computer uses the metric system, the default sizes are in centimeters, If necessary, change the margins to match the illustration:.There is no place inside Excel to change the Click on the Margins tab. Margin settings are in inches if Regional Settings/Options = English (United States).ĭialog does not tell you what the unit of measure is! It just gives.Necessary, open budget.xls and then open the Page Setup dialog. ( budget.xls from the resource files) Margins: Dialog How the margins relate to the header and footer May have to make adjusts to your documents if your printer needs extra wide Some printers cannot print as close to the edge of the paper as others. Margins to have your documents look similar to the illustrations. If you don't use 'letter' size paper, you may need to use different Top, bottom, left and right margins surround the body The instructions will, of course, tell you to change the You have top, bottom, left, and right margins.

The margins are the blank space between the edge of the paper and the printedĭata.

Show margins in excel 2013 print preview