Tired of repeating operations while managing data? It is very understandable. Repeating the very same mathematical operation on all the numbers in s data sheet can be very frustrating. Excel spreadsheets can be managed wonderfully, repeating tasks and getting frustrated can be successfully prevented in Microsoft Excel using Macro. Now here is how you record and use a macro and manage data without making your life miserable. The following steps are for recording simple macro in Microsoft Excel.
First open the Excel application. This should be simple. You go to the “start” menu on your screen and follow “all programs”. Find Microsoft Excel and click to open.
Now, go to “file” and then “new” to open a new spreadsheet, “save as” to keep the new workbook saved by a different name to avoid any confusion.
Find the “tools” button at the top menu bar of the new spread sheet and click. Here click “macro” following the temptation but avoid the “record macro” button for the time and go to “security” from there instead. Macro requires the use to set a security level. Ideally, you should set the security to medium. So. Click “medium” and it will be done. Click Okay to finish off this part of the business. The menu would close.
Now, go to the favorite button again. “Tools” menu followed by Macro again would show you a button “record macro”. Now you will be asked to enter the desired name: you could have your company’s name or initials. Note, however, that the initial character has to be a letter and the rest is up to you: you can sue letters or numbers and signs if you please. You cannot have spaces between characters though.
In the “Shortcut key” section, you would be required to type in a shortcut symbol to use to stimulate macro immediately. This could be the first character of the name you selected for the application.
You would now be required to specify where you want to place the file. In the “store macro in” option you will have to select the destination. For an example, consider “store in… personal macro workbook”.
Find the descriptions section below and briefly describe the macro. After this you can save and close simply by clicking OK.
The recording formally comes now. A tiny window would pop up and it would show a blue icon. Whenever you want to stop recording, you can press the blue icon.
Here you would start entering say the titles related to the name of the managers in column A, first row. As soon as you are done entering the names, you need to click the blue icon to stop.
You can double check the recording now because once you have completed the above steps correctly, you are done. For double checking open a fresh Microsoft Excel window and press the keys Ctrl + (the selected shortcut code) and you will be directed to the macro you had recorded. Make sure you remember the code for shortcut to make the job easier.
As an alternative you can go to Microsoft Excel, and select tools, and then click on macro, and ten macros, from where you will have to select a directory or store where you had placed the record. Let’s just say, in the “macros” section you will find “personal macro workbook” and if you click there, you will have the list of records that you had stored in that folder. Of course the shortcut method is easier, but this is the longer route and requires you to know where the desired record has been saved by you.
These are the series of simple steps you need to follow in order to record a simple macro. In fact, when you learn this it is a very good idea to practice it and get the hang of it. This is so because as you excel, literally, you will need to record more complex macros and that would require a strong base. For complex records, there are complex techniques and procedures to record them. Gradually, you will see how the system works for you and it is not going to be a big deal at all by the end of the day. Learning afterwards can be facilitated by prior practice so go for it!
- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro