anything in Excel...

It's Excel-o-lozy...

Tip - Open Formula Dialogue Box quickly

Sometimes we know the formula but just name of the formula, not the details that how it works.

For that "fx" (button before Formula Bar) is clicked.
It opens up a Formula Dialogue Box that makes us master of formulae.
The tip to quickly open the box is:
Ctrl+A
How?
Typing the full name of the function
and press Ctrl+A
e.g. type =If and press Ctrl+A
It'll open the Formula Dialogue Box..

Cool right? wait for next 1...

0 comments: