Page 298 - Excel 2013 All-in-One For Dummies

280 Working with the Page Setup Options
Select one or both Center on Page options in the Margins tab of the Page Setup dialog box (refer to Figure 5-5) to center a selection of data (that takes up less than a full page) between the current margin settings. In the Center on Page section, select the Horizontally check box to center the data between the left and right margins. Select the Vertically check box to center the data between the top and bottom margins.
If you select the Show Margins check box at the bottom of the Print screen in the Excel Backstage view (Ctrl+P) to change the margin settings, you can modify the column widths as well as the margins. (See Figure 5-6.) To change one of the margins, position the mouse pointer on the desired margin marker (the pointer shape changes to a double-headed arrow) and drag the marker with your mouse in the appropriate direction. When you release the mouse button, Excel redraws the page, using the new margin setting. You may gain or lose columns or rows, depending on what kind of adjustment you make. Changing the column width is the same story: Drag the column marker to the left or right to decrease or increase the width of a particular column.
Figure 5-6:
Drag a marker to adjust its margin in the Page Preview window when the Show Margins check box is selected.