There are times when you need a function in Excel and you know what it has to do with and perhaps part of the name, but just cannot remember the full function name! I know as I age it happens to me more frequently than I care to admit!
If you, like I, have the same problem, follow the steps below to get some help with your Worksheet Functions:
- If the function has a lengthy name, key in what you remember and click the Tab key to AutoComplete the name for you.
- Once you have the function name, plus the first open parentheses, key in the part of the name you can recall and click CTRL + A to display a dialog box to help you complete the functions with explanations of each argument.
- For more information on the function, click on the Help on this function link on the left-hand bottom corner of the Function Arguments dialog.