How can we paste special value through shortcut keys.

hi,
See this site....

http://office.microsoft.com/en-us/ex...037811033.aspx

personally i am not sure about specific shortcut keys for paste special but
as this site suggests, you can record a macro and create a shortcut.

regards
FSt1

"ZEESHAN ANIS" wrote:

How can we paste special value through shortcut keys.

Hi Zeeshsan,

How can we paste special value through shortcut keys.

See the responses from Dave Peterson in your original thread.


---
Regards,
Norman

Hi Zeeshan -

One way would be to record a PasteSpecial macro and assign it to a shortcut
key.

1. Select any range of several cells and choose |Edit|Copy|.

2. Then choose |Tools|Macro|Record New Macro...|.

3. In the dialog that opens, enter a shortcut key in the 'Shortcut Key' box.
For example, enter "b".

4. Select any single destination cell and choose |Edit|Paste Special|Values.

5. Press the stop recording macro button. Open the VB Editor (Alt-F11) and
find the macro you just recorded (it should be named Macro1()).

6. The macro will have two functionl lines. The first will be something
like:
Range("E1").Select. Delete that line.

----------------
To use the macro on a worksheet, select cells, choose copy, select the
destination and press Ctrl-b. Copy the macro to any workbook you need it in
or copy it to your Personal.xls workbook so it is always available. Search
Google for Personal.xls for details about how to use the macro in your
personal macro workbook.

I'll be offline immediately after this post, but will check back in about 10
hrs. Good luck.
--
Jay


"ZEESHAN ANIS" wrote:

How can we paste special value through shortcut keys.

Thanks FSt1 for your help its really very useful website for excel users
specially.
Thanks again.

"FSt1" wrote:

hi,
See this site....

http://office.microsoft.com/en-us/ex...037811033.aspx

personally i am not sure about specific shortcut keys for paste special but
as this site suggests, you can record a macro and create a shortcut.

regards
FSt1

"ZEESHAN ANIS" wrote:

How can we paste special value through shortcut keys.

Hi Jay,
Thankyou very much its really very usefull tool I used it and get the
required result,
I need ur help more
How can we "change case" and "font size" in Ms Word & Ms Excel through
shortcut keys.


waiting for ur usual cooperation.

Best Regards
ZEESHAN ANIS

"Jay" wrote:

Hi Zeeshan -

One way would be to record a PasteSpecial macro and assign it to a shortcut
key.

1. Select any range of several cells and choose |Edit|Copy|.

2. Then choose |Tools|Macro|Record New Macro...|.

3. In the dialog that opens, enter a shortcut key in the 'Shortcut Key' box.
For example, enter "b".

4. Select any single destination cell and choose |Edit|Paste Special|Values.

5. Press the stop recording macro button. Open the VB Editor (Alt-F11) and
find the macro you just recorded (it should be named Macro1()).

6. The macro will have two functionl lines. The first will be something
like:
Range("E1").Select. Delete that line.

----------------
To use the macro on a worksheet, select cells, choose copy, select the
destination and press Ctrl-b. Copy the macro to any workbook you need it in
or copy it to your Personal.xls workbook so it is always available. Search
Google for Personal.xls for details about how to use the macro in your
personal macro workbook.

I'll be offline immediately after this post, but will check back in about 10
hrs. Good luck.
--
Jay


"ZEESHAN ANIS" wrote:

How can we paste special value through shortcut keys.

Hi Zeeshan €“
--------------------------------------------------------------
MS-Word
Search the Word Help System for €œPrint a list of shortcut keys€� for the best
way to list all existing shortcut keys. There are pre-existing shortcuts for
changing case and font size.

Change Case:
Shift+F3 (toggles among UPPER, lower, and Title Case)

Font Size:
Grow Font 1 Point: Ctrl+]
Shrink Font 1 Point: Ctrl+[
--------------------------------------------------------------
MS-Excel
These procedures are modified directly from code provided at:
http://support.microsoft.com/kb/213649. Copy them to a standard module. To
assign a shortcut key, choose |Tools|Macro|Macros€¦|. Then, select the macro
name in the list, press the [Options] button, and assign a shortcut key.

Change Case:
Sub Uppercase()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
' Change the text in the range to uppercase letters.
x.Value = UCase(x.Value)
Next
End Sub

Sub Lowercase()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
x.Value = LCase(x.Value)
Next
End Sub

Sub Proper_Case()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
' There is not a Proper function in Visual Basic for Applications.
' So, you must use the worksheet function in the following form:
x.Value = Application.Proper(x.Value)
Next
End Sub

Font Size:
(assign shortcut keys as described above)
Sub increase1pt()
Selection.Font.Size = Selection.Font.Size + 1
End Sub

Sub decrease1pt()
Selection.Font.Size = Selection.Font.Size - 1
End Sub

Another option for changing Excel font size is to use existing toolbar
buttons. To add them to a toolbar:

1. Right-click on any toolbar and choose Customize.

2. In the €˜Categories: box on the €˜Commands tab, choose Format.

3. In the €˜Commands: box, scroll to the buttons [Increase Font Size] and
[Decrease Font Size] and drag them to a toolbar of your choice. Then click
[Close].

--
Jay


"ZEESHAN ANIS" wrote:

Hi Jay,
Thankyou very much its really very usefull tool I used it and get the
required result,
I need ur help more
How can we "change case" and "font size" in Ms Word & Ms Excel through
shortcut keys.


waiting for ur usual cooperation.

Best Regards
ZEESHAN ANIS

"Jay" wrote:

Hi Zeeshan -

One way would be to record a PasteSpecial macro and assign it to a shortcut
key.

1. Select any range of several cells and choose |Edit|Copy|.

2. Then choose |Tools|Macro|Record New Macro...|.

3. In the dialog that opens, enter a shortcut key in the 'Shortcut Key' box.
For example, enter "b".

4. Select any single destination cell and choose |Edit|Paste Special|Values.

5. Press the stop recording macro button. Open the VB Editor (Alt-F11) and
find the macro you just recorded (it should be named Macro1()).

6. The macro will have two functionl lines. The first will be something
like:
Range("E1").Select. Delete that line.

----------------
To use the macro on a worksheet, select cells, choose copy, select the
destination and press Ctrl-b. Copy the macro to any workbook you need it in
or copy it to your Personal.xls workbook so it is always available. Search
Google for Personal.xls for details about how to use the macro in your
personal macro workbook.

I'll be offline immediately after this post, but will check back in about 10
hrs. Good luck.
--
Jay


"ZEESHAN ANIS" wrote:

How can we paste special value through shortcut keys.

Jay

Be careful when using the change case macros you provided for Excel.

They will wipe out any formulas in the selected range and return values only.

Better to go with a trap for formulas.

Sub LowerCase()
Dim Rng As Range
For Each Rng In Selection.Cells
If Rng.HasFormula = False Then
Rng.Value = LCase(Rng.Value)
End If
Next Rng
End Sub


Gord Dibben MS Excel MVP

On Mon, 9 Apr 2007 11:36:04 -0700, Jay wrote:

Hi Zeeshan –
--------------------------------------------------------------
MS-Word
Search the Word Help System for “Print a list of shortcut keys” for the best
way to list all existing shortcut keys. There are pre-existing shortcuts for
changing case and font size.

Change Case:
Shift+F3 (toggles among UPPER, lower, and Title Case)

Font Size:
Grow Font 1 Point: Ctrl+]
Shrink Font 1 Point: Ctrl+[
--------------------------------------------------------------
MS-Excel
These procedures are modified directly from code provided at:
http://support.microsoft.com/kb/213649. Copy them to a standard module. To
assign a shortcut key, choose |Tools|Macro|Macros…|. Then, select the macro
name in the list, press the [Options] button, and assign a shortcut key.

Change Case:
Sub Uppercase()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
' Change the text in the range to uppercase letters.
x.Value = UCase(x.Value)
Next
End Sub

Sub Lowercase()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
x.Value = LCase(x.Value)
Next
End Sub

Sub Proper_Case()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
' There is not a Proper function in Visual Basic for Applications.
' So, you must use the worksheet function in the following form:
x.Value = Application.Proper(x.Value)
Next
End Sub

Font Size:
(assign shortcut keys as described above)
Sub increase1pt()
Selection.Font.Size = Selection.Font.Size + 1
End Sub

Sub decrease1pt()
Selection.Font.Size = Selection.Font.Size - 1
End Sub

Another option for changing Excel font size is to use existing toolbar
buttons. To add them to a toolbar:

1. Right-click on any toolbar and choose Customize.

2. In the ‘Categories:’ box on the ‘Commands’ tab, choose Format.

3. In the ‘Commands:’ box, scroll to the buttons [Increase Font Size] and
[Decrease Font Size] and drag them to a toolbar of your choice. Then click
[Close].

Ouch. That would create problems, wouldn't it... Thanks Gord.

Zeeshan, heed Gord's advice and replace the excel changecase procedures in
my previous post with the code he provided. Modify as needed for UCase and
Application.Proper versions.

Thanks again, Gord. I saw that HasFormula trap somewhere and forgot to
follow up on it. Much better.
--
Jay


"Gord Dibben" wrote:

Jay

Be careful when using the change case macros you provided for Excel.

They will wipe out any formulas in the selected range and return values only.

Better to go with a trap for formulas.

Sub LowerCase()
Dim Rng As Range
For Each Rng In Selection.Cells
If Rng.HasFormula = False Then
Rng.Value = LCase(Rng.Value)
End If
Next Rng
End Sub


Gord Dibben MS Excel MVP

On Mon, 9 Apr 2007 11:36:04 -0700, Jay wrote:

Hi Zeeshan €“
--------------------------------------------------------------
MS-Word
Search the Word Help System for €œPrint a list of shortcut keys€� for the best
way to list all existing shortcut keys. There are pre-existing shortcuts for
changing case and font size.

Change Case:
Shift+F3 (toggles among UPPER, lower, and Title Case)

Font Size:
Grow Font 1 Point: Ctrl+]
Shrink Font 1 Point: Ctrl+[
--------------------------------------------------------------
MS-Excel
These procedures are modified directly from code provided at:
http://support.microsoft.com/kb/213649. Copy them to a standard module. To
assign a shortcut key, choose |Tools|Macro|Macros€¦|. Then, select the macro
name in the list, press the [Options] button, and assign a shortcut key.

Change Case:
Sub Uppercase()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
' Change the text in the range to uppercase letters.
x.Value = UCase(x.Value)
Next
End Sub

Sub Lowercase()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
x.Value = LCase(x.Value)
Next
End Sub

Sub Proper_Case()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
' There is not a Proper function in Visual Basic for Applications.
' So, you must use the worksheet function in the following form:
x.Value = Application.Proper(x.Value)
Next
End Sub

Font Size:
(assign shortcut keys as described above)
Sub increase1pt()
Selection.Font.Size = Selection.Font.Size + 1
End Sub

Sub decrease1pt()
Selection.Font.Size = Selection.Font.Size - 1
End Sub

Another option for changing Excel font size is to use existing toolbar
buttons. To add them to a toolbar:

1. Right-click on any toolbar and choose Customize.

2. In the €˜Categories: box on the €˜Commands tab, choose Format.

3. In the €˜Commands: box, scroll to the buttons [Increase Font Size] and
[Decrease Font Size] and drag them to a toolbar of your choice. Then click
[Close].

Thanks Jay and Gord.
Its working and I will try to use these tool maximum.

One more time I need ur help.
How can we delete the personal macro.
When I am deleteing it the error shows.
"CANNOT EDIT A MACRO ON A HIDDEN WORKBOOK.UNHIDE THE WORKBOOK USING THE
UNHIDE COMMAND"
please give me the best web address where i can get maximum information
about Macros.

Thanks again.

Best Regards

"Jay" wrote:

Hi Zeeshan €“
--------------------------------------------------------------
MS-Word
Search the Word Help System for €œPrint a list of shortcut keys€� for the best
way to list all existing shortcut keys. There are pre-existing shortcuts for
changing case and font size.

Change Case:
Shift+F3 (toggles among UPPER, lower, and Title Case)

Font Size:
Grow Font 1 Point: Ctrl+]
Shrink Font 1 Point: Ctrl+[
--------------------------------------------------------------
MS-Excel
These procedures are modified directly from code provided at:
http://support.microsoft.com/kb/213649. Copy them to a standard module. To
assign a shortcut key, choose |Tools|Macro|Macros€¦|. Then, select the macro
name in the list, press the [Options] button, and assign a shortcut key.

Change Case:
Sub Uppercase()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
' Change the text in the range to uppercase letters.
x.Value = UCase(x.Value)
Next
End Sub

Sub Lowercase()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
x.Value = LCase(x.Value)
Next
End Sub

Sub Proper_Case()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
' There is not a Proper function in Visual Basic for Applications.
' So, you must use the worksheet function in the following form:
x.Value = Application.Proper(x.Value)
Next
End Sub

Font Size:
(assign shortcut keys as described above)
Sub increase1pt()
Selection.Font.Size = Selection.Font.Size + 1
End Sub

Sub decrease1pt()
Selection.Font.Size = Selection.Font.Size - 1
End Sub

Another option for changing Excel font size is to use existing toolbar
buttons. To add them to a toolbar:

1. Right-click on any toolbar and choose Customize.

2. In the €˜Categories: box on the €˜Commands tab, choose Format.

3. In the €˜Commands: box, scroll to the buttons [Increase Font Size] and
[Decrease Font Size] and drag them to a toolbar of your choice. Then click
[Close].

--
Jay


"ZEESHAN ANIS" wrote:

Hi Jay,
Thankyou very much its really very usefull tool I used it and get the
required result,
I need ur help more
How can we "change case" and "font size" in Ms Word & Ms Excel through
shortcut keys.


waiting for ur usual cooperation.

Best Regards
ZEESHAN ANIS

"Jay" wrote:

Hi Zeeshan -

One way would be to record a PasteSpecial macro and assign it to a shortcut
key.

1. Select any range of several cells and choose |Edit|Copy|.

2. Then choose |Tools|Macro|Record New Macro...|.

3. In the dialog that opens, enter a shortcut key in the 'Shortcut Key' box.
For example, enter "b".

4. Select any single destination cell and choose |Edit|Paste Special|Values.

5. Press the stop recording macro button. Open the VB Editor (Alt-F11) and
find the macro you just recorded (it should be named Macro1()).

6. The macro will have two functionl lines. The first will be something
like:
Range("E1").Select. Delete that line.

----------------
To use the macro on a worksheet, select cells, choose copy, select the
destination and press Ctrl-b. Copy the macro to any workbook you need it in
or copy it to your Personal.xls workbook so it is always available. Search
Google for Personal.xls for details about how to use the macro in your
personal macro workbook.

I'll be offline immediately after this post, but will check back in about 10
hrs. Good luck.
--
Jay


"ZEESHAN ANIS" wrote:

How can we paste special value through shortcut keys.

Thanks Jay and Gord.
Its working and I will try to use these tool maximum.

One more time I need ur help.
How can we delete the personal macro.
When I am deleteing it the error shows.
"CANNOT EDIT A MACRO ON A HIDDEN WORKBOOK.UNHIDE THE WORKBOOK USING THE
UNHIDE COMMAND"
please give me the best web address where i can get maximum information
about Macros.

Thanks again.

Best Regards


"Gord Dibben" wrote:

Jay

Be careful when using the change case macros you provided for Excel.

They will wipe out any formulas in the selected range and return values only.

Better to go with a trap for formulas.

Sub LowerCase()
Dim Rng As Range
For Each Rng In Selection.Cells
If Rng.HasFormula = False Then
Rng.Value = LCase(Rng.Value)
End If
Next Rng
End Sub


Gord Dibben MS Excel MVP

On Mon, 9 Apr 2007 11:36:04 -0700, Jay wrote:

Hi Zeeshan €“
--------------------------------------------------------------
MS-Word
Search the Word Help System for €œPrint a list of shortcut keys€� for the best
way to list all existing shortcut keys. There are pre-existing shortcuts for
changing case and font size.

Change Case:
Shift+F3 (toggles among UPPER, lower, and Title Case)

Font Size:
Grow Font 1 Point: Ctrl+]
Shrink Font 1 Point: Ctrl+[
--------------------------------------------------------------
MS-Excel
These procedures are modified directly from code provided at:
http://support.microsoft.com/kb/213649. Copy them to a standard module. To
assign a shortcut key, choose |Tools|Macro|Macros€¦|. Then, select the macro
name in the list, press the [Options] button, and assign a shortcut key.

Change Case:
Sub Uppercase()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
' Change the text in the range to uppercase letters.
x.Value = UCase(x.Value)
Next
End Sub

Sub Lowercase()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
x.Value = LCase(x.Value)
Next
End Sub

Sub Proper_Case()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
' There is not a Proper function in Visual Basic for Applications.
' So, you must use the worksheet function in the following form:
x.Value = Application.Proper(x.Value)
Next
End Sub

Font Size:
(assign shortcut keys as described above)
Sub increase1pt()
Selection.Font.Size = Selection.Font.Size + 1
End Sub

Sub decrease1pt()
Selection.Font.Size = Selection.Font.Size - 1
End Sub

Another option for changing Excel font size is to use existing toolbar
buttons. To add them to a toolbar:

1. Right-click on any toolbar and choose Customize.

2. In the €˜Categories: box on the €˜Commands tab, choose Format.

3. In the €˜Commands: box, scroll to the buttons [Increase Font Size] and
[Decrease Font Size] and drag them to a toolbar of your choice. Then click
[Close].