0

Auto Hiding Rows

Dooz

July 14, 2021 15:10

None

Follow

Hi everyone,

I am looking to use this auto hide function as explained on this article but with no luck https://support.jetglobal.com/hc/en-us/articles/218953738-Conditionally-Hiding-Rows-Columns-or-Sheets

Can someone explain to me how this function works? Just by typing Auto+Hide in cell A1, Hide+? in B1 and an 'IF' formula against the rows then the sheet will automatically 'Hide' rows? If that is the case then what am I doing wrong here, see attached image. My 'hide' rows are not hiding.

 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  CascadiaDataworks April 18, 2022 16:27

  To clarify, when the report is run, the rows where the word Hide is in column B is not being hidden?  I don't know what the function in column G is, but it is possible that the result in Column G it is fractions of a cent so Excel shows 0 but technically it is not 0.

  You could try to change the IF statement to IF(G4<.01,"Hide","")