Forum Discussion

Bombini's avatar
Bombini
Copper Contributor
Mar 03, 2022

Use Ctrl-Shift-Z to redo actions

Does anybody know how to make it so I can use Ctrl-Shift-Z to perform the redo action in Excel? It was... doable in Word, but Excel is proving to be a much more difficult challenge. I've tried working with macros to get the action done, but I can't seem to figure out how to get it to do what I want at all. Any solution is more than welcome! It's pretty nuts that in 2022 you still can't edit keyboard shortcuts in Excel, so if I'm missing an obvious solution, please let me know!

4 Replies

  • Enchiridion's avatar
    Enchiridion
    Copper Contributor

    Bombini I couldn't find a way to do it in Excel itself, so I used https://www.autohotkey.com/ to remap the shortcut (I use this program with a lot of stubborn apps).

     

    #IfWinActive ahk_class XLMAIN
    $^+z::Send ^y
    #IfWinActive

     

  • Pil0tXia's avatar
    Pil0tXia
    Copper Contributor

    Of course you can. Just follow the steps in this article: https://support.microsoft.com/en-us/office/customize-keyboard-shortcuts-9a92343e-a781-4d5a-92f1-0f32e3ba5b4d

    Redo action is named "EditRedo" in the command lists. You may need to delete the Ctrl+Shift+Z binding assigned to "RestChar" command to avoid conflict first.

  • Bombini 

    The built-in shortcut is Ctrl+Y.

    The problem with using a macro is that running VBA code clears the undo/redo stack, so it defeats the purpose.

    I'd stick with Ctrl+Y.

Resources