Now if you check in the Print Preview, the data will be centered: Click and drag the Page Break to eliminate the Print Area excess of the data.If you escape the Print Preview, you will find the culprit space edged with a dashed line on the active worksheet: The second trick is to adjust the Page Breaks which will also eliminate any unwanted Print Areas. Since the data has already been centered, getting only the selection to be printed will ignore the Print Areas inhibiting the data from being centered on the page: In the Settings, click on the first button that reads Print Active Sheets.The first trick is the reason the data was selected in the first step. The Print Area can be set from the Page Setup options in the Page Layout tabs now or beforehand but we have a couple of quicker tricks. This could be because the Print Area hasn’t been set. Click on the Print Preview command button.Īs you see below how despite centering the worksheet horizontally and vertically, it still isn’t centered?.
Below are the steps to center the worksheet horizontally and vertically using the Page Setup launcher tool: In this method, we are using the dialog box launcher from the Page Layout tab.
With the Margins settings in the Page Setup dialog box, we can have the data centered horizontally and vertically. All the while you can head to Print Preview to see what your print will look like. If you’re still having centering frustrations where too much white is gaping at annoying widths and heights, we have 2 quick tricks to help set up the Print Area, centering the data with it, using Print Selection and Page Breaks. All 3 methods require the page’s Margins settings which we will access with the Page Setup launcher tool, the toolbar Ribbon, and Print Preview. We will guide you on 3 easy ways to center a worksheet horizontally and vertically in Excel. Now, why should we be hacking crookedly at our pages when we only need to soft-align the data to white-bordered perfection? Our short Excel tutorial today will help you save the hassle of wanting to shred or scrunch up your prints because please, let’s minimize wastage! By default, the sheet is printed with the data aligned to the upper-left of the page. We have a small appointment schedule that looks pretty neat when arranged on a spreadsheet:īut the printout is so sad it makes us want to find the nearest pair of salon shears and hack at it:
A modest to-do list, price list, vendor list, a small handout of project allotment, roles, or daily tasks, you get the idea. You have a slight list that you need on your desk or pasted to the wall.