How to copy and only paste cell values in Excel
How to copy a cell and paste only its values in Excel, leaving the formula behind. First, highlight the cells you want to copy. Both the cell's values and the formula will be available on your clipboard before you decide to paste. Once you've located your paste area, right click on the cell you'd like to use and choose "paste special" and then "values." This will paste only the value of the original cell, and not the formula.
Best uses include: Pasting data that was created with formulas and using its end values to begin a new process.
Website: www.trendlineanalysis.com
More Excel videos: • How To: Excel Tips and Tricks
Subscribe: / @trendlineanalysis
#Excel #CopyPaste #PasteValues #pastespecial