Share via

Auto text complete question

Anonymous
2023-02-14T22:37:36+00:00

In my excel spreadsheet I have some columns cells working with auto complete text and other column cells don't. How do I change these settings to allow or not allow or individual cells using auto text in these columns.

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-15T01:57:46+00:00

    Dear John Tulloch,

    Greetings! Thank you for posting in Microsoft Community.

    As per your description, it seems that you are trying to change the settings to allow or not allow or individual cells using auto text in these columns.

    May I know if you want to disable the AutoComplete function that fulfill the text in that column with an existing entry as shown below?

    If yes, generally, Microsoft Office Excel completes text entries that you start to type in a column of data — if the first few letters that you type match an existing entry in that column. If you want to stop automatic completion, you can turn this option off.

    1. Click File > Options.
    2. Click Advanced, and then under Editing options, select or clear the Enable AutoComplete for cell values check box to turn this option on or off.

    For your reference: Turn automatic completion of cell entries on or off - Microsoft Support

    If the scenario above is not consistent with yours, you can also post back and point that. At meantime, would you please also share some screenshots with us for a better understanding?

    Your understanding and patience will be highly appreciated. We hope that you are keeping safe and well!

    Sincerely,

    Rhoda | Microsoft Community Moderator

    Was this answer helpful?

    0 comments