View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default extend the range of cells for a drop down list

Hi,

Simply convert the range to a Table (Ctrl+L). When you convert a range to a
Table, it auto expands

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Marge" wrote in message
...
I have a range of cells (named staff) on a worksheet in the workbook where
the drop down list will be used. Additional cells were added to the range
of
cells, but I can't get Excel to include them on the named list. Can I not
expand the range of cells or do I need to name the expanded list with a
new
range name?