Hide Columns and Filter in a custom way

[rentonhighlands]

Hello:
I have many columns from left to right in my spreadsheet. I find myself always hiding columns to view data then un-hiding columns to view other data. Is there a way I can set up a macro or a saved quick or option so I can set up different views? In other words can I for example view #1 click a button and it auto hides my selected columns then option 2 view it hides a different set of columns.

How about the same thing for filtering. Can I set up custom filters for example filter #1 filters specific columns, filter #2 will filter other columns

I would like to know if there is a way to make custom options to hide columns and filter columns?

 

[MarkReddell]

One easy way to do this would be to group your essential columns together using the group command in the Data menu! NOTE: You may have move some of your data columns together to make this work!