How to Record macros in Excel

Topic:  Excel, Microsoft Office  Product:  Excel , Microsoft office 2007  Related Questions:  razer synapse macros stop   macro showafotab excel   macros smartartlayouts excel  

Microsoft Excel gives you a lot of ways to make building and using your spreadsheets a bit easier. One of the simplest tools is the macro. Excel macros can perform complicated series of actions or simply record commonly used commands. Read to learn how to record Excel macros. Here gives you a simple example.

Solution

  1. Launch Microsoft Excel and open a workbook.
    Launch Microsoft Excel 2007
    Launch Microsoft Excel 2007
  2. Record a simple macro, which would apply the Italic formatting.
    Open a workbook, select the cell where you want to record a macro, and select View->Macros->Record Macro.
    Record a simple macro
    Record a simple macro
  3. Choose Personal Macro Workbook as the storage path, and type the name in the Macro name box. Click OK to quit the dialog box.
    Record macros in Excel
    Record macros in Excel
  4. To record the macro, turn to the Home tab, and click the Italic button. After those operations, click the record-stop button to stop recording.
    Record macros in Excel
    Record macros in Excel
     
    To stop recording, you also can select View-> Macros-> Stop Recording.
    Stop recording
    Stop recording
  5. Now we'll test the macro by typing some text in the cell and clicking the Macros icon to apply the macro to it.
    Record macros in Excel
    Record macros in Excel
  6. Select the macro you created, and click Run.
    Record macros in Excel
    Record macros in Excel
  7. The macro applies Italic formatting.
    The macro applies Italic formatting
    The macro applies Italic formatting

Tips

  • Be slow and careful while entering the macro text.
  • Don't use common command keys (X, C, V, Z) for your macros.
  • Prevent accidentally executing other commands by always using SHIFT and CONTROL together for your macros.

See also

Microsoft Office System
How to Calculate the Number of Work Days Between Two Dates in Excel

How to Copy Macros Between Documents in Word
Sometimes a given document may contain some useful macros that we will use in other documents, and we want to copy them to the new documents. But, how to copy macros between documents in Word?
How to Rename and Delete Macros in Word
We always copies and deletes only entire modules. But they may contain some individual macros and we may just want to operate upon only these macros. So, how to renaming and deleting macros in Word?
How to Rename and Delete Macros in Microsoft Word
Sometimes a given document may contain some useful macros. Sometimes we can find that the existing macros’ name is not appropriate or the macro is no more suitable for the Word document. Then we need to rename the macro or delete it. Here I will show you how to rename and delete macros in Microsoft Word.

Search for Related Topics

macros en excel starter   hummingbird macro read excel   macro table excel   record excel   excel manpower record   excel equipment records tracker   food temperature equipment records excel  

Related Unresolved Questions

more »
Options

Authors

Tagged Add my tag

excel , excel 2007 , excel macro , macro , office , record macro , vba , macro checklist excel , macro scribble excel , macros ie8 excel , creare macro con excel starter , macros en excel xls

Recent Searches

excel organogram shapes   3.0.89 game live windows   aircel code generator puk   blackberry email etisalat signature   3 admin ammyy ubuntu   a4 paper ps   dxdiag windows8