problem excel 2013 print preview show margins

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 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

Problem excel 2013 print preview show margins