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.