eSource: EXCEL: Do Not Print

When it's time to print your EXCEL worksheet, you may not want to print some information. There may be confidential information such as employee salaries or personal information in a column which you may want to hide.

To avoid printing specific rows or columns, simply 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.

Submitted by: Admin Aces Technology Help Desk
Date submitted: 12/14/2005, last modified 08/06/2009
Categories: Computers and Technology