98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - Excel
excel courses - Excel
Resolved · Low Priority · Version Standard
Sarah has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course
Excel Advanced course
Excel
Please remind me how to record macros
RE: Excel
Hi Sarah
Thank you for your question; and apologies for the delay in response.
To record a macro, go to Tools - Macros - Record new macro.
Then name your macro. The name you enter cannot contain spaces.
Once you click OK, the steps/actions you take in Excel will start being recorded. A small toolbar should appear on your screen once you click OK.
If the steps you are taking involve making calculations, and you want to be able to use the same macro in other places using other cells in the spreadsheet, then click the Relative references button.
Once you have finished carrying out the series of steps you want the macro to perform for you, then click the Stop Recording button.
I hope this helps.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create and delete bordersTo put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range. |