Page Layout → Page Setup → Margins → Custom Margins First, select your entire data to print in the center, then, from your Page Layout ribbon, go to,.We can print the area in the center by using the Page Layout command. Apply the Custom Margins Command to Center the Print Area in Excel Read More: Excel VBA: How to Set Print Area Dynamically (7 Ways)Ģ. If everything is ok, we will click on the Print option like below to center print the worksheet.By clicking on the OK box, we will see that our Print Preview is showing the preview of the worksheet in the center that has been given in the below screenshot.From the Page Setup window, firstly, click on the Margins Secondly, click on Horizontally and Vertically from the Center on Page option. Hence, a window named Page Setup pops up.After that, a window pops up, and from that window click on the Page Setup option written in green color.First of all, we will select the entire data range of the worksheet we are working on, and then press Ctrl and P simultaneously on your keyboard.In this method, we will learn how to center the print areas in Excel by performing the keyboard shortcut. Perform the Keyboard Shortcut to Center the Print Area in Excel Here’s an overview of the dataset for today’s task.ġ. We will center the print area in Excel of the salary statements of those sales representatives by applying keyboard shortcuts, Custom margins, File ribbon, and so on.
Let’s say, we have a dataset that contains information about the salary statements of the sales representative of the Armani Group. 4 Suitable Ways to Center the Print Area in Excel
0 kommentar(er)
