Excel 2007 lists
 

I could establish my own list in Excel 2003 and save it like the list for the
months of the year. Then I could type the first entry and fill in the restby
dragging the fill block. How is that available in Excel 2007?
--
len8484

Excel 2007 lists
 

Hi len8484

Office Button Excel Options
On the Popular tab there is a buton "Edit Custom Lists"

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"len8484" wrote in message ...
I could establish my own list in Excel 2003 and save it like the list for the
months of the year. Then I could type the first entry and fill in the restby
dragging the fill block. How is that available in Excel 2007?
--
len8484

Excel 2007 lists
 

On Jan 18, 9:11*pm, len8484 wrote:
I could establish my own list in Excel 2003 and save it like the list for the
months of the year. Then I could type the first entry and fill in the restby
dragging the fill block. How is that available in Excel 2007?
--
len8484

Go to the Office Button
Choose "Excel options"
In "Popular" Tab click on "Edit Custom lists.."
Make sure that the "New List" is selected in the dialog box and enter
your new list (enter after each new item)
Click on "Add" once your list has been added
Press OK and OK and you are ready to roll (or drag)

Steve