11/11/2023 0 Comments Excel for mac autocomplete not workingHide these rows and use this formula in the On Sheet1 A1 Enter =Sheet2!A1 and copy down including as many spare Lets say your list is on Sheet2 and you wish to use the Validation List is Dynamic and/or Resides on Another Worksheet Now, as you type Excel will look at the list above the Validation cellĪnd AutoComplete based on it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |