98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
How To Create A Macro In Excel 2010
Sun 23rd October 2011
An Excel macro can be used for lots of things. For example you could use a macro to locate the cursor in cell A1 and enter today's date, or you could open a particular file, create a table and autosum all the data, or with several files open you could choose the Arrange All view and show all the files vertically tiles. These examples are simply the result of Excel actions and you could do lots more with macros, for example copy data from one file to another, carry out particular calculations, or create a pivot table from an existing table of data.
To work with macros in Excel 2010 it's useful to display the Developer tab as this gives you more macro commands than available on the Review tab. To do this, choose the File Tab, then Option. In the Excel Options panel choose Customize Ribbon and in the right hand side of the display tick the box for the Developer Tab. Doing this will turn on the Developer tab.Then click OK to complete. Now we can create our first macro.
If you are going to create macro, it can be useful to practice the actions first. So place the cursor anywhere in the worksheet, but not in cell A1. Now we'll carry out the practice run. Choose CTRL+Home to move the cursor to cell A1. Now type in =TODAY() and press Enter. Today's date will appear in cell A1. That's the practice finished, so you can delete the contents of cell A1 and place the cursor in any other cell, and then record the real macro.
To actually record the macro we will give the macro a name, and also assign it to an optional CTRL key combination. Doing this lets us run the macro by name or by pressing the assigned keyboard combination. So to begin, in the Developer tab choose Record Macro. Give the macro the name, for example MYDATE1, assign the CTRL key + t, ensure THIS WORKBOOK is selected as the saved location, then click OK to start recording.
If you look carefully in the light blue status bar at the bottom of the screen, on the left hand side, you'll see a small blue button has appeared. This indicates a macro is being recorded. Now choose CTRL+Home and the cursor again goes to cell A1. Now type =TODAY() and press Enter. Today's date appears again in cell A1. That's the macro finished so we'll stop recording. To do this click once on the blue button on the lower status bar. Alternatively you can click on STOP RECORDING in the Developer Tab.
Now we'll test the macro. However first, delete the contents of cell A1 and place the cursor anywhere else on the worksheet. Then type CTRL+t and your macro should run. Alternatively in the Developer Tab you can click MACROS. In the Macros panel you'll see your macro. Ensure it is selected, then click RUN.
So creating a macro in Excel 2010 is straightforward and can be used to automate actions you carry out more than once. A macro can be assigned to a CTRL key combination with either an uppercase or lowercase letter. If you're interested in learning more about Excel 2010 macros, consider attending a training course. This can be a very effective way to really boost your Excel skills.
Author is a freelance copywriter. For more information on excel training courses london, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-2014-how-create-macro-in-excel-2010.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsTeach First
Senior Coordinator, Contracts Alison Schoeman Excel Intermediate The training course content was excellent and delivered really well. It will help me massively in my current role and I also feel it has really enhanced my professional development more widely. Thanks very much! Crown Prosecution Service
Specialist Prosecutor George Zachary Virtual training delivery skills Dennis was very engaging and I felt the course was useful. I would have liked to delve in a little more to the resources that were touched upon to see examples of how they might be used with practical examples of each. We did break out rooms, using pexels and polls. Really good session. Mayer Brown International LLP
Europe IT Learning And Development Supervisor Melissa Dow-smith Emotional Intelligence at Work Great course, excellent trainer - only suggestion would be sweeteners as well as sugar for the coffee. |
PUBLICATION GUIDELINES