Based on a cell value = true or false, I conditionally formatted rows to turn black. That means that I need to scroll down to find the set of rows that did not turn black. I would prefer that all my rows with data remain unexpanded and remain hidden and only expand when cell value = true. Is there a way to unhide the few, select rows when the cell value = true and compress/hide if cell value=false - without using macros; or any macro code suggestion if one is needed. This will forego the scrolling.
Subscribe to:
Post Comments (Atom)
How can I VLOOKUP in multiple Excel documents?
I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...
-
Is there an official source for Windows ISO (XP+) checksums, online? Wanting to download some older Windows versions, for support purposes, ...
-
I want to create a circular chart in Excel with 8 sectors like in this example: Instead of representing the percentage like in a pie chart, ...
-
I have several folders with Magento installations. e.g. www/magento1 www/magento2 All of the files/folders inside of those are owned by root...
No comments:
Post a Comment