Convert a 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.