Forum Discussion
rljoyce2
May 05, 2025Copper Contributor
Automatic completion of cell values
I have a 365 subscription. I checked Options, Advanced, Editing and Enable Auto Complete for cell values is turned on. Spread sheet still does not auto complete. Please need a suggestion. Than...
SergeiBaklan
May 06, 2025Diamond Contributor
That's what you can do with this option
Other words, if in cell above you have text "abc", and in cell below you start typing "a", Excel suggests to complete the cell with "abc", just exit cell editing mode by arrow or Enter.