|
|
#1
12-17-2016, 08:22 PM
|
|||
|
|||
Excel 2013 pasting value not formula
In Excel 2013, ctrl+c, ctrl+v, when formula is copied, pastes values, not formulas.
In fact, when I copy any cell, i dint have the option to paste as a value or just the format or reference, all I can do is to paste as Text 
|
|
#2
12-20-2016, 07:05 PM
|
|||
|
|||
|
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.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 if formula in workbook ExcelExpert_3-1a of MOS 2013 studyguide Excel expert
|
Jos | Excel | 1 | 09-07-2015 09:45 AM |
|
formula in excel 2007 works not in 2013
|
piper7971 | Excel | 10 | 07-06-2015 02:09 PM |
| HOTFIX JUNE 2013, ISSUE with copying and pasting tasks with pre-existing links | cathalm8 | Project | 1 | 04-14-2015 01:34 PM |
| Pasting images: weird behavior in Word 2013 (“In Line With Text”) | Jamal NUMAN | Word | 2 | 09-14-2012 12:50 PM |
| Pasting a formula from Excel to Powerpoint | True_Blue_32 | PowerPoint | 0 | 06-07-2012 12:13 AM |
Windows 7 64bit 
Office 2010 32bit
Linear Mode
