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

macros

ResolvedVersion 2003

Elsabeth has attended:
PowerPoint Intermediate Advanced course

Macros

can you create macros / short cuts for formatting e.g?

Edited on Fri 27 Jun 2008, 10:37

Macro for formatting

Hi Elsbeth

If you have a certain format in mind then the best thing to do is record a macro that will include all those steps.

It is also important to be clear about the steps you are going to take once the macro starts to record because any mistakes you make while the macro is recording they will get recorded as well.

Select the area/range to be formatted before starting to record. This ensures that the recorded macro will work on any selected range.

To record the Macro:

1: Choose [b]Tools > Macro > Record New Macro

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

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