#1
|
|||
|
|||
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
|
|||
|
|||
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 |