Only show print area with Kutools for Excel’s Set Scroll Area utility If xLastRng.Row Unhide All Ranges utility. Range(.Cells(1, 1), xFirstRng(1, 0)).EntireColumn.Hidden = True Range(.Cells(1, 1), xFirstRng(-0, 1)).EntireRow.Hidden = True Set xLastRng = xPrintRng.Cells(xPrintRng.Count)
VBA: Only Show Print Area in Current Worksheet Public Sub HideAllButPrintArea() Step 2: Click Insert > Module, and then paste following VBA code into the module window: Step 1: Press the Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.
To hide non-printing area completely in Excel, you can try VBA macro.
