View Single Post
  #7  
Old June 2nd, 2010, 01:12 AM posted to microsoft.public.excel.worksheet.functions
Mike Middleton[_2_]
external usenet poster
 
Posts: 90
Default Drop Down Lists 2007

Gord -

In Excel 2007 and 2010, select the top left cell of an empty area, and
choose Formulas Use in Formula Paste Names Paste List.

- Mike
http://www.MikeMiddleton.com


"Gord Dibben" gorddibbATshawDOTca wrote in message
...
That's fine for creating names

But I can't find a "paste List" anywhere.

Like in 2003 InsertNamePaste


Gord

On Tue, 1 Jun 2010 22:03:02 +0100, "Roger Govier"
wrote:

Hi Max

Formulas tabDefine Name or Formulas tabName ManagerNew
or as a shortcut
Alt+M+M+D