software

Hello,

Can someone tell me if there are keyboard shortcuts for the following
commands.

a. Paste Special -gt; Values
b. Paste Special -gt; Format
c. Insert -gt; Function -gt; VLOOKUP

Thanks in advance for your help,
Scott

Hi,

Paste Special -gt; Values - Alt esv and enter

Paste Special -gt; Formats - Alt est and enter

Am not sure if thereis a shortcut directly to vlookup , but pressing
Shift F3 will take you to the formula wizard.

Its easier, if you start writing vlookup functions directly in the cell
instead of using the Formula wizard.

Regards

Govind.

Scott wrote:
gt; Hello,
gt;
gt; Can someone tell me if there are keyboard shortcuts for the following
gt; commands.
gt;
gt; a. Paste Special -gt; Values
gt; b. Paste Special -gt; Format
gt; c. Insert -gt; Function -gt; VLOOKUP
gt;
gt; Thanks in advance for your help,
gt; Scott

For other shortcuts, function keys and related information you can
look them up in
www.mvps.org/dmcritchie/excel/shortx2k.htm
most information is in Help, but the problem with Help is that it is
scattered across many pages so you can't just use Ctrl F to
find something real quickly in one place.

If you want an arrangement without descriptions
more oriented to showing what shortcuts there are left that you
can assign to your own without overriding a builtin shortcut
see Chip Pearson's (has HTML and zipped for Excel and for VBA)
www.cpearson.com/excel/ShortCuts.htm---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm