Using list in MS Excel

Hello All,

Today I am going to tell you about a wonderful feature of MS Excel. Do you know we can create a list in excel, It can be used by many ways, but I will give you an example of an attendance sheet.

Following are the simple steps to understand about the same :-

Step 1- First of all we have to make a table, which contained name of the students/employees and days of attend class/office.

As I created tables and write down the employees name and day of attendance.

Step 2- Then after write down some abbreviations of attendance initials in other worksheet((Source table)), as I created in sheet2:

It will be display after whole process by clicking any cell.

Step 3 –After create source table, again goto the sheet1 and select whole cells which required these source table values and select Data validation option in Data tab:

After click on data validation , click on the list option from “Allow” drop down list.

Step 4- Then after select source from the source table and hit OK:

Step 5- Go back to the sheet1 and select the values from drop down list.

Drop down list will be appear as shown in green box and if value entered other then the source table, It will popup the error message as in red box…..

                      For more interesting facts about MS-Excel…. ….. Keep visiting 😉


नमस्ते _/\_ to all . This is JOY DUTTA working in Spark Minda group as a IT Engg from last 4 years , I completed my Diploma from Goverment Polytechnic Dehradun in Computer Science And Engg in 2011.Well, above i written my Qualification and My JOB Role. now i am tell you about Who am i as a person. I am a fun loving guy who love Acting, Dancing, Hangout with friends, I believe in Smart work Rather Than Hard work. I love computers because I love Computers :)In short I am interesting guy if you want reveals more about me You should to meet me. if that not possibleMail me :- or Join me on Facebook:-

Leave a Reply

%d bloggers like this: