Avoid printing specific rows or columns in Excel

Avoid printing specific rows or columns in Excel

To avoid printing specific rows or columns, just hide them before printing. To hide rows, select them by clicking the row numbers (click and drag to select a block of rows; hold down Ctrl while clicking to select non-adjacent rows). Then right-click one of the highlighted border row numbers and click Hide. Use the same procedure to hide columns (but right-click a highlighted column letter to choose Hide).

When you're finished printing, you can quickly unhide all rows or columns by selecting the entire worksheet (click the blank gray box formed by the intersection of the row and column borders at the top left corner of your spreadsheet). Then right-click a row or column border and choose Unhide.