Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Macros

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

2002 excel microsoft training - Macros

Resolved · Low Priority · Version Standard

Reply Tue 18 Dec 2007, 16:23Delegate Alyssia said...

Alyssia has attended:
Excel Intermediate course

Macros

how would I program a macros

For upcoming training course dates see: Pricing & availability

Reply Tue 18 Dec 2007, 16:44Trainer Amanda said...

RE: macros

Hi Alyssia

Thank you for your question.

You can create a macro by going to Tools - Macro - Record new macro. Give your macro a name (without any spaces) and then click OK. Then you can start performing the steps you would want the macro to take for you when you run it. The code is all written for you while you are carrying out the steps.

When you have finished performing the steps the macro should take, then click the Stop Recording (blue square) button on the small toolbar that will have appeared on your screen.

Run the macro by going to Tools - Macro - Macros, selecting the macro and clicking Run.

Amanda

Excel articles

· Basic Excel Training
· Do You Need To Upgrade From Excel 2003 to Excel 2007?
· A Hidden Gem In Excel - Formula Auditing
· What You Need To Know About LOOKUP Functions In Excel 2007/2010
· What's Better Than the Help Function in Excel? Microsoft Training

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips