Microsoft Excel, software that analyzes information that provides businesses with easy means of data exchange and helps make informed decisions, is one of the most asked KnowledgeCity software training tutorials by users. And out of the many online training tutorials asked on features in this program is the “Macro” function.
This built-in feature enables users to record repetitive actions for easy usage on different cells and worksheets. It’s fairly easy to utilize and useful for business professionals to save time filling out the same information on new spreadsheets.
To create a macro, here are few simple steps:
1. First, establish the workbook (file) for the spreadsheet that is going to be recorded under by clicking on the Tools tab on top of the toolbar. Find Macro then select Record New Macro.
2. When the dialogue box appears, fill in: the name of the file, letter to the shortcut key (optional) (pressing the Ctrl + the key letter will run the macro automatically on different spreadsheets), and where you want to store your workbook in (usually the workbook is the one in progress or can be saved under a personal macro workbook).
3. Write in the description for the macro made.
When finished, click the Ok button and a small macro recording box will appear to show recording is in session. After the box shows, everything that is done on the workbook is being recorded. Manually go through functions that macro needs to recreate (i.e. adding/deleting columns). To stop recording when finished, click on the blue button of the recording box and the workbook is ready to use.
This built-in feature enables users to record repetitive actions for easy usage on different cells and worksheets. It’s fairly easy to utilize and useful for business professionals to save time filling out the same information on new spreadsheets.
To create a macro, here are few simple steps:
1. First, establish the workbook (file) for the spreadsheet that is going to be recorded under by clicking on the Tools tab on top of the toolbar. Find Macro then select Record New Macro.
2. When the dialogue box appears, fill in: the name of the file, letter to the shortcut key (optional) (pressing the Ctrl + the key letter will run the macro automatically on different spreadsheets), and where you want to store your workbook in (usually the workbook is the one in progress or can be saved under a personal macro workbook).
3. Write in the description for the macro made.
When finished, click the Ok button and a small macro recording box will appear to show recording is in session. After the box shows, everything that is done on the workbook is being recorded. Manually go through functions that macro needs to recreate (i.e. adding/deleting columns). To stop recording when finished, click on the blue button of the recording box and the workbook is ready to use.
