Share via

CTRL PAGE UP NOT FUNCTIONING WELL

Anonymous
2024-04-12T14:26:20+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.

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. Rich~M 20,370 Reputation points Volunteer Moderator
    2024-05-14T00:00:38+00:00

    Here are two previous answers that have some good information on this topic.

    Excel Shortcut for Navigating Between Tabs Not Working as Expected, - Microsoft Community

    Switch between sheets using keyboard in excel - Microsoft Community

    Hope these discussions help.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-05-13T23:51:57+00:00

    I have same problem; It's driving me bonkers!!! Tried Stephen's solutions and no luck; PLEASE HELP!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-04-12T15:12:11+00:00

    Hello Gentry,

    * I am a Microsoft user like you, providing solutions to community members; I am NOT a Microsoft employee.

    It sounds like there might be a conflict with a macro assigned to the CTRL+PGUP shortcut in Excel 2013. Here are a couple of solutions you can try:

    1. Clear Assigned Macros: Press Alt + F11 to open the Visual Basic Editor (VBE). In the VBE project window, navigate to the VBAProject containing your workbook. Go to the "Insert" menu and select "Module." (This creates a new module if one doesn't exist) In the module code window, paste the following lines and press Enter:

    Application.OnKey "^^{PGUP}", "" ' Clear Ctrl+PgUp assignment Application.OnKey "^^{PGDN}", "" ' Clear Ctrl+PgDn assignment (optional, for completeness)

    Close the VBE (using the "X" button in the top right corner) and return to Excel. Try using CTRL+PGUP again. It should now switch worksheets as intended.

    1. Disable Add-Ins (if applicable): In some cases, add-ins can interfere with keyboard shortcuts. Try temporarily disabling your Excel add-ins to see if it resolves the issue:

    Go to "File" > "Options" > "Add-Ins." In the "Manage" dropdown, select "COM Add-Ins" and click "Go." Uncheck any add-ins that are listed and click "OK." Restart Excel and see if CTRL+PGUP functions normally. If it does, you can re-enable your add-ins one by one to identify the culprit.

    Hope this helps.

    • Stephen N.

    Was this answer helpful?

    0 comments