Md. Abdur Rahim Rasel
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.
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.
- After that, a window pops up, and from that window click on the Page Setup option written in green color.
- 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.
- If everything is ok, we will click on the Print option like below to center print the worksheet.
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
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.
- 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.
Read More: How to Change Print Area in Excel (5 Methods)
Similar Readings:
- Print Titles in Excel Is Disabled, How to Enable It?
- Print Multiple Excel Sheets to Single PDF File with VBA (6 Criteria)
- Excel Button to Print Specific Sheets (With Easy Steps)
- How to Print Horizontally in Excel (4 Methods)
- How to Print Gridlines with Empty Cells in Excel (2 Methods)
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.
- Hence, a new window will appear in front of you. We will click on the Print option from that window.
- 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.
- If everything is ok, we will click on the Print option like below to center print the worksheet.
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
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.
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.
