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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

ResolvedVersion 2007

Fri 9 Jan 2009, 15:53 Delegate Konstantina said...

Konstantina has attended:
Excel Advanced course

Macros

how do you undo a macro command?

Fri 9 Jan 2009, 16:32 Trainer Susan said...

RE: macros

Once you have run a macro command, the undo facility is no longer enabled. The reason for this is because you have carried out a set of commands, ie a Macro, as opposed to a single command or action.

Therefore once you have carried out a macro command you are unable to undo the actions automatically. If you can remember the various steps of the macro you will be able to manually undo by undertaking each step separately.

Fri 16 Jan 2009: Automatically marked as resolved.

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Macros

Macros

RE: macros

Excel articles

Excel tip:

Highlighting a data range