Excel not showing function suggestions is a situation that countless users encounter while experiencing this tool. TipsMake will help you fix errors with simple and quick steps.
Excel is one of the extremely important and widely used software. With this software, users will record data and present information in tabular form. At the same time, Excel also helps users calculate and process information quickly with 'huge' amounts of data. However, getting used to this software is not simple and some users may have some trouble when first working with Excel. Among them, Excel not showing function suggestions is also a common case. Don't worry too much because TipsMake will help you fix it right away.
What to do when Excel doesn't show function suggestions?
Turning on function name suggestions in Excel is a trick that many people are looking for when Excel does not show function suggestions. For those of you who often work with Excel, the suggestions for function arguments are extremely 'familiar' and useful. If unfortunately this suggestion disappears, many users will feel confused and worried about making mistakes when writing functions. Therefore, when Excel does not suggest function arguments, you just need to follow the steps below to fix it.
Instructions on how to solve Excel does not have function argument suggestions
- Step 1: Open Excel > Then click the File tab.
- Step 2: Select Options > When the Excel Options dialog box appears > Users select Advanced in the left menu.
- Step 3: Scroll to Display > Click on Show function ScreenTips > Click OK.
Or you can find the Ease of Access section in the Excel Options dialog box and check the Show function ScreenTips line under the Feedback options section.
After turning it on, please return to Excel to see if the function suggestion is displayed or not!
Instructions for displaying the formula bar in Excel
Excel not displaying formulas on the toolbar or Excel hiding the formula bar is also a situation many people encounter. If you want to show it again, just do the following:
- Step 1: Open Excel > Click the View tab.
- Step 2: Tick the Formula Bar line and you're done.
In case the user wants to hide this formula bar to expand the working interface. You just need to uncheck the Formula Bar line and you're done.
The steps are done in Excel 2016. In other versions, there may be some differences.
Above are instructions to fix Excel error of not showing function suggestions. It's simple and fast, right? Wishing you success!
You've just finished reading the article "Excel does not show function suggestions and the fix is very simple" edited by the TipsMake team. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.