Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Resolved · Low Priority · Version Standard
Hi Laura
To record a macro do the following:
1. Open the Tools menu, select Macro and then click Record New Macro.
2. In the Record Macro dialog box, type a name for the macro in the Macro name box.
NB 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.
3. 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. To finish recording the macro, click the Stop Recording button.
Hope this helps
Carlos
|
Excel tip:Adding date and timeHere are two quick ways to add the date and time to your spreadsheet: |
We'll call during UK business hours
Server loaded in 0.09 secs.