How to create a filter in an Excel cell
Dexterity Software gets a lot of questions from readers about how to create filters in an Excel cell, or some of the readers also called drop-down lists that allow people to select an item from the list you create.
How to create a filter in an Excel cell Picture 1
Today, Dexterity Software will guide readers in the most detailed way how to create filters in an Excel cell.
Consider the specific example as follows, need to create a list of products including: Men's shirts, Women's shirts, Women's dresses so the importer selects a product item from the list you have created.
How to create a filter in an Excel cell Picture 2
The way to do this is as follows:
Step 1: Create a product listing on a separate worksheet.
Create a new sheet, enter the product entries you want included in your drop-down list.
How to create a filter in an Excel cell Picture 3
Step 2: Convert the product list to a table ( Table ) in Excel.
- Select any cell in the data area containing the product list. Press the key combination Ctrl + T .
- Create Table window appears, if your data contains headlines, click My table has headers , if not, then uncheck.
- Click the OK button to set the Table table .
How to create a filter in an Excel cell Picture 4
Step 3: Return to the working worksheet. Select the cells in the worksheet you want to place the drop-down list.
How to create a filter in an Excel cell Picture 5
Step 4: On the Data tab (1) => Click on the Data Validation icon (2) .
How to create a filter in an Excel cell Picture 6
Step 5: Data Validation window appears. On the Settings tab , Allow (1), click List .
How to create a filter in an Excel cell Picture 7
The Source (2) section selects the range of item ranges your product created in Step 1 .
Note that you omit the subject line because otherwise, the subject line will form another option.
How to create a filter in an Excel cell Picture 8
- If you want the user to leave the box blank, select Ignore blank , if you force users not to leave the box blank, uncheck the box.
- Select In-cell dropdown (filter box to select options).
Step 6: Switch to the Inut messeger tab .
If you want a notification to pop up when the user clicks on that box, select the Show input messeger when cell is selected (1) check box , then type the title and content you want to notify (2) (maximum 225 characters). If you do not want to be shown, deselect this item.
How to create a filter in an Excel cell Picture 9
Step 7: The Error Alert tab is used to set up an error warning if the person who entered the product item is not in the list you created at the beginning.
If you want Excel software to report errors, select the Show error alert after invalid data is entered (1) check box .
Select the symbols that appear in the case of errors in Style (2) and enter the title and message content (3) if necessary.
How to create a filter in an Excel cell Picture 10
Step 8: Click the OK button to start running Data Validation . The result is:
How to create a filter in an Excel cell Picture 11
When you click on a cell where you have Validation installed , the selection arrow box will appear to the right of the cell, click the arrow and select items from the previously created list.
How to create a filter in an Excel cell Picture 12
Or you can type the item directly into the cell. If you make a mistake, Excel will display a warning window:
How to create a filter in an Excel cell Picture 13
In this case you just need to press the Entry button and re-enter the correct data.
Above Software Tips guide you how to create drop down lists with tools available in Excel. Good luck!
You should read it
- How to automatically create valuable cell borders in Excel
- Instructions on how to create diagonal lines in Excel box
- Guide to Automatic Filter and Filter detailed data in excel
- How to create spaces between letters and cell borders in Excel
- MS Excel 2007 - Lesson 8: Sort and Filter
- Diagonal lines in a cell in Excel
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- Filter data that doesn't overlap in Excel - Filter for unique values in Excel
- How to wrap text in an Excel cell - Wrap text in an Excel cell
- How to name a cell or Excel data area
- How to create notes for documents in Excel
- How to Create a Drop Down List in Excel
May be interested
The way to sum the same codes in Excel
Function Address - The function returns the address of a cell in Excel (usage, examples, examples)
Alignments in Word 2007 standard and fastest
How to fix There was a problem sending a command to the program when opening Excel files
IRR function in Excel - Usage and examples
How to create a template for PowerPoint presentation slides