+ Reply to Thread
Results 1 to 4 of 4

excel shortcut key with Alt

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    10

    excel shortcut key with Alt

    Hi,

    anyone can help me change these shortcut letter after you press the "alt" in the keyboard?
    preferably would like to change the M2 for the X

    excel1.png

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: excel shortcut key with Alt

    The 'Alt' shortcuts for the ribbon are hard-coded into Excel, I think. However, there are some ways you can do what you want (or similar).

    Firstly, there are often 'Ctrl' shortcuts available for popular commands. In the English version of Excel, 'Insert Hyperlink' (your 'Lien hypertexte') can be accessed using 'Ctrl-K'. There's a list of shortcuts here: https://support.office.com/en-gb/art...9-9b7213f0040f (I don't know if they're all the same in the French Canadian version, sorry, but a web search for 'Touches de fonction et de raccourci d'Excel' should help).

    Secondly, you could write (or record) a macro and assign a keyboard shortcut to that. When you record a macro, you get the option to assign a shortcut, starting with 'Ctrl'. If you type an upper case letter like 'X', the dialogue will change from 'Ctrl+' to 'Ctrl+Shift+' - I advise using upper case, as most lower case 'Ctrl' shortcuts are already assigned to something else (as above). If you've already recorded the macro, open the 'Developer' tab, click 'Macros' then on the window that opens, select the macro you want and click 'Options' - you'll then get the same option to assign a shortcut key starting with 'Ctrl'.

    Thirdly, you could assign the command you want to your Quick-Access-Toolbar (QAT). If the command is on the ribbon, right-click it and select 'Add to Quick Access Toolbar'. If it's not (or you can't find it, which is a common problem), then click the little down-arrow to the right of the QAT and select 'More Commands'. Find the command you want and click 'Add' - you can move it up or down using the arrow keys at the right-hand side. Once a command is on the QAT, you can activate it using 'Alt' and a number - as you can see in the picture you have in your post. Putting your most commonly used commands at the top of the list (the left of the QAT) means you can access them using 'Alt-1', 'Alt-2' etc, which is quite quick.


    I hope that's of some help, even though it doesn't actually do what you asked for .
    Almost all of what I've written above uses English terms/labels but hopefully it's not too difficult to work out the French equivalents .

    p.s. your profile says you're using Excel 2003, but the picture is 2007 - if you use both, then it's best to say that, so that members here can customise answers to your version.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Registered User
    Join Date
    02-11-2014
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: excel shortcut key with Alt

    Thank you for the reply =),

    My company just recently changed our office from 2007 to 2013, and unfortunately had to stay with excel 2007 because of Hyperion Essbase being not compatible with 2013. and since then my alt shortcut key was changed ... that M2 is terrible compare to what I was used to have with the X. Before I simply go like alt+X+S and it will get me into Essbase menu and move on from there.
    I didn`t want to use the ctrl shortcut like you proposed since I wanted thing to differentiate between the CTRL shortcut and the alt shortcut. I have many many CTRL shortcut being used already for my macro. If it is hard-coded in excel, any way we can modified that?

    I surf around and found a way like you said with the alt+1 or alt+2 but it doesn`t suit me.

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: excel shortcut key with Alt

    If you really must replace one of the built-in 'Alt' shortcuts, then I think it might be possible using VBA, using this page as a start: http://www.rondebruin.nl/win/s4/win012.htm
    If you have a VBA expert at your company (or you are one yourself) then there might be a way of amending some of the 'Application.OnKey' code to disable the built-in Alt-??? shortcut and replace it with Alt-X. I've tried, but can't get it to work - and I don't know enough about the inner workings of the Excel ribbon to understand why what I've tried doesn't work - but maybe someone with more VBA knowledge than me can work it out. Good luck.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 02-20-2015, 08:13 AM
  2. Replies: 3
    Last Post: 02-21-2014, 10:19 AM
  3. Excel Shortcut Key
    By happy_smiler1 in forum Excel General
    Replies: 1
    Last Post: 11-20-2012, 04:40 PM
  4. using alt as a shortcut key/list of symbols for shortcut keys
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2010, 09:12 AM
  5. Replies: 15
    Last Post: 12-03-2009, 05:15 AM
  6. Excel shortcut
    By Motala in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-29-2009, 06:31 AM
  7. MS Excel shortcut
    By chrislamm in forum Excel General
    Replies: 4
    Last Post: 09-20-2005, 02:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1