Sunday, 14 April 2013

“F4” FUNCTION KEY FEATURES IN EXCEL (PART - 3)



Today we will talk about another combination of keyword with F4 Function Key. Which is different from previous topics.
F4 Function Key

This will help you out when you are searching any word from your database again and again. Yes, what is the procedure of finding any particular word from your database in Excel. Its like this, Go to  Edit> (SELECT) Find

Thursday, 11 April 2013

“F4” FUNCTION KEY FEATURES IN EXCEL (PART – 2)


F4 Function Key
In last post we discussed how “F4” Function Key is useful in to minimize daily work in Excel. Today we will discuss about “F4” Function Key again but with the combinations of other keys.

As all of we know that when we want to close Excel file there are only two ways.








1)      Click on Black Cross button below the Red Cross button when you want to close only Active Workbook but not all Open

Wednesday, 10 April 2013

“F4” FUNCTION KEY FEATURES IN EXCEL (PART - 1)



F4 Function Key
Hello Friends,
I came with new interesting features of Excel.
 Today I will tell you about “F4” Function key, which is useful in our regular work on Excel. I ensure you that after reading this post you will be able to minimize your work very much.

There are many features of “F4” Function key. It gives you different result by using it with different combination of keys.






Here we will know what are the effects of using the “F4” Function Key. Let me explain you an example,


E.g.















F4-FUNCTION KEY FEATURES

If you have some work such like in example so what to do.
You think what’s new in this and what’s the use of  “F4” Function Key in this

Sunday, 7 April 2013

TRUE & FALSE ALWAYS IN UPPER CASE



Hi friends hope you like this Post. I want to tell you something interesting topic for MS Excel.

As all of we know that if we want to write any word in Capital (Upper Case) in Excel or anywhere else we will ON Caps Lock and OFF to write in Lower Case. But. do you know there are two words which are exception. Those two words are such, that can’t be written in Lower Case. Yes, you can’t write those in Lower case.

Those two words are,
1) TRUE
2) FALSE

Yes, these words are such that can’t be written in Lower case. After keep Caps Lock OFF