If you use Conditional Formatting you will have come across the problem where edit using the arrows keys does not work in Conditional Formatting. A quick fix
A quick, simple method to build formula that will identify columns you want to hide and run a macro that will hide/ unhide these columns at a click of a button.