From the course: Excel: Macros in Depth (Microsoft 365)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Run a macro from a keystroke shortcut
From the course: Excel: Macros in Depth (Microsoft 365)
Run a macro from a keystroke shortcut
- A fast way to run a macro is by way of a keystroke shortcut. the problem sometimes is, if you start to create more and more macros and assign keystroke shortcuts to them, can you remember them all? So you might have to develop a little list to keep it handy. And when we set up a keystroke shortcut we can only use any of the lower case letter or any of the upper case letters. Now on the screen we're seeing a worksheet called "Excel Keystroke Shortcuts" in the file called "Keystroke Playback". We want to show you how to set up a keystroke shortcut, also how to make a change or addition to a macro that doesn't have a keystroke shortcut. Keep in mind we can go to macros by way of the Developer or View tab, or press alt+F8, to see what macros exist in this worksheet. Does Highlight_Number_Cells have a keystroke shortcut? We'll click options, we might in some situations want to change this, or other cases eliminate it.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.