Forum Discussion
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 reference this but only if the info is in the same column. How can I reference from another sheet/column?
1 Reply
- Look into Data Validation as the method, with that full list as the approved list.
https://exceljet.net/excel-data-validation-guide
