Printable View
Hi,
Macros are advanced features that can speed up editing or formatting you may perform often in an Excel worksheet. They record sequences of menu selections that you choose so that a series of actions can be completed in one step. but i dont know how to record them. please help me.
Thank you
Recording a Macro
To record a Macro:
- Click the View tab on the Ribbon
- Click Macros
- Click Record Macro
- Enter a name (without spaces)
- Enter a Shortcut Key
- Enter a Description
- Perform the Macro
- Click Marcos
- Click Stop Recording
- Stop Recording Macro Button
Here's how to record a macro to apply these formats:
1. In the workbook where you track your accounts receivable, click one of the cells you're going to format.
2. Point to Macro on the Tools menu, and then click Record New Macro.
3. In the Record Macro dialog box, type a name for the macro in the Macro name box. Macro names must start with a letter and can include letters, numbers, and underscore characters, but can't include spaces. You don't need to change the other boxes:
When you click OK, the Stop Recording toolbar appears, and you're ready to record. Until you stop the recording, every Excel command and keystroke will be recorded in the macro, in the order in which they are entered.
4. Now format the cell the way your boss wants it flagged: click Cells on the Format menu, click the Font tab, click Bold under Font style, click Red for Color, click the Border tab, click Red for Color, click the border thickness you want, click Outline, and then click OK.
5.To finish recording the macro, click the Stop Recording button: