How to Fix Excel Suggesting IMLOG10 or LOG10 When Entering Cell References
Question details
The user needs to prevent Excel from displaying function suggestions (like IMLOG10 and LOG10) when typing standard cell references such as =G10.
- Product
- Microsoft Excel
- Device & OS
- Mac and Windows
- Scenario
- Typing a simple cell reference into a cell or the formula bar.
- Observed behavior
- Excel's AutoComplete feature mistakenly triggers function suggestions containing the typed characters instead of just recognizing the text as a cell reference.
Keep in mind that this is standard behavior for Excel's Formula AutoComplete and does not alter your spreadsheet data unless you actively press the Tab key to accept the suggested function.
Adjust Formula AutoComplete Preferences
Change your application settings to disable formula suggestions or require more characters before they appear, preventing unwanted pop-ups.
By modifying the AutoComplete threshold, you can tell Excel to wait until you have typed three or four letters before it suggests functions, which effectively stops it from triggering on short cell references like G10.
On Mac, go to the top menu bar, click on 'Excel', and select 'Preferences'. On Windows, click on 'File' and select 'Options'.
On Mac, select 'AutoComplete' from the Preferences menu. On Windows, navigate to the 'Formulas' tab in the Options window.
Disable 'Formula AutoComplete' entirely by unchecking the box, or change the setting to require three or four letters before formula suggestions appear.
Close the Preferences window on Mac, or click 'OK' on Windows to apply your new settings.
Use Keyboard Shortcuts to Dismiss Suggestions
Quickly bypass the AutoComplete suggestions using your keyboard without altering any core Excel settings.
Experience Smoother Spreadsheet Editing with WPS Office
If Excel's AutoComplete quirks are slowing down your workflow, consider switching to WPS Office. It provides a highly compatible, free, and lightweight spreadsheet alternative with intuitive formula inputs and a seamless transition from Microsoft Office.
- 1. Download the Installer: Visit the official WPS website and download the free WPS Office installer for your operating system.
- 2. Install WPS Office: Run the setup file and follow the on-screen prompts to quickly install the suite.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel files to enjoy an optimized editing experience.
Frequently Asked Questions
Does pressing Enter apply the Excel AutoComplete suggestion?
No, pressing the Enter key registers the exact text you typed (like =G10). The AutoComplete suggestion is only inserted into your formula if you press the Tab key.
Why does Excel suggest IMLOG10 when I type G10?
Excel's Formula AutoComplete dynamically searches for any function containing the sequence of characters you are typing. Because both 'IMLOG10' and 'LOG10' contain 'G10', Excel automatically presents them as suggestions.
Can I completely turn off formula suggestions in Excel?
Yes. You can disable Formula AutoComplete entirely by going to File > Options > Formulas in Windows, or Excel > Preferences > AutoComplete on Mac, and unchecking the 'Formula AutoComplete' option.
