When you try to print this dataset on an A4 sized paper, this is how it is going to look: For simplicity, we kept the dataset small and basic: Say you want to print the following dataset.

In this way, you get more related options.

When you click on the dialog box launcher, it opens dialog boxes or task panes related to the relevant group. A dialog box launcher is a tiny icon that appears in a group in the ribbon in Excel. In this method, you will use a dialog box launcher tool. Method 1: Centering the Worksheet Horizontally using Page Setup Launcher Tool Method 1: Using the Page Setup Launcher Tool.In this tutorial, you will see three ways to center the worksheet horizontally on a page in Excel. Under such circumstances, centering your worksheet horizontally makes the page look more symmetric and professional. As such, the printout usually looks like it has been squished to one corner of the page.

If you have a small dataset, the main work area of the worksheet is quite small compared to the page you’re printing on. However, when we print this out on paper, a lone table at the top left corner of the paper doesn’t look very aesthetic. Intuitively we all start working from the top-left corner of the worksheet in the Excel Window. One of the issues that a lot of Excel users face while printing worksheets is the placement of data on the paper. The idea of ‘What You See Is What You Get’ is a little far-fetched when it comes to printing in Excel. When you start out using Microsoft Excel, you’ll notice that printing Excel sheets do not quite feel the same as printing an MS Word document.

Number dialog box launcher excel 2016