Excel is the most useful tool to deal with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. While working in Excel, we often need to print the datasheet for our convenience. But sometimes, the print area does not function properly in Excel. Often, the print area is grayed out in Excel. In this article, I will discuss the problem in detail and give 2 easy solutions to this problem.
Download Practice Workbook
Download this workbook and practice while going through this article.
An Overview of the Problem
This is the datasheet that I am going to use to explain the problem in detail. There are some products and respective sales amounts.
When I tried to set the print area, I found out that the print area was grayed.
This is the problem for today’s article.
Reasons:
This may occur due for 2 reasons. They are,
- Someone has grouped multiple sheets. For instance, Product and Employee sheets are grouped.
- Someone saved the file with grouped sheets.
2 Simple Solutions If Print Area Is Grayed Out in Excel
In this section, I will discuss 2 solutions to the problem. Let’s learn about them step by step.
1. Ungroup Sheets Using Mouse
The first solution is to ungroup the sheets using your mouse. In our problem, we have two sheets that we need to ungroup. Let’s do it step by step.
Steps:
- Take your cursor on any one of these sheets.
- Then, right-click your mouse. A menu will pop up.
- After that, select Ungroup Sheets.
- Now, you can see the Print Area is active and usable.
Read More: How to Set Print Area in Excel (5 Methods)
2. Ungroup Sheets by Selecting Another Sheet
Now, I will show another simple solution. You can also ungroup the sheets by selecting another sheet. Suppose I have another datasheet Area. I have grouped the Product and Employee datasheet and the Area is separate.
I will now ungroup the 1st two sheets using the 3rd one.
Steps:
- Take your cursor on the Area.
- Then, select it.
- Excel will ungroup the Product and Employee.
- Now, you can see the Print Area is active and usable.
Read More: How to Set Print Area to One Page in Excel (with Easy Steps)
Things to Remember
- Print Setup and Print Area options do not function for grouped sheets.
- You will find the Print Area in the Page Layout.
Conclusion
In this article, I have illustrated the problem – the print area is grayed out in Excel – and provided 2 solutions for this problem. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit Exceldemy for more useful articles like this.
Related Articles
- How to Clear Print Area in Excel (2 Easy Ways)
- Show Print Area in Excel (4 Easy Methods)
- How to Set Print Area with Blue Line in Excel (5 Easy Ways)
- Excel VBA: How to Set Print Area Dynamically (7 Ways)
- How to Print Selected Area in Excel (2 Examples)
- Change Print Area in Excel (5 Methods)
- How to Center the Print Area in Excel (4 Ways)
Thank You – You are a hero. After many hours YOU have solved my problem.
Thank you for your kind words. Have a good day!