Forum Discussion
How do I Save a Specific Filter within a DataBase
I have a table of data with headers. I can Sort this data, and I can filter this data. What I would like to do is save a particular system of filtering this data, so that I can recall or re-use it ...
Custom Views never worked with structured tables, and it didn't work with Lists which was introduced before tables long ago.
If we speak only about sorting/filtering you may use Sheet Views Sheet Views in Excel (microsoft.com) if file is kept online (on SharePoint/OneDrive).
With all due respect, I viewed a video that clearly showed, mentioned, and discussed using Custom Views with Tables. Apparently, it was an earlier version, perhaps several versions earlier, but I would hesitate from saying Custom Views never worked with Tables. I can provide the video name and the time within the video when such a reference was made.
I will explore the Sheet Views option.
Again, thank you for your help.
I will explore the Sheet Views option.
Again, thank you for your help.
KSNelson1 I appreciate if you give the reference, will be very sorry then.
- https://youtu.be/5DwKhLVnMEg at 10:42
(This should be a video titled "Excel Database Part 1 - How to Use Excel as a database - Excel 2010, 2013, 2016 database tutorial")Thank you, but I see no table in this video. Range with frozen first row and filtering is used.