98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Macros
Resolved · Low Priority · Version 2003
Elsabeth has attended:
PowerPoint Intermediate Advanced course
Macros
can you create macros / short cuts for formatting e.g?
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Generating simple column charts1.Select cell range containing data/figures |