Paste options of copy

Users can choose from several paste options while copying the data from the cell range. Users can also combine the two different paste options. In this example, please check the preview of the paste results in sheet2.