Forum Discussion
Excel / Auto Hide Rows
There is nothing in what you just posted that suggests you even read the prior response. Did you? Did you try either of the ideas presented there? So far as I know there is no formula, per se, that would hide the row although--as suggested in my prior response--it depends on what you mean by "hide."
The FILTER function would do it, on a separate page. And there was even a link to a page with instructions on how to use it.
Otherwise you're looking at a macro or a VBA routine, and that's not my field of expertise.
Hello! Sorry to awaken an older discussion. But I am facing the same issue and tried the FILTER function and absolutely love the functionality. However, I am trying to fill a cell that is merged and causing a Spill error. Due to the cells above I need to be able to maintain this merged cell. Can you think of any tricks to help me with this? I feel like I am so close to a solution with the FILTER function! Thank you! mathetes
- mathetesMay 31, 2024Silver Contributor
I'm sorry to have taken so long to get back. We've been on vacation in another country and I went, quite intentionally, without a computer. Only a phone, and that only for email and texts and calls, and those on a limited bases.
So with that, if you still are patiently waiting, would it be possible for you to post a copy of your workbook or a reasonable facsimile (in order to avoid disclosing private or confidential info), on OneDrive or GoogleDrive? Then paste a link here that grants access.