Additionally, you can assign a keyboard shortcut to the macro by editing your macros. With the keyboard shortcut configured, you can select the cells you want to convert to uppercase and press the shortcut key for uppercase in Excel to achieve the conversion quickly, using the “Ctrl”, ...
excel使用快捷键（Excel uses shortcut keys）Menu and toolbar operations Alt+F activates the file menu Alt+E activates the edit menu Alt+V activates the View menu Alt+I activates the Insert menu Alt+O activates the format menu Alt+T activates the tools menu Alt+D activates the data menu Al...
A. You can enter a cell and stay in the same cell with the following shortcut keys: In Excel, you can enter and stay in the same cell by pressing the two keyboard keys of "Ctrl" and "Enter" simultaneously instead of pressing the "Enter" key. Q. How do I add a blank row between...
Excel Shortcut KeyDescription Navigation Ctrl + F6Switches between workbooks. This is very useful when you have multiple workbooks open. Ctrl + Page UpSelect the previous sheet in the workbook. Ctrl + Page DownSelect the next sheet in the workbook. ...
You can then use the following shortcut keys to manipulate the borders tab in the dialog box: Alt+T applies or cancels the upper frame line Alt+B applies or cancels the lower frame line Alt+L applies or cancels the left frame line ...
Alt+F11: opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA). F12 F12 alone: displays the Save As dialog box. Top of Page Other useful shortcut keys Key Description Alt Displays the Key Tips (new sho...
If you always use Ctrl+Shift key combinations when you assign shortcut keys to your macros, you’ll be less likely to override a built-in shortcut. Click OK to return to the Macro dialog box, and then click Cancel to return to the worksheet. Select cells D11:F12, and press Ctrl+...
Name Application.MacroOptions([Macro], [Description], [HasMenu], [MenuText], [HasShortcutKey], [ShortcutKey], [Category], [StatusBar], [HelpContextId], [HelpFile]) Synopsis Sets the description and help files displayed for a macro or user-defined functio
ShortcutKey Optional Variant Required if HasShortcutKey is True; ignored otherwise. The shortcut key. Category Optional Variant An integer that specifies an existing macro function category (Financial, Date & Time, or User Defined, for example). See the remarks section to determine the integers ...
public virtual void MacroOptions (object Macro, object Description, object HasMenu, object MenuText, object HasShortcutKey, object ShortcutKey, object Category, object StatusBar, object HelpContextID, object HelpFile); Parameters Macro Object Description Object HasMenu Object MenuText...