Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Create an exel 2007 shortcut key
How do I create an excel shortcut key? For instance, I want to create a
shortcut key for Moving or Copying a worksheet. I added it to the quick access toolboar, but cannot figure out to create a shortcut key for that command. Thank you for your help. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Create an exel 2007 shortcut key
Not sure why you need a shortcut key, when a button is already handy, but
here are the instructions from the Excel help file. You'll need to put the command in a macro, then: "To assign a CTRL combination shortcut key to run the macro, in the Shortcut key box [click View Macros - select macro - click Options], type any lowercase letter or uppercase letter that you want to use. Note The shortcut key will override any equivalent default Excel shortcut key while the workbook that contains the macro is open. For a list of CTRL combination shortcut keys that are already assigned in Excel, see Excel shortcut and function keys." "katmagic" wrote: How do I create an excel shortcut key? For instance, I want to create a shortcut key for Moving or Copying a worksheet. I added it to the quick access toolboar, but cannot figure out to create a shortcut key for that command. Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel 2007, how can you create a desktop shortcut for a file? | Excel Discussion (Misc queries) | |||
Exel 2007 to printalbe webpage? | Excel Discussion (Misc queries) | |||
Template location Exel 2007 | Excel Discussion (Misc queries) | |||
Exel 2002/2007-Always get 31 Oct 06 | Excel Discussion (Misc queries) | |||
How do I create a bar (1-100) in exel? | Charts and Charting in Excel |