Convert an Excel list to a range

You can remove list functionality for a list in the worksheet by converting the list to a standard Excel range.

  • On the List submenu of the List toolbar, click Convert to Range.

 Note   If the list is linked to a SharePoint list, then the link will be removed and all pending changes will not be reflected in the SharePoint list.

Applies to:
Excel 2003