Forum Discussion

rljoyce2's avatar
rljoyce2
Copper Contributor
May 05, 2025

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.

Thank you.

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond 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.

  • mathetes's avatar
    mathetes
    Gold Contributor

    Could you, uh, maybe give us a more complete description of the problem? Auto-complete what? What are you trying to enter that is left incomplete? What are you expecting?

Resources