Disable Autocomplete in Excel for Mac (Excel for Mac)

Topic

New Reply

Hi

Can anyone tell me how to disable autocomplete in Excel for Mac, I can do it Standard Excel but not in the mac version.

Many Thanks

Braddy

Reply | Quote

Replies

I don’t use a mac, but (If they are similar):
Tools – options – Edit (tab) – uncheck “enable autocomplete”

Steve

Reply | Quote

Hi Steve

No it is not the same for the Mac. It does not appear in the dialouge box in Tools /Options /Edit Tab.

Thanks anyway

Braddy

Reply | Quote

To disable AutoComplete, go to Edit > Preferences > Edit tab. Uncheck the Enable AutoComplete for cell values.
You can allso check Mactopia: Excel X: Have it your way: Favorite Excel preferences

Reply | Quote

Hi Tony

Thanks very much for your reply .

Braddy

Reply | Quote