Start Excel, any version (2003, 2007, 2010 or 2013). The number and arrangement of tabs on the working tape in the latest versions starting with Excel 2007, about the same. On the View tab, find the menu item "Macros".
Click on the arrow to reveal the drop down menu. Click on "Record macro." Open the macro recording window. Enter its name, for example, "Kakroo". In the "shortcut key" you can enter the key name, for example, Y. Then the recorded macro will run when press Ctrl and Y.
You can save the macro in this workbook. But then you will not be able to run it in other files, if the file cannot be opened in Excel. When recording in the personal macro workbook you will be able to use the macro in any workbook on your computer.
Enter a description for the macro, not to forget that he can do. After clicking "OK" will start recording.
Enter in cell A1 the text "How easy it is to record a macro in Excel!". Format it to your liking.
To stop recording click again on the View tab, open the dropdown menu of Macros and click "Stop recording".
Remove the cell with the established inscription, go to the menu "Macros" or use the shortcut Alt + F8. Select the macro "Kakroo" and click "Run."
Cell A1 displays the text "How easy it is to record a macro in Excel!", formatted according to your sample. If you need to text created in any selected cursor to the cell before recording, click on "Relative links" in the menu "Macros".
To edit or delete a macro, select it and click on "Change or Remove". To change the macro code editor will open (it also can be called Alt + F11). To edit a macro, you need to know the programming language Visual Basic for Applications (VBA).
If you choose to save the macro in the current workbook, you will need to save it in the format .xlsm (Excel workbook with macro support).
If you want to use the macros and study them in detail, you will be more convenient to work with the developer dashboard. It can be plugged into the Excel options tab of the "Customize ribbon".