Excel Tip of the Day


View function arguments as you enter a formula (Excel 97/2000/2002)


Chances are you've found yourself at a complete loss to remember the order of a particular function's arguments while you were in the middle of entering a formula. In such cases, you might launch the Formula Palette or scrap the formula altogether to look up the information in a reference. Fortunately, there's an easier way to jog your memory. After you enter the opening parenthesis for the function, press [Ctrl][Shift]A. Excel displays the argument names within your formula, which you can type over with the appropriate values.



(Content provided by Element K Journals)


(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
 
PrintPrint CloseClose

Copyright © 2001 - 2025 MJ Technologies, LLC.  All rights reserved.