Excel does not show function suggestions and the fix is very simple

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.

Excel does not show function suggestions and the fix is very simple Picture 1

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.

Excel does not show function suggestions and the fix is very simple Picture 3

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.

Excel does not show function suggestions and the fix is very simple Picture 5

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. Excel does not show function suggestions and the fix is very simple Picture 7

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!

David Pac

Update 09 January 2024

You should read it

May be interested

How to use COUNTIF function on Excel
the countif function on excel is the cell count function to satisfy the given condition, often used in statistics tables.
How to use the MOD function and QUOTIENT function in Excel
injury in excel has many ways of doing it, can be used manually or using the calculation function.
8 little-known Excel functions that can save you a lot of work
even seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.
How to use MID functions to get strings in Excel
mid function in excel is a function that takes the middle character string corresponding to the value that the user requires to perform.
How to use Excel's VALUE function
excel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
How to use the WRAPROWS function in Excel
having trouble with handling large data sets in excel? then learn how to use the wraprows function to split them into more manageable rows.
How to use the IFS function in Excel 2016
the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.
How to use the NPER function in Excel to plan loans and savings
do you want to effectively manage and control your personal finances? then we invite you to learn how to use excel's nper function.
How to use the function to delete spaces in Excel
deleting white space with functions in excel makes it easier for users to handle content, instead of traditional editing.
How to fix the SUM function doesn't add up in Excel
in the process of summing with sum in excel, you will encounter some errors such as not jumping the number, not adding the sum. so how to handle this problem?