Create a column or a row of the items in the active spreadsheet for the drop-down list. This article shows a simple way of how to create a drop-down list. HTH, Bernie MS Excel MVP "David" wrote in message news:1E9F804B-60BF-4206-93AA-8451C7CEBB1B@microsoft.com... >I would like to know how to create a number series of steps in a single cell > on an Excel spreadsheet. To accomplish this task, the formula must include at least one cell reference.In an Excel formula, a cell reference is used to reference the value of another cell. One of the uses of MS Excel is to easily and quickly create fill-in forms. How to start a new line in Excel cell. Excel returns the focus to the original worksheet, and the cell containing the list has a new drop-down button. You can follow the question or vote as helpful, but you cannot reply to this thread. Once you experiment you will get the idea. I have lists within cells and I want to indent some of the text, not all of text. Cell link: The combo box can be linked to a cell where the item number is displayed when you select an item from the list.Type the cell number where you want the item number displayed. The fastest way to create a new line within a cell is by using a keyboard shortcut: Windows shortcut for line break: Alt + Enter; Mac shortcut for line feed: Control + Option + Return or Control + Command + Return; In Excel 365 for Mac, you can also use Option + Return. The article than proceeds to show how cell values can be changed when the list item selected is changed. Gord Dibben MS Excel MVP On Tue, 2 May 2006 03:37:01 -0700, Sunil Verma wrote: >How can we insert bullet & numbering with in a cell ? Input range: Type the range of cells containing the list of items.. Give the list a range name. Here are the steps to create a drop-down list in Excel: Select the cell or range of cells where you want the drop-down list to appear (C2 in this example). To create your own drop-down list for the cell, do the following: 1. Format the cell for linewrap, and it should (I think) show what you want. In the Data Validation dialogue box, within the settings tab, select ‘List’ as Validation Criteria. Click the button to view the list and select one of the values. Creating the Drop Down List in Excel. SEE: How to create a drop-down list in Google Sheets (TechRepublic) You can add the drop down list to multiple Excel cells. 3. How do you indent text within a cell in excel? Now you're ready to create the validation list, as follows: Select E2:E15--these are the existing cells you want to fill using the validation control. A common feature in fill-in forms is the automation of field entries based on a list item selection. Thank you! When you are working with a spreadsheet in Microsoft Excel, it may be useful to create a formula that references the value of other cells. Select the cell that needs a drop-down list for data validation (cell B2, in this example). To get more than one line in a cell type your number then hit ALT + ENTER. Go to Data –> Data Tools –> Data Validation. This thread is locked. You can make a bulleted/numbered list in a cell. On the Data tab, in the Data Tools group, click Data Validation: U can do that, Expand the cell! Highlight the range (A1:A10) or just position your cursor on any cell in the list, and press Ctrl+ T to convert this group of items to a table. 2. References Click Control and set the following options:. Place the table in a separate sheet that you want to insert! For instance, a cell's formula might calculate the sum of two other cells and display the result.