The Verify Paste confirmation box is a useful tool for double-checking the paste operation before deciding to accept or reject it. It remains fixed in your display while you scroll through your table or list examining the results of the paste operation.
The confirmation box will indicate whether the proposed paste operation is going to be successful or unsuccessful.
Below is a list of the various components that can be found in the Verify Paste confirmation box:
- Total paste area: the size of the paste area as measured in columns and rows.
- Red X: shows the number of cells that cannot be pasted.
- White check mark: the number of cells that remain unchanged.
- Green check mark: the number of cells in which new values were pasted.
- Yellow check mark: the number of cells that were successfully pasted with automatic adjustment.
- Enable paste without red cells: check this box to enable the Accept button on potentially unsuccessful paste operations by discarding any red cells from the paste operation.
There are three buttons:
- Report: generates a full report that can be filtered to view the paste results. For further details about the report, refer to Paste Preview Report.
- Accept: Proceeds with the paste operation. The information in green and yellow cells replaces the original cell values. If you checked Enable paste without red cells, the red cells keep their original (pre-paste) contents.
- Reject: The Reject button is useful if there is some mistake in the location or content of the paste. All the cells will revert to their old values. You can correct the location and/or content as necessary and then perform the copy and paste operation again.