These 46 Pro Excel Tips Will Transform You Into a Spreadsheet Magician Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

The reason to use it? Macros. When you create a macro, it doesn't work across every spreadsheet you create by default (like in Microsoft Word)—a macro is tied to the workbook in which it was ...