Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 33
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel 2007, how can you create a desktop shortcut for a file? Mark 246 Excel Discussion (Misc queries) 6 June 25th 07 08:05 PM
Exel 2007 to printalbe webpage? David SS Excel Discussion (Misc queries) 4 February 15th 07 02:45 PM
Template location Exel 2007 Jon Sv. Excel Discussion (Misc queries) 2 January 4th 07 09:43 AM
Exel 2002/2007-Always get 31 Oct 06 [email protected] Excel Discussion (Misc queries) 1 November 18th 06 08:39 AM
How do I create a bar (1-100) in exel? mag7417 Charts and Charting in Excel 1 January 7th 06 05:03 AM


All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"