How do I show only the print area in Excel and grey out the rest?
Solution 1:
It is called "page break view" in excel. You can go to view menu on the ribbon and select one of the three options....
- Normal view
- Page layout view
- Page break view.
Select page break view and u will have the thick blue border with other cells grayed out as u mentioned.