Share via

Ctrl+home not working properly

Anonymous
2023-01-19T07:30:18+00:00

Hi,

I have been facing an issue with short cut key Ctrl+home.The Sheets called Macro 1, 2 3 and so on opens each time when I press Ctrl+home key instead of taking to the top left corner of the sheet.It creates lots of inconvenience while working in MS.Kindly advise how to sort this out.

Microsoft 365 and Office | Excel | Other | Other

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-01-19T08:33:03+00:00

    Hi I am Leon.

    On the Developer tab, in the Code group, click Macros. In the Macro dialog box, click Options.

    The Macro Options dialog box will appear. In the Shortcut key box, type any uppercase or lowercase letter that you want to use for the shortcut, and then click OK to save the changes.

    For lowercase letters, the shortcut is Ctrl + letter. For uppercase letters, the shortcut is Ctrl + Shift + letter.

    Close the Macro dialog box. Tip. It is recommended to always use uppercase key combinations for macros (Ctrl + Shift + letter) not to override the default Excel shortcuts. For example, if you assign Ctrl + f to a macro, you will lose the ability to call the Find and Replace dialog.

    https://www.ablebits.com/office-addins-blog/run-macro-excel-create-macro-button/#:~:text=Run%20a%20macro%20with%20custom%20keyboard%20shortcut&text=out%20these%20steps%3A-,On%20the%20Developer%20tab%2C%20in%20the%20Code%20group%2C%20click%20Macros,OK%20to%20save%20the%20changes.

    Was this answer helpful?

    0 comments