Add, edit, or delete list items

Lists can include a variety of list items, such as contacts, calendars, announcements, and issues-tracking. Your list can also include the following items: Text, Number, Choice, Currency, Date and Time, Lookup, Yes/No, and Calculated columns.

You can create lists in Microsoft SharePoint, the Lists app in Microsoft 365, or Teams. Learn to get started with Lists in Microsoft Teams.

You can also attach files to a list item to provide additional details, such as a spreadsheet containing supporting numbers or a document containing background information.

Note: To add, edit, or delete list items, you must have edit permissions. If you don't see any options to add or edit list items, contact your SharePoint admin. To delete a complete list, see Delete a list in SharePoint.

Add an item to a list

There are two ways to add an item to a list - single items in list view, or multiple items in grid view (formerly known as "Quick Edit"). The following steps use the modern Microsoft 365 experience.

Navigate to the list where you want to add an item.
Above the list, select the + New or + Add new item link to open the New item window.

Note: A site can be significantly customized in appearance and navigation. If you cannot locate an option, such as a command, button, or link, contact your administrator.
Enter the information for the list item.
- Note: You must enter data into a column (field) that has an asterisk * next to it.
- To attach a file or files to the list item, in the New item window, select Add attachments, and then select the file. Hold down the CTRL key when selecting files to attach more than one file.
  
  Select Open, and then select OK. If you don't see the Add attachments command, that means your list doesn't support attachments.
Select Save.

Navigate to the site containing the list where you want to add an item.
At the top of the list, select Edit in grid view.
Enter the information for the list item.

For columns that require information, an error dialog appears if you don't enter anything.

Important: You can't attach a file to multiple list items when using Edit in grid view.
Do one of the following:
- When you're finished entering the information, select Exit grid view.
- To delete an item, select the circle to the left of the item, and then select Delete in the command bar.

You can rearrange the order of one or more items by dragging them to the place you want. You need edit permissions or full control of a list to move items.

Important: Before reordering, you need to clear all sorting, filtering, or grouping changes from the view.

Navigate to the site containing the list where you want to add an item.
If you are in Grid view, at the top of the list select Exit grid view.
Hover over the item or highlight the items you'd like to move. A gripper icon will appear on the left of the selected items' circle checkbox.
Drag the items to the position you want.

Just as with adding items, there are two ways to edit an item in a list. You can edit an item in list view, which is the default method, or you can edit multiple items in the Edit in grid view.

Edit Item

Navigate to the site containing the list where you want to edit an item.
Select the name or title of the list.
Select the circle next to the item you want to edit, right click, and then select in the dropdown.
- If you want to edit multiple items, select the circle for both items.
In the list item, edit the information you want to change.
Click Save.

Navigate to the site containing the list that you want to add an item.
At the top of the list, select Edit in grid view.

You can also select the List tab, and then select Edit in grid view.
Double-click a cell to make a change.
To quickly edit multiple values in a column at once, select the cell that has the right value, then drag the corner of the cell to extend the selection to adjoining rows.
To undo an action, use Undo or Redo.
You can add a new item by copying an existing one, then revising the copy:
1. Select the item, then press Ctrl+C.
2. At the bottom of the list, select Add New Item.
3. Press Ctrl+V to paste.
4. Update the new item as needed.
Important:
- It's possible to copy and paste several items at once, for example from a Word table or Excel range. Use this approach if you want to import an Excel spreadsheet. Make sure all values match their column type. To start the paste operation, position the cursor in the first blank column.
- You can't attach a file to multiple list items when editing in grid view.
When you are finished editing the information, select Exit grid view.

Navigate to the site containing the list where you want to edit an item.
Select the name or title of the list.
Select the circle next to the item you want to edit, and in the dropdown, select Edit. If you're in Quick edit view, select the circle next to an item.
Select Add attachments, and then select the file. Hold down the CTRL key when selecting files to attach more than one file.

Select Open, and then select OK. If the Add attachments command is unavailable, your list doesn't support attachments.
To delete an attachment from a list item, select Edit Item. In the Attachments section on the form next to the attachment you want to remove, select Delete.
Select Save.

Caution: Deleting items may be permanent and you might not be able to recover them. Consider moving or archiving the items instead. Depending on how your site was configured, you may be able to recover the items and its contents from the Recycle Bin. For more info, see Restore deleted items in Site recycle bin.

Navigate to the site containing the list where you want to delete the items.
Select the title of the list in which you want to work.

Note: A site can be significantly modified in appearance and navigation. If you cannot locate an option, such as a command, button, or link, contact your administrator or manager.
You can select one or more items to delete at a time. Select the checkmark to the left of the items you want to delete, and from the Manage section of the Items tab, select Delete Item.