Add data validation to a cell or a range Select one or more cells to validate. On the Data tab, in the Data Tools group, click Data Validation. On the Settings tab, in the Allow box, select List. In the Source box, type your list values, separated by commas. ... Make sure that the In-cell dropdown check box is selected.
To filter data: Begin with a worksheet that identifies each column using a header row. ... Select the Data tab, then locate the Sort & Filter group. Click the Filter command. ... Drop-down arrows will appear in the header of each column. Click the drop-down arrow for the column you want to filter. ... The Filter menu appears.
Select a cell where you want to insert a hyperlink. Right-click on the cell and choose the Hyperlink option from the context menu. The Insert Hyperlink dialog window appears on the screen. Choose Place in This Document in the Link to section if your task is to link the cell to a specific location in the same workbook.
Method 1 Inserting a Link to a Location in the Spreadsheet Select the cell that you want to create your link in. ... Click the " Insert" tab and then click " Hyperlink." ... Click the " Place in This Document" option in the left menu. ... Enter the cell that you want to link to. ... Change the text that is displayed (optional).
You can also right-click the cell or object and then click Hyperlink on the shortcut menu, or you can press Ctrl+ K. Under Link to, click Existing File or Web Page. Do one of the following: To select a file, click Current Folder, and then click the file that you want to link to.
Add a hyperlink from the context menu Select a cell where you want to insert a hyperlink. Right-click on the cell and choose the Hyperlink option from the context menu. ... Choose Place in This Document in the Link to section if your task is to link the cell to a specific location in the same workbook.
Method 2 Inserting a Link to a Webpage Copy the address to the site you want to link to. ... Select the cell in your Excel spreadsheet that you want to insert the link into. ... Click the " Insert" tab and click the " Hyperlink" button. ... Select " Existing File or Web Page" on the left side of the window.
3. Create the Drop Down List Select the cells in which you want the drop down list. On the Ribbon's Data tab, click Data Validation. From the Allow drop-down list, choose List. Click in the Source box, and type an equal sign, and the list name, for example: ... Click OK to close the Data Validation dialog box.
Create the Drop Down List Select the cells where you want the drop down lists. Choose Data> Validation. In the Allow box, choose List. In the Source box, type the list name, preceded by an equal sign, e.g.: = MyList. Click OK.
To add this drop-down list to a sheet, do the following: Create the list in cells A1: A4. ... Select cell E3. ... Choose Validation from the Data menu. Choose List from the Allow option's drop-down list. ... Click the Source control and drag to highlight the cells A1: A4. ... Make sure the In- Cell Dropdown option is checked. ... Click OK.
Create a Drop- Down List for a Cell or Range Choose Data Validation from the Data Tools group on the Data tab. Select the Settings tab. In the Allow box, select List. Click the Source box. Type in a list of values separated by a comma. Make sure the In-cell dropdown box is checked. Click OK.