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
as shown in Pic.3.1. which you can do by CTRL+F also.
as shown in Pic.3.1. which you can do by CTRL+F also.
F4-FUNCTION KEY FEATURES-3.1
By above steps you will get one window to in which you write
word which you want to find from data. In this Picture
You can see that the active Sheet is DATA1 sheet. Just as an example you will search “MIHIR” word from your database and you can find it easily as all of we know.
You can see that the active Sheet is DATA1 sheet. Just as an example you will search “MIHIR” word from your database and you can find it easily as all of we know.
F4-FUNCTION KEY FEATURES-3.2
But some time it happens that you want to search this word
from another databases as an example right now you are searching in DATA1 sheet
and after from DATA3 sheet also here we are taking example that’s why its just
two sheets there may be many sheets in your database.
F4-FUNCTION KEY FEATURES-3.3
And when this process is repeating again and again then its
not right way to follow above steps to find particular word. Yes, you can find
this repeated word just by one click by selecting OPTIONS>WITHIN=WORKBOOK>FIND
ALL and you will find the word from all sheets available in all sheets in the
same Workbook as shown in the below Picture.
F4-FUNCTION KEY FEATURES-3.4
But if you want to find the same word in another Workbook
then may be you will do the same procedure which you done in previous Workbook.
In this situation you don’t have to repeat it but just use “SHIFT+F4” and you will get the same result for the word which find last.
Hope you will be able to learn again new feature for F4
Function Key by given examples. If you have any quarries elated this Post
please let me know or ask your Questions below this post and if you really like
this Post please give me your valuable Feedback to improve my contents on this
Blog.
Kind Regards,
Pratik Dave
Kind Regards,
Pratik Dave
Hi Pratik,
ReplyDeleteCongratulation,
You are doing great job with this blog. I have found this blog as very useful for the peoples who are having such willingness to learn about Microsoft Excel. I do have interest to learn about the Visual basic & Macro editing with codes. I want to you to create special page for this subject and update codes with the usefulness and details about how it will be action in excel..
Your well-wisher,
Gaurang Bhatt
@Gaurang: Thank you Gaurang to take interest in this blog...
ReplyDeleteAs i also want feedback from my reader i'll surely try to apply your idea here. i'll also write post on Macro codes and all which will be helpful to you. If you have any query related to Excel and all just got to end of this page and ask you query. i'll do my best solve it to satisfy your requirements..
Thanks,
Pratik Dave