Microsoft Excel Interview Question:

In Excel, how can I prevent a row from printing in a range if certain cells in a particular column equal 0. I do not want to extract the records to another section of the sheet. Is it possible to hide those rows, then print, then unhide?

Submitted by: Administrator

There's a menu-driven solution that's called AutoFilter. Just put the cursor anywhere in the range of cells you want to print, open the Data menu, select Filter, then choose AutoFilter. When you do, Excel will add dropdown-arrows to the cell at the top of each column. Click that dropdown arrow for the column that contains the zero entries. Select the Custom... option. That opens the Custom AutoFilter dialog box. In the Show Rows Where fields section, choose the greater-than sign for the operator and enter 0 (the number) for the value. Then, click OK. When you do, Excel will display only the rows that contain values greater than zero in the column you selected. To re-display those rows, open the Data menu, choose Filter, and choose AutoFilter again to deactivate it.
Submitted by: Administrator