Macros are nothing but short cuts for creating repetative tasks in Excel.
Following are the steps outlined to create a new macro.
1. Click on Start>Programs>Microsoft office>Microsoft Excel to open the application. Then, go to Start>New to open a new spreadsheet. Go to File>Save as and save the new file as Book1.xls
2. Go to Tools>Macro>Record New Macro.
3. A pop up window named Record Macro will appear. Enter a name for the macro under Macro Name field e.g Test Macro; enter a short cut key to be used as a shortcut to execute the macro. For. E.g. Ctrl+Shift+C
4. Select the location of the macro under Store macro in saving this macro in the Personal Macro Workbook or New Work Book or This Workbook so that it is available when you create new spreadsheets and want to use the macro.
5. Enter a brief description of the macro under Description field and click OK, now you will need to record the activities through the macro
6. A tiny pop up window having a blue button can be pressed at any time to stop recording the steps for the macro.
7. A simple example of macro which can be used in any work book is as follows.
Enter the field names in the rows from A1 to G1. Name, Address, City, State, Zip, Phone, Fax. Then click on the blue button to stop recording the new macro. Remember the shortcut key assigned for macro
8. Testing the macro: Go to File>New to open a new spreadsheet. Press the short cut key assigned for the macro [Ctrl+Shift+C]. You will find that the the field names gets created in the spread sheet automatically.