Select Personal Macro Workbook to use it in any Excel spreadsheet you open. Optionally, assign it a keyboard shortcut and give it a description. Click OK to start recording the macro.

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you.

Not everyone is familiar with Excel. You can protect the data input process by using Excel's UserForm object to collect data. Susan Harkins explains how.