Displaying Function Arguments with Control + Shift + A

When we try to enter a function in excel, it will helps us by showing the tip or hint bar with all the arguments. The current argument will be in bold and each argument will be separate by a comma in between. Suppose instead of seeing them in the hint bar, if you want them to see in line with the formula, you just need to press Ctrl + Shift + A. Here the current argument will be highlighted and when you type something it replaces the highlighted argument,.

Type ’=VLOOKUP(‘ and then press  Ctrl + Shift + A then it will display as ‘=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)’

FnArguments


   2 Comments


  1. WilliamsoR
      June 4, 2016

    Thank you ever so for you article.Thanks Again. Really Great. Shrader

  2. Tony
      October 10, 2017

    good

Leave a Reply

Your email address will not be published. Required fields are marked *