CTRL PAGE UP NOT FUNCTIONING WELL

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.

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.

Replies (3)

Stephen Nabena

Independent Advisor

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. 2. 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.