Pete

Not sure I understand everything, but to remove a named range (is this how
you made your list?) goto insertnamedefineselect the name and click remove.

Mike Rogers

"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.