How to copy paste only values from one excel sheet to another
1 Answer(s)
Binny
- To copy only values, right-click on that cell and select Copy option.
- In the new Excel sheet, under Home tab, go to Paste option and select 'Paste values' from the drop-down menu.
OR
- You can also right-click on the cell, go to Paste Special and select Values option.
May 31 2014 11:14 PM
- In the new Excel sheet, under Home tab, go to Paste option and select 'Paste values' from the drop-down menu.
OR
- You can also right-click on the cell, go to Paste Special and select Values option.