Forum Discussion
James1921
Oct 07, 2021Copper Contributor
excel auto correct
version for Mac,16.47.1 I have a list of names on one sheet. I would like to reference those names on another sheet of the same workbook by typing the first 2 letters of the name. Auto correct will...
mathetes
Oct 08, 2021Gold Contributor
Look into Data Validation as the method, with that full list as the approved list.
https://exceljet.net/excel-data-validation-guide
https://exceljet.net/excel-data-validation-guide