How to add drop-down selection to an Excel cell

1K Blog Marathon: Day 10

Level: Easy

Pre-requisite: Installed MS Excel, any version.

Note: For the sake of this hacktip, I will be using MS Excel 2013 (since it’s the available version installed on my PC. ^_^)

Sometimes, we have to create a list of fixed selection to a cell to avoid extra / unimportant / wrong data input. It is more useful to data like Student’s Course, Company Department, or even Cellphone brand. This is easy-peasy, so let’s start!

1. Open MS Excel. You can click ‘Start’ then type ‘excel’ and click the Excel icon.

2. Select ‘Blank Workbook’.

3. On cell A1 (top-most, left-most cell), type ‘Category’.
Make it bold (Ctrl + B) as it is our Column Header.

4. Add any category you want below. Because I am a fan of My Hero Academia, I will be using “Hero” and “Villain”.

5. Now click on any cell (mine is C1), and add ‘Name’.
Make it bold as well.

6. Adjacent to it (D1), add ‘Character Category’.
Again, bold.

7. Click on D2, then on the Ribbon Tab select ‘DATA’.

8. Locate and click ‘Data Validation’. A pop-up window will open.

9. On the ‘Allow’ dropdown, select ‘List’.
This means that the only allowed data in this cell comes from a list.

10. On the ‘Source’ textfield, click the button         .

11. Now, drag the mouse from A2 to A3.
Make sure not to include A1 as it is our header.

12. Click ‘OK’.

13. Now you can see the cell is now a drop-down cell with 2 options, Hero and Villain.

14. You can copy this style on the following cells below by dragging it down.

Thank you folks for bearing with me. You know I’m still ill because of fever (I wish it’s not Corona! ^_^). See you again tomorrow for another blog, and hope I will get better.

“And that’s one blog, stay hungry!”

“Microsoft Excel is one of the greatest, most powerful, most important software applications of all time.”

— James Kwak, “The Importance of Excel

Published by Christian Foster

Code-blooded, coffee-lover, tall, dark and chubby. I love to draw, has motion-sickness and a sleepy-head. BTW, graduate of BS Computer Science, Associate in Computer Science and certified UiPath RPA Developer. Loyal to my partner and a father of a cute bouncing baby daughter!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create your website with WordPress.com
Get started
%d bloggers like this: