•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Data Validation Reference vs noted
Our take
When working with a worksheet as a floor plan and booking system, efficiently adding notes to cells can be challenging. The traditional Microsoft note feature often feels clunky, with issues like poor visibility when zoomed out and editing difficulties. This raises the question of whether using Data Validation (DV) references might be a more effective alternative. While the DV approach can streamline information display, it’s essential to weigh the pros and cons compared to notes, especially considering the viewing-only access of other users.
When trying to add a note to a cell on a worksheet, the most common way is to use the MS note feature.
I find that feature to be clunky, prone to bad editing, and really hard to see when the sheet is zoomed out. (We use it as a floor plan and booking system, not sure what’s the better alternative, taking suggestions!)
Other than users not seeing a ‘little red flag’ in the notes, is there any other pros and cons of using DV reference over notes? I’m the only one editing the sheet everyone can only view.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience