The function screen tip is a small window that appears when you click into a function in the formula bar. Although this window looks quite simple, it is actually a very useful tool when editing and debugging Excel formulas.
When the function screen tip is visible, you can use it to precisely navigate the function arguments in a formula. The window is context-sensitive and its contents depend on the function the cursor resides in. As you move the cursor through a formula, the currently active argument is bolded. If the cursor is moved to a different function in the same formula, the arguments for that function are displayed.
If you click directly on the argument name, the text that makes up that argument will be selected. This is a powerful way to copy and paste into a formula without bringing in extra characters, or accidentally truncating an important character.
Finally, if the function screen tip window is in your way, you can move it to a new location using the four headed arrow.
An Excel function is a pre-built formula with a specific purpose. Excel provides hundreds of functions in various categories like dates and times, text, statistics, lookup, financial, engineering, etc. Most Excel functions require specific inputs,...
A function argument is a specific input to a function. For example, the VLOOKUP function takes four arguments as follows: = VLOOKUP ( value , table , col_index , [ range_lookup ]) Note most arguments are required, but some are optional. In Excel,...
In this video, we take a speed run through 23 tips you can use to save time with Excel formulas today. We try hard to make our videos quick and to the point, so this is a rapid-fire list, with more than 20 tips in about 10 minutes. We trust that you can rewind the video as needed :)