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

ms excel courses - macro

Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel courses - Macro

ms excel courses - Macro

ResolvedVersion Standard

Sonia has attended:
Excel Intermediate course

Macro

How do you record and run a Macro?

RE: Macro

Select Tools, Macro and then Record New Macro and give your macro a name in the first field of the dialog box which appears. Once you click OK, your every action is being recorded as as macro. Once you've carried out the task, click the stop (square) button on the floating macro toolbar and the macro will stop recording. To run your macro again, select Tools, Macro and then Macros, select the name of your macro and hit run.

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.