USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Developer
|
|
|
Insert
|
|
|
Edit
|
|
|
Page Layout
|
Detailed explanation-1: -Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it. For more information, see Show the Developer tab. In the Code group on the Developer tab, click Record Macro.
Detailed explanation-2: -On the Developer tab, in the Code group, click Record Macro.
Detailed explanation-3: -Once you click on the “Record Macro” option under the Developer tab, Excel will automatically start recording the user’s actions in the program. Clicking the “Record Macro” again will stop recording the macro, and save it for later use.
Detailed explanation-4: -To see the macro you created: Go to Developer > Visual Basic to launch the Visual Basic Editor (VBE), which is where your macros are stored. You can find your Personal Macro workbook in the Project Explorer pane on the left hand side. If you don’t see it, go to View > Project Explorer.