First, enter a '1' and a '2' in separate rows in the column you wish to have numbered, then highlight these two cells. Highlighting can be done by clicking and dragging over the two. Once selected, click on the tiny box in the lower-right corner of the selection border, called the Fill handle, and drag downward through the column.
Hi, I've been using this forum for years to get info, thank you for everyone's hard work and input. This Excel 2008 issue is something that just came up for me as well, and by accident, I was able to sort a list by carrying out the following steps: Select record range (For example, all of Column B) Click on Menu Buttons: Data Filter Advanced Filter Check 'Unique Records Only' box Hit OK All duplicate record rows were removed. I'm not sure if this will work every time for everyone, but I felt urged to contribute this possible solution.
Any of this help?. Enter the items for your drop-down list into a list on the worksheet, one item per cell. In this example, I'll assume that the month names start in cell E1 and extend down to E12, but they can be in any out-of-the-way location on the worksheet. In Excel terminology, a rectangular group of cells (such as E1 to E12) is called a range. Select the cell that will contain the drop-down list. If you'd like more than one cell to display the same list, just select them all now rather than setting them up one at a time.
(Click and drag to select a range; hold down Ctrl while you click to select non-adjacent cells.). Choose Data, Validation to display the Data Validation dialog box. Click the Settings tab. In the Allow field, select List. In the Source field, specify the range that contains the list items. In this example, the items are in cells E1 to E12, so type =E1:E12 into the field.
![2008 2008](https://support.content.office.net/en-us/media/423e4838-2de7-40b1-9a4c-e2b53330a552.png)
NOTE You cannot create a list in a shared workbook. You must remove the workbook from shared use first if you want to create a list. Every column in the list has AutoFilter enabled by default in the header row. AutoFilter allows you to filter or sort your data quickly. The dark blue border around the list clearly distinguishes the range of cells that makes up your list. The row that contains an asterisk is called the insert row.
![Excel Excel](/uploads/1/2/5/4/125400663/484223122.png)
Typing information in this row will automatically add data to the list and expand the border of the list. A total row can be added to your list. When you click a cell within the total row, a drop-down list of aggregate functions becomes available. You can modify the size of your list by dragging the resize handle found on the bottom corner of the list border. Any of this help?.
Enter the items for your drop-down list into a list on the worksheet, one item per cell. In this example, I'll assume that the month names start in cell E1 and extend down to E12, but they can be in any out-of-the-way location on the worksheet. In Excel terminology, a rectangular group of cells (such as E1 to E12) is called a range. Select the cell that will contain the drop-down list. If you'd like more than one cell to display the same list, just select them all now rather than setting them up one at a time.
(Click and drag to select a range; hold down Ctrl while you click to select non-adjacent cells.). Choose Data, Validation to display the Data Validation dialog box.
Click the Settings tab. In the Allow field, select List. In the Source field, specify the range that contains the list items. In this example, the items are in cells E1 to E12, so type =E1:E12 into the field. NOTE You cannot create a list in a shared workbook.
You must remove the workbook from shared use first if you want to create a list. Every column in the list has AutoFilter enabled by default in the header row. AutoFilter allows you to filter or sort your data quickly. The dark blue border around the list clearly distinguishes the range of cells that makes up your list. The row that contains an asterisk is called the insert row. Typing information in this row will automatically add data to the list and expand the border of the list.
A total row can be added to your list. When you click a cell within the total row, a drop-down list of aggregate functions becomes available. You can modify the size of your list by dragging the resize handle found on the bottom corner of the list border. Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only.
Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.