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

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Center the Print Area in Excel: 4 Ways

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 instructions 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


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


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


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


Things to Remember

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


Download Practice Workbook

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


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


<< Go Back to Print Area | Page Setup | Print in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo