contador Saltar al contenido

Center worksheet data in Excel for printing

If you created a small worksheet in Excel, you may want to center it on the page when you print it. By default, it will be printed in the upper left corner of the page. For a very small dataset, it can diminish the effectiveness of the 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 spreadsheet will look once printed, click File and then Print. You will get a preview of the document on the far right.

When the sample worksheet previewed above, you can see it placed in the upper left corner of the page. This as a stamper.

To center the data on the printed page, click the tab Layout page. Then, click the arrow button in the lower right corner of the section Tax page of the card Layout page.

The is displayed dialog Set page . Click on the tab Margins . Under the header Center on the page, select the checkbox Horizontal if you want the information to be centered from left to right between the margins of the page. Select the checkbox Vertically if you want the information to be centered from top to bottom between the margins of the page. Check both 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 page orientation and stay centered.

Centering data on an effective page only for the currently selected sheet. Therefore, even if you have an entire page of data on Sheet 2, you can center the smaller dataset on Sheet 1 without affecting the other sheets.

Also, if you have a sheet with a lot of data and you want to print only one section of the sheet, but you still want to center it, you can do it by first selecting the data you want to print. Once you have selected the data, go to File Print and you will see a drop-down menu right below Settings .

You can choose to print the active sheets, print the entire workbook or print on the current selection. This is really useful as you may have a huge worksheet, but only print a summary chart or graph. To enjoy!