hiding rows based on cell contents

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I would like to hide an entire row whenever the contents
of one cell in that row equals 0. Is there any way to do
this?
 
Any column, a specific column, or range of columns.
You would need a macro and once you know how to use
macros you would generally post in excel.programming.

Getting Started with Macros -- install and invoke your macro
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Actually you could use AutoFilter if only one column to select 0

Ctrl+A to select all cells (all columns)
Data, Filter, AutoFilter
Click on the drop down arrow on your column of interest
Ctrl+; (semi-colon) to select visible cells only
format, rows, hide
Data, Filter, (turn off) AutoFilter

To unhide all rows
Ctrl+A to select all rows (all cells)
Format, rows, unhide
 
Back
Top