The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. With the Page Break Preview, it will show all used cells, but if you want to only display some cells in a specific range, you can use Kutools for Excel’ Set Scroll Area utility. If you want to go back to normal view, just click Normal under View tab. In the Page Break Preview view, the unused area will be greyed out.Įnable the sheet in which you want to display working area only, and click View > Page Break Preview. Grey out unused area by Kutools for Excel Grey out unused area by Page Break Preview In this article, I will tell you two methods to quickly hide the unused area cells. While you are working at a worksheet, you may want to only display the working area in the worksheet, which means to grey out all unused area in some times as below screenshot shown. How to quickly grey out all unused area in Excel?
