#1   Report Post  
Old September 26th 13, 07:39 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2013
Posts: 2
Default Cell copy

Hi Group. Newbie to Excel. Is it possible to copy the contents of a cell to another cell without copying the formula in that cell?
Thanks, Ken

  #2   Report Post  
Old September 26th 13, 07:54 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,607
Default Cell copy

Hi,

Am Thu, 26 Sep 2013 19:39:13 +0100 schrieb Mikey Williams:

Hi Group. Newbie to Excel. Is it possible to copy the contents of a cell
to another cell without copying the formula in that cell?


copy the cell = Insert = Paste Special = Paste values


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #3   Report Post  
Old September 26th 13, 11:26 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2013
Posts: 2
Default

Thank you. Just what I needed.

Quote:
Originally Posted by Claus Busch View Post
Hi,

Am Thu, 26 Sep 2013 19:39:13 +0100 schrieb Mikey Williams:

Hi Group. Newbie to Excel. Is it possible to copy the contents of a cell
to another cell without copying the formula in that cell?


copy the cell = Insert = Paste Special = Paste values


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options Yuvraj Excel Discussion (Misc queries) 0 June 29th 09 11:20 AM
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Yuvraj Excel Discussion (Misc queries) 0 June 26th 09 06:01 PM
How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell [email protected] Excel Worksheet Functions 2 November 7th 07 09:39 AM
VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column gumby Excel Programming 4 July 14th 07 01:55 AM
I copy a formula and the results copy from the original cell brooklynsd Excel Discussion (Misc queries) 1 June 23rd 07 01:35 AM


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017