How to Center the Print Area in Excel (4 Ways)

There are many kinds of print types in Microsoft Excel. The center print area is one of them. It is an eye-catching print type. We will center the print area in Excel of our dataset by applying keyboard shortcuts, Custom margins, File ribbon, and so on. Today, In this article, we’ll learn how Excel center print area can be done effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


4 Suitable Ways to Center the Print Area in Excel

Let’s say, we have a dataset that contains information about the salary statements of the sales representative of the Armani Group. 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. Here’s an overview of the dataset for today’s task.

excel center print area


1. Perform the Keyboard Shortcut to Center the Print Area in Excel

In this method, we will learn how to center the print areas in Excel by performing the keyboard shortcut. Please follow the instruction below.

Step 1:

  • 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.

Perform the Keyboard Shortcut to Center Print Area in Excel

  • After that, a window pops up, and from that window click on the Page Setup option written in green color.

Perform the Keyboard Shortcut to Center Print Area in Excel

  • Hence, a window named Page Setup pops up. From the Page Setup window, firstly, click on the Margins Secondly, click on Horizontally and Vertically from the Center on Page option. Finally, press OK.

Step 2:

  • 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.

Perform the Keyboard Shortcut to Center Print Area in Excel

  • If everything is ok, we will click on the Print option like below to center print the worksheet.

Perform the Keyboard Shortcut to Center Print Area in Excel

Read More: Excel VBA: How to Set Print Area Dynamically (7 Ways)


2. Apply the Custom Margins Command to Center the Print Area in Excel

We can print the area in the center by using the Page Layout command. Just follow the steps below:

Step 1:

  • First, select your entire data to print in the center, then, from your Page Layout ribbon, go to,

Page Layout → Page Setup → Margins → Custom Margins

Apply the Custom Margins Command to Center Print Area in Excel

Step 2:

  • After clicking on the Custom Margins option, a Page Setup window will instantly appear in front of you. From that window, firstly, click on the Margins Secondly, click on Horizontally and Vertically from the Center on Page option. Finally, press OK.

Apply the Custom Margins Command to Center Print Area in Excel

  • Hence, 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.

  • Finally, we will click on the Print option like below to center print the worksheet.

Apply the Custom Margins Command to Center Print Area in Excel

Read More: How to Change Print Area in Excel (5 Methods)


Similar Readings:


3. Insert File menu to Center the Print Area in Excel

we can center print on the worksheet from the File menu in Excel. Let’s follow the steps below.

Step 1:

  • First, select the entire data range and then click on the File ribbon.

Insert File menu to Center Print Area in Excel

  • Hence, a new window will appear in front of you. We will click on the Print option from that window.

Insert File menu to Center Print Area in Excel

  • After clicking on the Print option, another window with different Print options will now appear. We will click on the Page Setup option written in green color.

  • Further, a window named Page Setup pops up. From the Page Setup window, firstly, click on the Margins Secondly, click on Horizontally and Vertically from the Center on Page option. Finally, press OK.

Step 2:

  • Now, 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.

Insert File menu to Center Print Area in Excel

  • If everything is ok, we will click on the Print option like below to center print the worksheet.

Insert File menu to Center Print Area in Excel

Read More: How to Print Selected Area in Excel on One Page (3 Methods)


4. Use the Page Layout Command to Center the Print Area in Excel

Now, we will use the Arrow Button command to print in the center of our entire worksheet. Please follow the instructions below to learn!

Step 1:

  • First of all, select your entire dataset, and from your Page Layout tab, go to,

Page Layout → Page Setup → Arrow Button

Use the Page Layout Command to Center Print Area in Excel

Step 2:

  • While clicking on the Arrow Button option, a Page Setup window pops up in front of you. From that window, firstly, click on the Margins Secondly, click on Horizontally and Vertically from the Center on Page option. Finally, press OK.

  • After that, 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.

  • After completing the above process, we will click on the Print option like below to center print the worksheet.

Use the Page Layout Command to Center Print Area in Excel

Read More: How to Print Selected Area in Excel (2 Examples)


Things to Remember

↪ You can press CTRL+P to activate the Print feature of Excel.


Conclusion

I hope all of the suitable methods mentioned above to print the selected area of your worksheet in the center will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo