Quick Links ▼

Bookmark page

Printable version

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

microsoft excel courses - Macros

Resolved · Low Priority · Version Standard

Reply Fri 21 Sep 2007, 16:23Delegate Helen said...

Helen has attended:
Excel Advanced course

Macros

what are the practical uses of macros?

For upcoming training course dates see: Pricing & availability

Reply Sat 22 Sep 2007, 21:35Delegate Paul said...

RE: macros

Macros are best used when attached to buttons in order to carry out a task that is done in the same way very often.

For instance, if you have a list of data and every day you enter more data to the bottom of the list and then sort the list by name, you can create a macro to sort the data for you by clicking one button.

Excel articles

· Excel in the Home Office
· A Hidden Gem In Excel - Formula Auditing
· Tips To Help You Excel
· Create Contrasting Coloured Rows In Excel
· Using Excel In Any Condition

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips