Membuat drop down menu pada Microsoft Excel 2013

-
Hi teman-teman, saat ini saya ingin share cara membuat drop down menu pada microsoft excel menjadi seperti pada gambar dibawah ini.


1. Buat dulu list kategory yang akan menjadi menu. Cara yang saya gunakan adalah dengan mengetikkan kategori tersebut di tab kedua.


2. Tempatkan kursor di kolom yang ingin ditempatkan drop down menu, kemudian klik menu data, pilih data validation, dan pilih data validation.


3. Jendela data validation akan muncul. Masuk ke setting. Pada segmen Allow, pilih list, pastikan centang kolom in-cell dropdown, dan blok kategory yang telah dibuat. Kemudian klik OK


4. Drop menu telah terbuat di kolom yang diinginkan


5. Untuk membuat drop menu ini ke kolom yang lain cukup dengan drag ke bawah ujung kolom yang telah dibuat sebelumnya.


Demikian tutorial ini dibuat semoga dapat membantu.

Comments

Post a Comment

Popular posts from this blog

IELTS Academic Writing Task 1 - Map

-
Image
  Question:  The plans below show the site of an airport now and how it will look after redevelopment next year. Summarise the information by selecting and reporting the main features, and make comparisons where relevant. Answer: The maps illustrate the changes of southwest airport from existing layout to after development. Overall, there will be several expansions and features and facilities added inside the airport. There will be two expansions built in the airport. First, the waiting room. Southwest Airport will have 10 additional to gates from only 8 gates now to 18 gates after development. The area will be also larger with the extension to northwest and northeast so that it will look like a V shape. Sky train will be built to support travelers to ease mobilization. Small section of the arrival hall is also added and will be used for car hire. Other then sky train, there will be also bag drop located at the left-upper corner departure hall. It will replace the check-in counter
Read more

IELTS Writing Task 1 - Process

-
Image
  Question: The diagram below shows the process for recycling plastic bottles. Summarise the information by selecting and reporting the main features, and make comparisons where relevant. Answer: The flowchart illustrates the process of plastic bottles recycling. In general, the process of recycling involves at least 9 steps from collecting the bottle all the way to ready to use products such as fabrics or a new plastic. It all starts from waste bin where all waste is collected. The content of waste bin is carried using truck to recycling centre where waste is sorted according to its type. At this point, plastic bottles are collected then compressed into blocks to ease the transportation. These blocks then transported to another plant where the plastic blocks are crushed and washed. This makes plastic clean and smaller in size that ready to be used as ingredient of producing plastic pellets. In order to create raw material, the plastic pellets are heated to from in a special shape.
Read more

Naik pete-pete apa ke Mall Panakkukang?

-
Image
Jawaban: Pete-pete kode E Sumber gambar: Celebes Media Jadi pernah saya mau coba-coba naik angkutan umum dari Mall Panakkukang. Naik angkutan kota alias angkot atau kalau di Makassar disebut pete-pete akan lebih murah jika dibandingkan dengan jalur transportasi lain. Hanya 5 ribu rupiah maksimum. Kalau Anda sekarang sementara di Mall Panakkukang dan sedang mencari pete-pete, maka berjalan kakilah menuju ke jalan Pengayoman. Jalan pengayoman adalah jalur dari pete-pete kode E yang akan melalui rute seperti berikut: Mall Panakukkang - Jalan Pengayoman - Toko Alaska - Belok kiri ke jalan AP. Pettarani - Putar balik di jalan AP. Pettarani - Fly over - belok kiri ke Jalan Urip Sumoharjo - (optional) bisa ke Maccini - Jalan Bawakaraeng - Jalan latimojong - Jalan Andalas - Jl. K.H. Ramli/Laiya - Timur Makassar Mall . Bagi Anda yang ingin berbelanja, rute ini adalah rute yang pas, karena menghubungkan antara Mall Panakkukang, Toko Alaska, Pasar Terong , dan Makassar Mall/Pasar S
Read more