Tag: macros in Excel

Learning Microsoft Excel macros

Posted by – February 26, 2009

Microsoft Excel is a spreadsheet and probably the most commonly used on most computers today. There are tools at your fingertips and can be confusing, but it can also give you many ways to make your work easier. One of the simplest is the macro. If you used a phrase or a piece of text or data, you can connect to Excel with a few keystrokes. Read on to learn how to use macros in Excel.

The measures relating to the use of macros

1. Choose your text block in front of you to read what he wrote. On the main menu bar, click Tools, Macro and Record New Macro.

3. A pop-up and you must enter at least two things. You need to know what to call your new macro, and you need to know what key to use for access.

4. Click "OK" and you’re ready to begin entering your macro. Type exactly and only the data you want to appear in the macro. We use the word, for example, as an example.

5. For example, type, and then click on "Tools" "Macro" and "Stop Recording". This completes the macro and makes it available for you.

6. Click on "Shift" and "Control" to run the macro to insert the word "example". This will insert text in the active cell.

7. Facilitating the use of macros. Click on "Tools" then "Customize." Select "Toolbars" and then check the box next to "Visual Basic". Now click "Close." You can drag the toolbar at the top with the rest of the toolbar.

For more information about using a keyword, type the word, place the cursor on it and press the F1 key. Sometimes it helps to look at the example of aid rather than to read the details. Do not use the command keys for macros. It’s always good to use both "Shift" and "Control" with its macros.

  • Share/Bookmark