confidential+data

Confidential data

When it's time to print your Excel work sheet, you may prefer that some information is left unprinted. For example, there may be some confidential data in a column, or your sheet may have some intermediate calculations that may just confuse or distract your audience. 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). In order to quickly unhide all rows or columns, select the entire work sheet (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.