Excel is a widely accepted system for sorting, accumulating, and keeping track of essential data.
And for that reason, often, it’s crucial that you share specific data within the workplace.
That could be sending the excel file via email or printing a copy.
The problem occurs while printing the data.
By default, Excel tends to print out the entire sheet.
Thats not what you want if you dont intend to share every little detail with others.
To avoid those irregularities, specify the area in a sheet to print.
Lets say you are an accountant of a multinational company.
Youre currently working on the entire sales report that is recorded in an Excel sheet.
One day, your manager asks for the August 2022 sales report.
Clearly, you dont want to print the entire sales report of the company (from 1992-2022).
And not even the sales report for every month of the year 2022.
Sounds fair, right?
Lets see how you could do that.
Now, you’ve got the option to print a copy with those specific cells.
For that, Excel offers a feature named Page break preview.
Check out our separate post on how toMS Excel Lock a Cell.
Then you might print the sheet.
Usually, verifying is necessary when youre setting multiple cells to merge for printing.
But you dont know how to set up multiple print areas from a sheet?
No worries, check out the following section.
Heres a complete guide on how toLock and Unlock Cells in Excel.
Press and hold the Ctrl key and snag the cells you want to print out.
Then, move to the Page Layout tab and navigate to Print area > Print area.
Youll set multiple areas for print in a moment.
Theres an even better solution available for you.
Heres the procedure to setup multiple ranges to print in Excel:
Thats it.
Even you might need scrub the printing area to remove the existing cells.
Heres the procedure to expand the print area in a worksheet:
PressCtrl + Sto save the changes.
The cells that you selected later will be added to the existing print area.
That way, youll be able to replace it with a fresh print area.
Here are the steps to clear a print area in Excel:
Save the document to apply the changes.
Remember, you need available cells in the print area section to clear them off.
Heres a complete guide on how toCopy Values Without Formulas on Excel.
Why Cant I Set Print Area in Excel?
Mostly, due to faulty printer prefs, you cant assign cells in the print area.
Apply the subsequent troubleshooting tips to avoid the issue.
First, you should probably scrub the print area to solve those issues.
Then, you’re gonna wanna adjust the column size.
you’ve got the option to merge two columns into one to reduce the size.
Also, verify that only the necessary cells are set to print when youre in print preview mode.
After following those instructions, youll be able to set up the print area without any problem.
Frequently Asked Questions
Can I include additional cells after setting up the print area?
Yes, just highlight the additional cells and go to print area > Add print area.
How to View print area in Microsoft Excel?
Go to the View tab on your Excel sheet > choose Page Break Preview.
What happens when I reset the print area cells from Excel?
Your sheet will be in the default mode.
After clearing the cells from the print area, youll have to print the entire document.
Conclusion
Creating a print area in Excel lets you print specific document parts.
Throughout the article, Ive discussed different ways to set up that feature.
If you have any queries regarding this matter, feel free to ask in the comment section.
A team of Excel experts will be delighted to answer your questions.
