Assalamualaikum! Hello people! Today, I'm going to share something new for me related to how to make a drop down list in Excel. Scroll til the end of the post to download the template if you are too lazy to read it k. ^^
Tadaaa! As you can see, I've just finished editing a RPH template with drop down list items since I am that lazy to type and wasting more time on that. So, let me give you some tutorial on how to make one!
WHAT DO YOU NEED :
- Microsoft Excel (any version)
- DSKP (of any subjects that you teach)
- Patience (yessss)
HOW TO DO IT?
1. Launch the Microsoft Excel.
2. Click for Sheet 2 and rename it. (I renamed it as Monday).
3. Create a template of your RPH on Sheet 2. I just copied 2017's template and upgraded it in this kind of form. Simple black and white to save my ink for printing.
4. Back to Sheet 1 (I renamed it as Drop Down List Menu). In this sheet, fill in the information that you will use for the drop down list items. Make sure you type it in LIST FORM. Just like this :
5. After that, select the rows and right click. Click "Define Name". Something like this (below) will popped up. Just rename the "MONDAY" on the popped up window to something related. So that later, you will use this "NAME" as the reference cells to make drop down list.
6. Then, click Sheet 2 (or whatever that you have renamed it). Click on the box that you want to apply the drop down list menu. Click Data, then click Data Validation. A popped up window will appear. Click List, then at the Source, type "=name". name here is the name that you used in Step 5. (Its a must to put the = sign)
7. To check whether it works, you can find it out immediately. It will turn out with a symbol at the end of the row for drop down list items. Like this :
So, that's it! A pretty simple one that I got from YouTube. You can check the tutorial that I have referred HERE. For any inquiries, do email me at hidayu1409@gmail.com.
P/s : No worries, if you are too lazy to make one, just download the template by clicking the icon below. Edit and make it yours! :)
RPH TEMPLATE FOR ENGLISH LANGUAGE YEAR 2 (2018)
