Lesson 2 - Recording and Playing back Macros

Assigning Shortcut Keys to Play Back Macros

  • When you assign a shortcut key combination for a macro, choose one that is not already used.
  • There are already many CTRL + Letter combinations already taken up by Excel’s default shortcuts.
  • It’s a good idea to use the CTRL + Shift + Letter combination instead of just CTRL + Letter.
  • Here is a site that shows a quick reference guide to Excel’s existing keyboard shortcuts so you know which ones to avoid: http://www.cpearson.com/excel/keyboardShortcuts.htm

Write your comments and feedback below

  • If you have questions or comments about this lesson, write it in the section below.
  • Alternatively you can email the instructor Victor at [email protected]

Complete and Continue  
Discussion

2 comments