Shortcut key for accessing in-built functions in excel

In Excel, to open the dialog box for editing in-built functions (i.e.,Function Arguments) when you’re staying in a cell, follow the below steps.

Step 1

Type part of the name of the function inside the cell, you will receive suggestion to select the functions. Move to the required function using arrow keys or mouse and press Tab to select the function in the cell.

Select desired in-built function by pressing TAB

Select desired in-built function by pressing TAB

Step 2

To open the dialog box to enter the arguments of the function, press CTRL + a. Enter the desired values in the appeared dialog box.

Press CTRL + a, the dialog box for Function arguments will appear

Press CTRL + a, the dialog box for Function arguments will appear

 

Share This Post

Related Articles

Leave a Reply

© 2017 Techy Diary. All rights reserved.
Powered by Charvi Groups