Therefore, even if you have a full page of data on Sheet 2, you can center the smaller set of data on Sheet 1 without affecting other sheets.Īlso, if you have a sheet with a lot of data on it and you only want to print out one section of the sheet, but still want it centered, then you can do that by first selecting the data you want to print. You can also change the page orientation and it will remain centered.Ĭentering data on a page is effective only for the currently selected sheet. Select both checkboxes if you want the data centered in the page both horizontally and vertically.Ĭlick the Preview Preview button and now you will see the data centered on the page. Select the Vertically check box if you want the information centered top-to-bottom between the margins of the page. Under the Center on page heading, select the Horizontally checkbox if you want the information centered left-to-right between the margins of the page. Then, click the arrow button in the lower, right corner of the Page Setup section of the Page Layout tab.
To center the data on the printed page, click the Page Layout tab.