Using Excel Web app to manage spreadsheets skillfully

The company is going to organize a field interaction with Qingyuan next month, the theme is to strengthen the team collective consciousness of the staff, in order to better complete this field interaction, the company prepares for each employee to be equipped with one clothes, organizes several different teams separately, my small team has 8 people, but I was fortunate to be the team's small captain, therefore, The first question I need to do now is to "count the size of my organization's members ' clothing" and submit it to the executive to help with the purchase.

All, first step, I want to create a spreadsheet, and simply apply a table style to it, get the following icon:

We know that the size of clothes are generally divided into m,s,l,xl,xxl and so on, for the convenience of statistics, I will define clothing size for a list, so that team members in this list to choose, so, here, I use the data validity.

First, I use the name manager to define the "dress size" list, which operates as follows:

Select the data range, and then click Name Manager to create a new, open the following Edit Name dialog box to define a name named "List", as follows:

Next, use data validation to define the clothing size list;

Select a good cell, click Data validation, data validation, as follows:

Open the following Data Validation window, select the Allow window as sequence, and the source window directly equals the "List" you just created, as follows: