You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. 1. In a new worksheet, type the entries you want to appear in your drop-down list. Ideally, you’ll have your list items in an Excel table. If you don’t, then you can quickly convert your list to a table by selecting any cell in the range, and pressing Ctrl+T. 2. Select the cell in the worksheet where you want the drop-down list. 3. Go to the Data tab on the Ribbon, then Data Validation. 4. On the Settings tab, in the Allow box, click List. Click in the Source box, then select your list range. We put ours on a sheet called Cities, in range. Note that we left out the header row because we don't want that to be a selection option: 5. If it’s OK for people to leave the cell empty, check the Ignore blank box. Check the In-cell dropdown box. Click the Input Message tab. If you want a message to pop up when the cell is clicked, check the Show input message when the cell is selected box, and type a title and message in the boxes (up to 225 characters). If you don’t want a message to show up, clear the checkbox. 6. Click the Error Alert tab. If you want a message to pop up when someone enters something that's not in your list, check the Show error alert after invalid data is entered the box, pick an option from the Style box, and type a title and message. If you don’t want a message to show up, clear the checkbox. 7. Not sure which option to pick in the Style box? To show a message that doesn’t stop people from entering data that isn’t in the drop-down list, click Information or Warning. Information will show a message with this icon Message shows the Information icon but doesn't stop people from choosing from the drop-down list and Warning will show a message with this icon Message shows Warning icon but doesn't stop people from choosing from the drop-down list. To stop people from entering data that isn’t in the drop-down list, click Stop.
Create a Drop-down List in Excel - Easy Excel Tutorial
You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. 1. In a new worksheet, type the entries you want to appear in your drop-down list. Ideally, you’ll have your list items in an Excel table. If you don’t, then you can quickly convert your list to a table by selecting any cell in the range, and pressing Ctrl+T. 2. Select the cell in the worksheet where you want the drop-down list. 3. Go to the Data tab on the Ribbon, then Data Validation. 4. On the Settings tab, in the Allow box, click List. Click in the Source box, then select your list range. We put ours on a sheet called Cities, in range. Note that we left out the header row because we don't want that to be a selection option: 5. If it’s OK for people to leave the cell empty, check the Ignore blank box. Check the In-cell dropdown box. Click the Input Message tab. If you want a message to pop up when the cell is clicked, check the Show input message when the cell is selected box, and type a title and message in the boxes (up to 225 characters). If you don’t want a message to show up, clear the checkbox. 6. Click the Error Alert tab. If you want a message to pop up when someone enters something that's not in your list, check the Show error alert after invalid data is entered the box, pick an option from the Style box, and type a title and message. If you don’t want a message to show up, clear the checkbox. 7. Not sure which option to pick in the Style box? To show a message that doesn’t stop people from entering data that isn’t in the drop-down list, click Information or Warning. Information will show a message with this icon Message shows the Information icon but doesn't stop people from choosing from the drop-down list and Warning will show a message with this icon Message shows Warning icon but doesn't stop people from choosing from the drop-down list. To stop people from entering data that isn’t in the drop-down list, click Stop.
You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. 1. In a new worksheet, type the entries you want to appear in your drop-down list. Ideally, you’ll have your list items in an Excel table. If you don’t, then you can quickly convert your list to a table by selecting any cell in the range, and pressing Ctrl+T. 2. Select the cell in the worksheet where you want the drop-down list. 3. Go to the Data tab on the Ribbon, then Data Validation. 4. On the Settings tab, in the Allow box, click List. Click in the Source box, then select your list range. We put ours on a sheet called Cities, in range. Note that we left out the header row because we don't want that to be a selection option: 5. If it’s OK for people to leave the cell empty, check the Ignore blank box. Check the In-cell dropdown box. Click the Input Message tab. If you want a message to pop up when the cell is clicked, check the Show input message when the cell is selected box, and type a title and message in the boxes (up to 225 characters). If you don’t want a message to show up, clear the checkbox. 6. Click the Error Alert tab. If you want a message to pop up when someone enters something that's not in your list, check the Show error alert after invalid data is entered the box, pick an option from the Style box, and type a title and message. If you don’t want a message to show up, clear the checkbox. 7. Not sure which option to pick in the Style box? To show a message that doesn’t stop people from entering data that isn’t in the drop-down list, click Information or Warning. Information will show a message with this icon Message shows the Information icon but doesn't stop people from choosing from the drop-down list and Warning will show a message with this icon Message shows Warning icon but doesn't stop people from choosing from the drop-down list. To stop people from entering data that isn’t in the drop-down list, click Stop.
No comments:
Post a Comment