O.k. Need someone with "Excel-Fu"
Yes, I know I can use various calculators to store my recipes, BUT, when I'm mixing, I want to lay out all my bottles and those with common flavors, I want to drop that flavor in and then put the bottle away. That being said, I now have a spreadsheet listing all my flavors vertically, and all my recipes horizontally. I could rotate the table, but that's not the way I want to read it.
So, I want to "hide" the recipes I'm not making so I can read right across my spreadsheet, get the requisite flavors in, and move on. That seems to work very well for me. Does anyone know how to "filter" columns? When I turn on Filters, it's working vertically. I can hide columns individually, but that's a PITA - looking for something quick where I can click the recipes I want and then the remaining columns "auto-hide" because they're filtered
TIA