If you have created a small sheet in Excel, you can center it on the page when printing. By default, it is printed in the upper left corner of the page. For a very small dataset, this can reduce the effectiveness of your presentation.
There is an easy way to center the data on the printed page. You can center the data horizontally, vertically, or both.
To see how your worksheet will appear when printed, click File and then Print. You will see a preview of the document on the right.
When you preview the above example worksheet, you will see that it is positioned in the upper left corner of the page. This is how it will be printed.
To center the data on the printed page, click the Page Layout tab. Then click the arrow button in the lower-right corner of the Page Setup section of the Page Layout tab.
The Page Setup dialog box opens. Click the Margins tab. Under the Centered On Page heading, select the Horizontal check box if you want the information to be centered from left to right between page margins. Select the Vertically check box if you want the information to be centered from top to bottom between the page margins. Select both check boxes if you want the data to be centered on the page both horizontally and vertically.
Click the Preview Preview button and you will now see the data centered on the page. You can also change the orientation of the page so it stays centered.
Centering data on a page only affects the currently selected sheet. Hence, even if you have a full page of data on sheet 2, you can center the smaller dataset on sheet 1 without affecting other sheets.
Also, if you have a sheet with a lot of data and you only want to print one section of the sheet, but still want it to be centered, you can do this by first selecting the data you want to print. Once you have selected the data, go to the Print Files menu and you will see a drop-down list right below the settings.
You can print active sheets, print the entire book, or print the current selection. This is really handy as you can have a huge worksheet, but you only need to print a summary graph or chart. Enjoy!