Hi Dilip,
Thanks for your explanation.Great!
On Tue, May 12, 2009 at 4:59 PM, Dilip Pandey wrote:
> Hi Yu,
>
> For copy purpose, you can simply copy the formula and then you can replace
> (Ctrl +H) the "=" sign with "".
> Now moving over to your second question:-
> Ctrl + D -> it will copy
to copy just the formula.. copy it from the formula bar.
Ctrl + D - to copy the cells from top to bottom (the last cell that you have
your cursor on)
Ctrl + C and CTRL +V - copy and paste "all" - which means formula,format
etc..
*Sri*
On Tue, May 12, 2009 at 12:02 PM, Yu wrote:
>
> Hi All,
>
>
Hi Yu,
For copy purpose, you can simply copy the formula and then you can replace
(Ctrl +H) the "=" sign with "".
Now moving over to your second question:-
Ctrl + D -> it will copy the data with formula and text / formatting from
above cell.
Ctrl + C and Ctrl + V, will first move the data to clipb
usually highlight it in the
address bar and ctrl-c
Or, remove/replace the "=", copy it, then replace the "=".
Paul
From: zheng yu
To: excel-macros@googlegroups.com
Sent: Tuesday, May 12, 2009 8:31:09 AM
Subject: $$Excel-Macros$$ Re: copy t
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 fo
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
To: MS EXCEL AND VBA MACROS
Sent: Tuesday, May 1
