Working with Excel Formula Shortcuts | Excel tips & tricks

Yodalearning>Tutorials>Working with Excel Formula Shortcuts | Excel tips & tricks

Learn Excel Shortcuts Formulas to make your life 4x faster & Download excel cheat sheet

4 Excel shortcuts that can save tons of your time and make you look cool.

1. How to activate the “Function Argument” dialog box after writing a function in Excel?

E.g. After writing “=VLOOKUP(” – ensure bracket is open, press Ctrl + A

Before:

excel shortcut formula

 

After:

This excel shortcut allows you to activate function argument dialog box without clicking on “fx” button for “Insert Function” (besides Formula bar)

 

Excel-trick-2.img1


2. How to go back to the function argument dialog box after executing your function?

Click on the cell where your function result appears, then press Shift + F3.

Before:

Excel-trick-3

 

After:

With this Excel shortcut, you can modify the function argument and the result will change.

Excel-trick-4


3. How to toggle up and down inside the function argument dialog box?

Use Tab key to toggle downwards and Shift + Tab to toggle upwards through each cell.

Excel-trick-5

 


4. How to check the functions used in a cell (E.g. VLOOKUP, Sum)?

Select the cells whose functions you wish to view and press Ctrl + ` (This key is above the Tab key on the keyboard).

excel-trick-6

Before:

Excel-trick-7

After:

Excel-trick-8

 


Watch the above Excel Tricks in this 3 min video:

By using these Excel Shortcuts you can save time and improve your efficiency and productivity. You can watch more such #YodaHacks videos our  YodaLearning YouTube channel.

For more such smart tricks visit our Advanced Excel Tutorials section or enroll for our FREE Online Excel course

Working with Excel Formula Shortcuts | Excel tips & tricks

Advanced Excel Course

Your courses were useful for me. Thank you again for your quick support and also for your availability.

- Madalina Elena Gheorghe

Free Excel Course
with 210+ Tricks
(UPDATED 2017)