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 Thu 20 Sep 2007, 09:56Delegate Bevan said...

Bevan has attended:
Excel Intermediate course
Excel Advanced course

Macros

How do I setup a macro

For upcoming training course dates see: Pricing & availability

Reply Mon 1 Oct 2007, 14:08Trainer Carlos said...

RE: macros

Dear Bevan

Thanks for the question.

To record a macro:-

1) Click Tools -> Macro -> Record a New Macro

Call it a relevant name and in this dialog box save the Macro in your Personal Macro Workbook if you want to use it in a different workbook.

You can also assign a keyboard shortcut to it.

2) Click OK.

3) Then go through the steps/ actions you need to record

4) Finish recording.

5) You have recorded a macro to do your required procedure and you can allocate that task to a button if you wish.

Hope this helps

Carlos

Excel articles

· Prepare for your MOS Certification with MS Excel Courses
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· How To Create A Data Table In Excel 2010
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· How To Sort A List Of Vehicle Number Plates In Year Order In Excel 2010

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips