Otherwise you are done changing your page margins. If you clicked Custom Margins, continue to the next step. Step 4: Click the desired margin setting, or click Custom Margins to specify your own. In the Page Setup dialog box, click to select the Adjust to option, enter a number for the scale, and then click OK. Step 2: Click the Page Layout tab at the top of the window.In the Page Setup group, click Page Setup to open the Page Setup dialog box.Manually set the scale instead of using the Fit to option. Re: Print Preview (Setup,Margins,Page Break Preview) Disable Thanks for the help, but I think you misunderstood what I am looking to do.
Use a printer driver that does not use the XPS PageScaling feature. To open the Margins tab of the Page Setup dialog box, click Custom Margins on the Margins buttons drop-down menu. To work around this issue, use one of the following methods. When the driver uses this feature, Excel cannot determine the scale of the workbook. The problems pages top ruler indicates that the last column only goes to, say, 9.5 of the 11-inch width. But the right margin does not show in either portrait or landscape orientation on SOME sheets of a 30+ sheet workbook. This issue may occur if the printer driver uses the XML Paper Specification (XPS) PageScaling feature. Margins are standard, scaling is set to 1 page wide, there are only three columns. To minimize the number of printed pages, choose the option for Narrow.
However, when you print this workbook or when you use the print preview feature to view the workbook, you receive the following error message:Īdditionally, many pages that have a scale of 10 percent may be printed. From the Page Layout Ribbon, click the icon for Margins. In a Microsoft Office Excel workbook, you select the Fit to option in the Page Setup dialog box.
0 kommentar(er)
