You are definitely good to work with Microsoft Excel and to manage your daily task for quick reviews. But if you read this article till the end you will surely learn something more and fantastic today.
Alright, let's get started. In this article today, I would like to teach and share with you the knowledge that I have and what I have actually acquired after doing a lot of research on this topic.
Being a user of MS-Excel with just a taught knowledge by the teachers is not enough. So, I carry a bundle of questions in my mind when I find a difficult task one day and need an urgent answer for it.
To create a search box for searching data in MS-Excel, you require to know special codes. How to start coding? I will tell you now.
Firstly, you need to open the MS-Excel in your PC or Laptop then, frame the table required for the names of students or any; at least 10 of them. Then, provide the headings like, Name & Surname, Class, Roll No., Age, Sex etc. Please remember not to start right from the beginning of the rows or cells. You need to leave some rows for a search box. After that, you design the search box by giving border to it.
Select a particular cell for a Search Box and you have to apply code in it by going to the Conditional Formatting and from the drop-down menu select the option Manage Rules… available at the bottom. Next you will find a new window and change the option Current Selection to This Worksheet followed by selecting the New Rule… . Here too another window will pop up and you need to select the last option Use formula to determine which cells to format. Once you are done with you have to apply this code.
Depending on your creativity, you can design the font style, size and colour. Meanwhile you can also apply shadings and border from the available options. When it is done click “OK” to proceed to the next step.
This is the final step and as you proceed you have to select the table range by dragging the mouse cursor for the execution of the code. Once you have done with that select “Apply” to get the result. So, that is it.
However, if you find the error that occurred after you have completed the above details then, get back to the Conditional Formatting follow the same steps again. Note that after selecting This Worksheet next step is to select the Edit Rule… , re-type the code or paste it if you have copied before and click “OK” when you are done.
Finally you need not select the table range instead, just click “Apply” and it is done.
To create a search box for searching data in MS-Excel, you require to know special codes. How to start coding? I will tell you now.
Firstly, you need to open the MS-Excel in your PC or Laptop then, frame the table required for the names of students or any; at least 10 of them. Then, provide the headings like, Name & Surname, Class, Roll No., Age, Sex etc. Please remember not to start right from the beginning of the rows or cells. You need to leave some rows for a search box. After that, you design the search box by giving border to it.
Select a particular cell for a Search Box and you have to apply code in it by going to the Conditional Formatting and from the drop-down menu select the option Manage Rules… available at the bottom. Next you will find a new window and change the option Current Selection to This Worksheet followed by selecting the New Rule… . Here too another window will pop up and you need to select the last option Use formula to determine which cells to format. Once you are done with you have to apply this code.
Depending on your creativity, you can design the font style, size and colour. Meanwhile you can also apply shadings and border from the available options. When it is done click “OK” to proceed to the next step.
This is the final step and as you proceed you have to select the table range by dragging the mouse cursor for the execution of the code. Once you have done with that select “Apply” to get the result. So, that is it.
However, if you find the error that occurred after you have completed the above details then, get back to the Conditional Formatting follow the same steps again. Note that after selecting This Worksheet next step is to select the Edit Rule… , re-type the code or paste it if you have copied before and click “OK” when you are done.
Finally you need not select the table range instead, just click “Apply” and it is done.
 |
| Click the above link to DOWNLOAD the Tutorial Source Code |
Watch this Video
