How to Automate an Excel Spreadsheetby Stephanie Ellen
Microsoft Excel has macro functions which allow users to automate spreadsheets and avoid entering the same information over and over again. Whether formatting a document a particular way, entering a range of information, or producing the same chart types over and over, a macro can help you perform these tasks with the push of a button.
Open the spreadsheet where you would like the macro to run.
Click the "Developer" tab, then click "Record Macro." Type a name for the macro in the "Macro name" box, then click "OK." The macro recorder will start to record your keystrokes and mouse clicks.
Format the document. For example, design a budget document, make a bar graph, or enter information you'd like to enter in other spreadsheets.
Click the "Developer" tab, then click "Stop Macro Recording." Your macro is now ready for use.
Run the macro by clicking "Developer," then clicking "Macros." Click on the name for the macro you assigned in Step 2, then click "Run."
- If you have trouble running macros, you may need to change your security settings. Click the "Microsoft Office" button, then click "Access Options." Click "Trust Center," then click "Trust Center Settings." Click "Macro Settings," then click "Disable all macros except digitally signed macros." This will allow macros from trusted publishers, like Microsoft, to run.
Items you will need
- Excel 2007 or 2010
- keyboard image by Fyerne from Fotolia.com