Excel How To Copy Paste Values From Cells Which Have Functions And Formulas
Excel how to copy paste values from cells which have functions and formulas
Sometimes , you will have a situation where target cells which need to be copied basically have numbers or values derived of functions and formulas .Say the target cell is E1 sum of cells A1 , B1, C1 which contain 1,2,3 , so target cell contains 6 , Now if i want to copy such hundred target cell values or numbers only , i cannot simply observe a copy paste , I need to use paste special (values) to copy the value in the cell .A simple paste would then copy the function inside the cell by default and paste it over the destination cell.
Please watch this video for a total practical understanding.
How to do Copy Paste Values Without Formula in MS Excel
#excel #microsoft #formulas
Watch video Excel How To Copy Paste Values From Cells Which Have Functions And Formulas online, duration hours minute second in high quality that is uploaded to the channel INFOTAINMENT 13 May 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 92 times and liked it 1 visitors.
