![how to extend underline in excel how to extend underline in excel](https://images-na.ssl-images-amazon.com/images/I/51S0uUTHaYL.jpg)
The visual basic editor can be accessed using he shortcut key Alt+F11, by using the visual basic editor button in the visual basic toolbar or by choosing the visual basic editor option from the menu as shown below. Having done that, you can now use the “Developer” tab to access the VBA Editor by pressing the “Visual Basic” button.Įditing a macro in Excel 2003 and earlier versions Click on the “Excel Options” button and then turn on “Show developer tab in the Ribbon” checkbox the under the “Popular” menu option. You can turn on the “Developer” tab by clicking on the Office button located at the top left corner of the Excel workbook. You can use the shortcut key Alt+F11 to open up the IDE or simply use the following menu options. To view the code, we will need to open the VBA Editor (also referred to as the VBA IDE or VBA Integrated Development Environment).
How to extend underline in excel code#
The code generated by the application is in a language called VBA (Visual Basic for Applications). The logical next step is to check out the code that was generated by the macro. You can record a complete set of macros and then run them one after another to get a the steps related to a task accomplished at one go.Ĭongratulations! You have now written your first macro. Alternatively you can press Alt+F8 as the shortcut key. You can view the macro you just recorded by clicking on “Tools” option in the menubar and then clicking on “Macro” and then choosing the “Macros” option. Once you are done, you can click the “Stop Recording” option under “Macro” from the menu. Click ok on the pop-up box that appears and then carry out the steps that you wish the record in the macro. In Excel 2003 and earlier versions, you can record a macro by clicking on “Tools” option in the menubar and then clicking on “Macro” and then choosing the “Record New Macro” option.
How to extend underline in excel how to#
How to record a macro in Excel 2003 (& earlier) You can give a descriptive name to the macro or assign a shortcut key so that by pressing that key combination, the macro will begin execution. You can now view the macro that you just recorded by clicking the “View Macros” option under the “Macros” button. Once you are done you can stop recording the macro by clicking the “Stop Recording” option under the “Macro” button.Īlternatively, you can begin and stop recording a macro in Excel 2010 (and 2007) by clicking on the icon located at the bottom-left of the application window, right next to where it is labelled ‘Ready’. After this you can carry out the steps that you want like entering numbers, formulas, formatting cells, inserting charts etc etc. If you are just starting to record your own macro, you can simply click on the “ok” button. A pop-up box will ask you to enter the details of the macro. Click on the “Macros” button towards at the right end of the ribbon and then click “Record Macro”. In Excel 2007 (and Excel 2010), the “Record Marco” menu option is under the “View” ribbon. Recording a macro in Excel How to record a macro in Excel 2007 and Excel 2010 How to write a macro in Excel? Here are a few quick tips: