Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-17-2016, 08:22 PM
bumbrlik bumbrlik is offline Excel 2013 pasting value not formula Windows 7 64bit Excel 2013 pasting value not formula Office 2010 32bit
Novice
Excel 2013 pasting value not formula
 
Join Date: Dec 2013
Posts: 1
bumbrlik is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 12-20-2016, 07:05 PM
Tuph Tuph is offline Excel 2013 pasting value not formula Windows XP Excel 2013 pasting value not formula 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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2013 pasting value not formula if formula in workbook ExcelExpert_3-1a of MOS 2013 studyguide Excel expert Jos Excel 1 09-07-2015 09:45 AM
Excel 2013 pasting value not formula 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft