SEE: 30 things you should never do in Microsoft Office (free TechRepublic PDF) A dynamic validation listĪ validation list lets you limit users to specific values. The browser edition supports validation lists and Table objects, but inserting new data into a Table is awkward-that edition ignores the Tab wrap to the new record behavior when entering a new record. The VLOOKUP() function is available in earlier menu versions, but both techniques rely on the Table object to be dynamic, and the menu versions don't support the Table object. For your convenience, you can download the demonstration. I'm using Excel 2016 (desktop), but both techniques will work in earlier versions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |