Assuming Excel 2003 and you created the list using DataCreate List.

Right-click on the toolbar and select "List" toolbar.

With a cell in your list active, from "List" drop-down on Toolbar select
"Convert To Range".


Gord Dibben MS Excel MVP


On Wed, 29 Nov 2006 06:27:00 -0800, Pete wrote:

I unintentionaly created a list in a spreadsheet I have which has over 4,000
rows of data in 10 columns. The list I created was the first 5 columns of
the entire spreadsheet, and due to creating the list, it added a row in those
5 coilmns, and now my spreadsheet has the info for a row for last 5 columns
being shown one row up from the other data for that row.