Forum Discussion
one spreadsheet with different looks
I think you have a few options to accomplish some of what you're looking to do:
Custom views - You may create and save custom views in the workbook. This would work for your filtered views. One downside, if there's at least 1 table in the workbook, this feature is not available.
Create, apply, or delete a custom view - Microsoft Support
Sheet views: - these are mostly used with co-authoring workbooks stored in the cloud. Sheet Views are available in desktop/web versions of Excel. It's helpful when you're working with others at the same time on the same file and you need to filter, for example, and not have it affect others' view. Potential drawback, you'd have to get others up to speed on this feature. It's very easy to forget to use sheet view!