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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
macros

ResolvedVersion Standard

Laura has attended:
Excel Intermediate course
Excel Advanced course

Macros

how do you record a macro

RE: macros

Hi Laura

To record a macro do the following:

1. Open the Tools menu, select Macro and then click Record New Macro.

2. In the Record Macro dialog box, type a name for the macro in the Macro name box.

NB Macro names must start with a letter and can include letters, numbers, and underscore characters, but can't include spaces. You don't need to change the other boxes.

3. When you click OK, the Stop Recording toolbar appears, and you're ready to record. Until you stop the recording, every Excel command and keystroke will be recorded in the macro, in the order in which they are entered.

4. To finish recording the macro, click the Stop Recording button.

Hope this helps

Carlos

Excel tip:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

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.1 secs.