Learn
Microsoft Excel
changing paper size
searching a text
searching and replacing a text
using goto option
changing zoom
inserting date and time
creating a text box
inserting symbol
inserting graphics
inserting pictures
writing equations
inserting page number
inserting header and footer
deleting header and footer
creating password protection
deleting password protection
inserting word art
using format painter
spell check facility of MS Excel
using print area
naming a range
using range name in functions
transposing row and column
creating salary sheet automatically using data table
using VLOOKUP function
recording and running a macro
sorting a database
filtering a database
validating data in database
removing duplicates from database
Next Page>>>
Dictionary
Forum
Others Links
Forgot Password?
Chapter 56
recording and running a macro
To record and run a macro follow these instructions :
Click on TOOLS, point to MACRO and click on RECORD NEW MACRO.
Or click on the arrow sign of the Macros of the MACROS option from the View tab and select RECORD MACRO.
Type the name of the macro e.g., budget98.
Type shortcut key P.
Enter description what you want.
Click on OK.
Now start your task. Every step will be recorded in the macro. Once you have finished, click on the STOP RECORDING button.
Or click on the arrow sign of the Macros of the MACROS option from the View tab and select STOP RECORDING.
To execute the macro ?Click on TOOLS, point to MACRO and click on VIEW MACROS, select macro and click on OK? or ?click on the arrow sing of the Macros of the MACROS option from the View tab and select VIEW MACROS, select macro and click on OK? or press Ctrl+P, which is shortcut.
