Turning on and off Auto Complete

%3CLINGO-SUB%20id%3D%22lingo-sub-2220663%22%20slang%3D%22en-US%22%3ETurning%20on%20and%20off%20Auto%20Complete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2220663%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20turn%20off%20Auto%20Complete%20for%20a%20project.%20The%20instructions%20are%20click%20%22File%22%20then%20%22Options%22%2C%20and%20I%20should%20see%20%22Advanced%22%20and%20then%20be%20able%20to%20uncheck%20Auto%20Complete.%20When%20I%20click%20%22Options%22%2C%20the%20only%20choice%20I%20get%20is%20%22Regional%20Format%20Settings%22%2C%20not%20%22Advanced%22.%20I'm%20using%20Windows%2010.%20Thank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETourist%20joan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2220663%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I'm trying to turn off Auto Complete for a project. The instructions are click "File" then "Options", and I should see "Advanced" and then be able to uncheck Auto Complete. When I click "Options", the only choice I get is "Regional Format Settings", not "Advanced". I'm using Windows 10. Thank you.

 

Tourist joan

1 Reply

@touristjoan 

File > Options > Advanced is available in Excel for Windows. The equivalent in macOS is Excel > Preferences.

 

What you describe is Options in Excel Online (the browser version); this is much more limited.