Pls help me to any quickest alternative from this boring shortcut

Hi!
All Excel Genious,

Pls help me to any quickest alternative from this boring shortcut
Alt,E,S,V then Enter.

Thanks all in advance.

Nazmul Haque,
E-mail: [email protected]
Bangladesh.


--
rony4icab
Posted from - http://www.officehelp.in

Please tell what you're trying to do: the shortcuts vary per localized version of Excel.

--
Kind regards,

Niek Otten

"rony4icab" <[email protected]> wrote in message news:[email protected]...
|
| Hi!
| All Excel Genious,
|
| Pls help me to any quickest alternative from this boring shortcut
| Alt,E,S,V then Enter.
|
| Thanks all in advance.
|
| Nazmul Haque,
| E-mail: [email protected]
| Bangladesh.
|
|
| --
| rony4icab
| Posted from - http://www.officehelp.in
|

Does
<F2> <F9>
Help?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rony4icab" <[email protected]> wrote in message
news:[email protected]...
>
> Hi!
> All Excel Genious,
>
> Pls help me to any quickest alternative from this boring shortcut
> Alt,E,S,V then Enter.
>
> Thanks all in advance.
>
> Nazmul Haque,
> E-mail: [email protected]
> Bangladesh.
>
>
> --
> rony4icab
> Posted from - http://www.officehelp.in
>

Dear Ragdyer,
<F2> <F9>,Does'nt help.
Actually I copied a cell from a worksheet & copied it to another
Worksheet cell using Paste Values shortcut(Alt,E,S,V and Enter).
Now I want a macro or any formula in which I can Paste Values .
Thanks.
Nazmul.


--
rony4icab
Posted from - http://www.officehelp.in

Dear Ragdyer,
<F2> <F9>,Does'nt help.
Actually I copied a cell from a worksheet & copied it to another
Worksheet cell using Paste Values shortcut(Alt,E,S,V and Enter).
Now I want a macro or any formula in which I can Paste Values .
Thanks.
Nazmul.


--
rony4icab
Posted from - http://www.officehelp.in

Hi
The method I use is to put a 'Paste Values' button on the toolbar using
View>Toolbars>Customise.

Andy.

"rony4icab" <[email protected]> wrote in message
news:[email protected]...
>
> Dear Ragdyer,
> <F2> <F9>,Does'nt help.
> Actually I copied a cell from a worksheet & copied it to another
> Worksheet cell using Paste Values shortcut(Alt,E,S,V and Enter).
> Now I want a macro or any formula in which I can Paste Values .
> Thanks.
> Nazmul.
>
>
> --
> rony4icab
> Posted from - http://www.officehelp.in
>

Try This:

First,
Paste this in your personal marcos:

Sub ESV()
' Keys that are not already defined:
' Ctrl + Q
' Ctrl + T
' Ctrl + L

selection.Copy
selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
application.CutCopyMode = False
End Sub

Second,
Open your Macros (Alt + F8), highlight "Personal.XLS!ESV" on the left
and then click "Options" on the right.
Choose a letter (Q or T or L) to use with the "Crtl" button to excute
the marco. Click okay.

Finally,
In Excel select the cell with formula, press "Ctrl + (The letter you
picked)" and the formula will become a value.

Regards ...