Named ranges in Proton Sheets
I use named ranges extensively in any spreadsheet I create. They supercharge things like VLOOKUPs or data validation with a list of possibilities.
Rather than entering a fixed cell reference, I create separate data source or menu option sheets and name the ranges. I then reference those ranges in my lookups or data validation. The data source lists can be modified, sorted, formatted, etc independently of the cells or tables that reference them, and it can be done without having to actually edit the lookup formula or data validation setting.
Anonymous
shared this idea
-
Anonymous
commented
To clarify, if you select Data > Data validation, there’s a button to add a named range. It doesn’t. It adds a data validation rule. This request is for the type of named range feature like what’s available in Excel or Google Sheets.