Friday, January 14, 2011

How to Use Macros in Excel 2003


Recording a Basic Macro in Excel
1. Open Microsoft Excel.
2. Type some data in the first row. You will create a macro that makes the first row bold and then creates a new worksheet; this is simply to demonstrate what macros can do.
3. Click 'Tools,' then 'Macro' then 'Record New Macro.' Name your macro, and assign a shortcut key to it.
4. Click Row '1,' then hold the 'Ctrl' key and press 'B'. This will make that row bold.
5. Hold the 'Ctrl' key and press 'F11.' This will create a new worksheet.
6. Click the blue 'Stop' square in the 'Stop Recording' window to stop recording your macro.
7. Type something in the first row of your new worksheet.
8. Press your shortcut key assigned to the macro, or click 'Tools,' 'Macro' and then 'Macros.' Select your macro and click 'Run.'

Blogger news