Thread: [Solved] Excel 2013 pasting value not formula
View Single Post
 
Old 12-20-2016, 07:05 PM
Tuph Tuph is offline Windows XP Office 2016
Advanced Beginner
  
Join Date: Dec 2014
Location: Melbourne, Australia
Posts: 31
Tuph is on a distinguished road
Default
In Excel 2016 under Options / Advanced / Cut, copy, and paste there is an option to "Show Paste Options button when content is pasted". After turning this on, copy and paste a formula as usual then click on the options button that appears. Select the appropriate option button to change the way the paste behaves.
Reply With Quote