Because Excel 2007 is running the commands, tasks are performed at the speed of a computer and without interruption. For example, a macro was used to format the range in the following figure. Manually, the task could take 10 or more seconds, but by using the macro, the range was formatted in a fraction of a second. The macro not only saves you time, it saves you from having to remember a lot of tedious details. With a macro, the formatting is exactly the same every time you run it.
Start by turning on the macro recorder and running through the tasks. When you turn off the recorder, Office Excel 2007 converts every click and key press into a series of commands and functions that are stored as a module in a workbook or in Excel 2007. The next time you need to perform the tasks, run the macro, and the commands and functions are performed automatically in the order in which they were recorded.
Think about the tasks that you need to automate when you work with certain types of worksheets. For example, you could create a macro that quickly hides a group of monthly columns so that only the summary data shows. You could create another macro to show all of the details again. You could even create a macro to format cells so that long headings wrap around the cells.
To create macros, you need to first enable the Developer tab in Office Excel 2007 and change your security for macros. Then, you can record and run macros when you need them. To run a macro, a user does not necessarily need the Developer tab.