Hiding Rows when a cell = 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,

I would like to hide a row when the first cell in that row = 0.

basically somthing along the lines of =IF(A1=0,hiderow,unhiderow)

I can hide rows but the file must be unprotected to change which rows are
hidden. With numerous people working with the file i would rather not risk
people deleting formulas on accident.
 
Use Autofilter:

Put a header or label cell on top of column A. Then pull-down Data > Filter
Autofilter and specify Show rows where the header cell does not equal zero.
Click to expand...


This will hide all the rows for which the A-cell is zero.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 while conditionally hiding rows as a result ofworksheet protection 2
Enabling option „Format rows“ to hide/unhide rows using VBA-code? 0
Hiding a row when a cell has a value 4
Excel EXCEL - using a date dependant formula to hide rows 3
Macro - hide rows that are 0 without an auto-filter 3
hiding rows 5
Creating a function to auto hide rows 1
hide a row 2

Back
Top