How to create Excel macros and automate your spreadsheets Use macros to combine multiple tasks into a single, one-second transaction.