Share via

Excel 2013 CTRL+PGUP and CTRL+PGDOWN shortcuts do not work

Anonymous
2014-11-23T19:32:28+00:00

All my default shortcuts on Excel 2013 (CTRL+C, etc.) work perfectly except this one. Whenever I press CTRL+PGUP, which should move me to the worksheet tab immediately to the left, it inserts a "Macro1," "Macro 2," etc. sheet depending on how many times I have tried the shortcut. I first reset all the customizable options in Excel then I reset my entire Microsoft Office package and the shortcut still goes to Macro instead of switching worksheets. Couldn't find an issue like this so far on the internet and the customer support technical people couldn't figure it out.

Thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2014-11-23T20:19:56+00:00

    Try the following:

    • Press Alt+F11 to activate the Visual Basic Editor.
    • Press Ctrl+G to activate the Immediate window.
    • Type    Application.OnKey "^{PGUP}"    then press Enter.
    • Type    Application.OnKey "^{PGDN}"   then press Enter.
    • Switch back to Excel.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. HansV 462.6K Reputation points
    2014-11-23T22:58:18+00:00

    The standard shortcut for inserting a macro sheet is Ctrl+F11. Have you installed some kind of utility that remaps PgUp to F11?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2014-11-23T22:20:37+00:00

    Thanks for the response, but after I did that I still got a Macro1 sheet

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments