![]() When you delete items, you need to delete the table row instead of only the value. You may spend more time on performing the process.Ģ. When there are other items or blank cells in the range, the drop-down list will be in a mess.ġ. If you are not familiar with the OFFSET function, you may meet with errors when modify the formula.Ģ. When you also need to use table or define name, you can save a lot of time on those other tasks.ġ. By using this method, you can still input items in other cells in the same row or column.Ģ. By using the function, the worksheet will not be in a mess.ġ. But still they have advantage sand disadvantages. Otherwise there will be a blank item in the list.īoth of the two methods are very effective. When you need to delete an item, remember to delete the table row. The next time when you add a new item in the source range, the drop-down list will also update.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |