If the top row or two of your spreadsheet happens to be blank, youĮxample of the Problem: Header text on top of Your header and footer will print, come what may! You may get a message about this problem, but it won't insist on your fixing it. It overlaps the first row of cells in the spreadsheet. In the illustration below, the header contains my Space, your header or footer may print on top of your data cells. Larger than the Bottom margin, or if your text size is too big to fit in the Margins Error: If you set the Header larger than the Top margin, or the Footer May be more decimal places in the number than the box can show. Be sure to select the whole value in the spin box. If you have trouble getting those values by dragging, use the Page Setupĭialog instead. Margins back to 1" top and bottom and 0.75" left and right. Drag the mouse to change the margin sizes.There is a message identifying the area you are changing and its current When margin lines are shown in Print Preview, you can drag them to
There may be more decimal places in the number than the box If you have trouble, use the Page Setup dialog Reset the margins to 1" top and bottom, 0.75" left and right, 0.5"Įxact values. You can have completelyĭifferent settings for different sheets in the same You cannot have different settings forĭifferent pages of the same sheet. WhichĪffect all of the pages, not just the one with the ruler Drag a boundary between two row headings taller or shorter.Drag the boundary between two column headings (just below.Drag the boundary on the ruler below the last row on the.Drag the boundary on the ruler above row 1 to change the Top margin.Drag the boundary on the ruler at the right of the lastĬolumn on the page to change the Right margin.To the left of Column A to change the Left margin. Drag the boundary between the darker and lighter areas on the ruler.While the mouse button is down, a screen tip shows the width of the first column but the screen tip is not wide enough for all of the text. Click on a margin boundary and hold down the mouse button to.Hover over a margin boundary on the ruler to see a screen tip with name and.To each page changes as you change the margins. Ruler apply to ALL pages for this worksheet. This box is grayed out unless you are in Page Solution: On the View tab in the Show tab group,Ĭheck the box Ruler. Only the top two pages would print because of the print area you Reduced zoom so you can see at least part of each of the 4 pages. The illustration shows the Budget sheet with Ruler shows you column widths, row heights, and margins In this view the rulers show for the page where the cursor is. You can adjust the page margins in this view using the ruler.Ĭlick in the Status bar on the button for Page Layout view. Page, including data that will not print with the current settings. The Page Layout view lets you see how your data will fit on the Return to Page Setup and try out other values.Click Print Preview to see the effect of your changes.Tab to see exactly what area they control. Click in each of the other text boxes on this.Experiment: Margins in Page Setup dialog.On this tab, the diagram will NOT adjust to match. It just shows theĭividing lines for the margins and header and footer. The diagram in the middle of the Margins tab is not really a preview of your document. Excel will convert your measurementĪppears on the diagram so you can see what area will be affected Like 2.5 cm, if the system is not using what you want. Of Measure: You can type in the unit of measure as well as the number, Metric system, the default sizes are in centimeters:Īnd Bottom 2.5, Left and Right 1.9, Header and Footer 1.3. If necessary, change the margins to match the illustration:
There is no place inside Excel to change the Margin settings are in inches if Regional settings = English (United States)).ĭialog does not show you what the unit of measure is! It just gives Instead of using one of the pre-designed settings. This time we want to see all the settings (Your Last Custom Setting may be different from the
#Problem excel 2013 print preview show margins plus
The menu offers 3 default settings plus the last custom settings On the Page Layout tab, click the Margins button.
Necessary, open budget-chart-2010-Lastname-Firstname.xlsx to the Budget tab. Start with:, budget-chart-2010-Lastname-Firstname.xlsx from your Class disk, excel How the margins relate to the header and footer To set the sizes for margins in Page Setup dialog