View Single Post
 
Old 12-17-2015, 12:33 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Long explanation but easy to do
Select the cell you want to keep the value of
Place cursor against the upper border of the selected cell. It turns ot another symbol.( "cross with arrows"?)
While holding down the right button of your mouse move the cell around and drop it where you want ( same place is ok)
A menu appears
Select "copy here as values only". Done

The same can be done with ranges
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote