Approve or reject pending items in Datasheet view

If you have the Manage Lists right for a list, and the list is set up to require content approval, you can review the data that different users add to the list before it is displayed to the public. After reviewing the data, you can approve or reject items. Only approved items will be displayed to the site users.

For more information on lists that require approval, see Microsoft Windows SharePoint Services Help. To display Windows SharePoint Services Help, click Help on the page toolbar.

1. To review data entered by other users, open the list in Approve/reject Items view. This view displays the Approval Status and Comments columns in addition to all the columns in the list.
2. If the list displays in Standard view, click Edit in Datasheet to switch to Datasheet view. In Datasheet view, you can bulk edit the Approval Status and Comments columns to save time.
3. Filter the view to display only pending items. Click the drop-down arrow in the column header of the Approval Status column and click Pending.
4. To approve or reject a single row, review the data in the row, and set the Approval Status column to either Approved or Rejected. Enter a comment in the Comments column.

   To update adjacent rows with the same status or comment, enter the value in the first row, and drag the fill handle to include the rows you want. You can also copy and paste values in the columns.

Note  You can also change the status of an approved or rejected item back to pending.