novicee Posted November 6, 2011 Share Posted November 6, 2011 (edited) Excel 2007 : Is it possible to conditionally hide a row? Is it possible to make the visibility of a row conditional on a value in a cell of the row? For example, can a row be hidden if the first cell of the row contains the value 5 but otherwise the row is visible? Ditto question for columns. The question comes up in the context of time series that are step functions. Any help would be appreciated. I couldn't find an answer in Excel 2007 Help. - Novice Edited November 6, 2011 by novicee Link to comment Share on other sites More sharing options...
IcemanND Posted November 7, 2011 Share Posted November 7, 2011 You could use the Filter feature on the Data tab to filter rows but not columns.If both are needed I think you would have to use a VBA function called on a worksheet change if you want it to happen any time a monitored value changes. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now