How to display function arguments in Excel
You often use functions in Excel to calculate but there are many less used functions, so you do not remember the argument in the function. You do not need to worry because Excel supports the function's display of arguments so that you can use the function easily.
The following article shows you how to display function arguments in Excel.
Option 1: Select any cell in Excel you enter the syntax = [function name] and press Ctrl + Shift + A , at this time the arguments of the function you enter are displayed in the cell and on the function bar.
For example, if you want to display the arguments of the SUM function, select an Excel cell and enter = SUM and press Ctrl + Shift + A.
Method 2: If you want the number is displayed in more detail, then you enter the syntax = [function name] into any cell and press Ctrl + A .
For example, you want to display the detailed argument of the SUM function, select a cell and enter = SUM then press Ctrl + A.
The Function Arguments dialog box appears, you can enter the value directly for the function arguments if needed and click OK .
The article has shown you two ways to display function arguments in Excel, if you do not remember which function arguments you can display arguments quickly.
Good luck!
You should read it
- COUNT function - Function that counts cells containing numbers in the list of arguments in Excel
- AVERAGEIFS function - The function returns the average of the arguments that meet multiple conditions in Excel
- AVERAGE function - The function returns the average of the arguments in Excel
- How to use ADDRESS function in Excel
- COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel
- COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel
- AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values in Excel
- Basic Excel functions that anyone must know
May be interested
- Tricks to import data in Excel fastestfrequently use excel to enter data, calculate and process data. if you enter data faster, the time spent on calculating and processing data will be more. there are many faster ways to import excel data that you can use.
- How to change gridlines color in Excel?the default grid lines in excel are black, but if for some reason you want to change the grid color in excel. if you do not know how to change the color for grid lines you can follow the article below.
- Take screenshots with Screenshot Tool in Word 2013microsoft word 2013 supports a lot of useful features, and one of them is a screenshot. with the screenshot tool, you can quickly take screenshots of your computer and insert them into word documents.
- How to view Word documents with black and white background in Inverse mode in Word 2013in word 2013, if you want to focus on reading the document, you can switch to reverse reading mode - inverse. word will collapse the toolbars and switch to black and white text to help readers read documents more effectively.
- The fastest way to calculate lines and columns in Word 2013you often use excel to calculate data in tables, but if that data is in a word document, you can also perform calculations directly in word without spending time using applications. use calculator support.
- Insert date and time in Word 2003, 2007, 2010, 2013you want to insert date and time in word to track the time right on the word document more quickly. the following article shows you how to insert date and time in word 2003, 2007, 2010, 2013.