Would you like to enter an Excel function in a cell without typing the entire function name? It is easy to do if you are familiar with the Formula AutoComplete feature in Excel.
To use this feature, click to select the cell in which you wish to enter the function. Type an equal sign and begin to type the function name. As you begin typing the function name, a list of functions appears below the active cell. The functions listed match the letters you have typed. Continue typing until you see the function you want.
Then, double-click the name of the function you want to use. The function and its arguments appear in a ScreenTip below the cell; you can use the ScreenTip as a guide to enter the necessary function arguments.
Give it a try! FormulaAutocomplete is another way to help you get your spreadsheets completed quickly and accurately.
For more information on the Business Office Systems and Support department, contact Becky Jones, Associate Dean, email@example.com 972-238-6215.
Have you ever started typing a person’s name or email address into Outlook’s To… field only to have the feature automatically fill in the wrong address? Or have you noticed that some of the names appearing in the list of matching email addresses from which you are to choose are no longer correct?
It’s very easy to clear infrequently used or incorrect names in Outlook’s AutoComplete list. Start by typing an email address in the To… field. When Outlook displays a list of email address options, use the Up and Down arrow keys to highlight the name/address you want to remove; press DELETE (or click the X at the end of the name).
You will be removing the name from Outlook’s AutoComplete list without removing the contact from your address book.
Questions about the Business Office Systems and Support course schedule? Contact Becky Jones, Associate Dean, at firstname.lastname@example.org or 972-238-6215