How do I show only the print area in Excel and grey out the rest?
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.