Ctrl-D: Have you TRIED it? Let's say you're making entries in 10 columns. some are the same as the previous row, but some are not. Your start on the left.. type something, hit tab to the next column, type something, then the next column has the same value as the row above, you hit the "up" arrow, ctrl-c, "down" arrow, ctrl-v, then move to the next cell. So that's:
type, tab, type, tab, up-arrow, ctrl-c, down-arrow, ctrl-v, tab Or: type, tab, type, tab, ctrl-d, tab Uh.. yeah, I think it's different... If I want to copy the TEXT of the formula, I usually highlight it in the address bar and ctrl-c Or, remove/replace the "=", copy it, then replace the "=". Paul ________________________________ From: zheng yu <vincent2...@gmail.com> To: excel-macros@googlegroups.com Sent: Tuesday, May 12, 2009 8:31:09 AM Subject: $$Excel-Macros$$ Re: copy text from a formula & Ctrl+D Hi Paul, I don't wanna copy the formula, just wanna copy the text after "=". Sometimes there is a long string after "=", and I wanna copy that string instead of typing it at other place:) If there is not shortcut, is there any way at all..hehe Well, regarding Ctrl+D : If there is formula in the above cell, actually when you use Ctrl+D, the below cell copies the formula as well. That is totally same as Ctrl+C then Ctrl+V...I don't know what makes Ctrl+D different? On Tue, May 12, 2009 at 2:20 PM, Paul Schreiner <schreiner_p...@att.net> wrote: Are you saying that you want to copy the formula WITHOUT the "=" ?? I'm not sure if there is a shortcut. But in answer to your second question: Ctrl-D simply copies the contents of the above cell. Paul ________________________________ From: Yu <vincent2...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Tuesday, May 12, 2009 2:32:06 AM Subject: $$Excel-Macros$$ copy text from a formula & Ctrl+D Hi All, In cell A1 I have a formula like "=blablabla(arg1,arg2)". How can just copy "blablabla(arg1,arg2)" ? is there a short cut ? And what is the difference between Ctrl+D and "Ctrl+C then Ctrl +V"..both seem to copy and paste...and I was told there is slight differenct... Thanks! Yu --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
