#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding Arabic words in lists in Excel 2007 علاء Excel Discussion (Misc queries) 0 October 9th 08 06:20 AM
Excel 2007 - Tables now (lists in 2003) ChrisK Excel Discussion (Misc queries) 1 July 25th 07 12:26 AM
Where are Data Forms for lists (tables) in Excel 2007? Reed P. Wyatt Excel Discussion (Misc queries) 2 July 2nd 07 11:00 AM
Datavalidation using lists - problem in 2007 B2TR to RTM workbook AC [MVP MCMS] Excel Discussion (Misc queries) 2 December 26th 06 04:52 PM
Excel 2007: LISTS ! Ed Excel Discussion (Misc queries) 2 September 4th 06 07:20 PM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"