microsoft.excel.courses.in.london - macro

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.courses.in.london - Macro

microsoft.excel.courses.in.london - Macro

resolvedResolved · Low Priority · Version Standard

Junaid has attended:
Excel Advanced course

Macro

What is Macro?

RE: Macro

Hi Junaid

Thank you for your question.

A macro is a sequence of recorded steps that can be carried out automatically, rather than you performing the steps manually.

To record a macro, go to Tools - Macro - Record new macro, then give your macro a name (without any spaces as part of the name) and click OK.

Then carry out the series of steps you want the macro to do for you, and click the Stop Recording button on the small toolbar that is showing on your screen; or go to Tools - Macross - Stop recording.

To play the macro, go to Tools - Macro - Macros, select the macro and click Run.

Amanda


 

Excel tip:

Shortcut for accessing recently opened files

To get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu.

Recently opened files are listed down the bottom of the File menu - type in the number next to the file you wish to open and it should appear on your screen.

View all Excel hints and tips


Server loaded in 0.09 secs.