macros

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

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

Macros

resolvedResolved · Low Priority · Version Standard

Amanda has attended:
Excel Intermediate course
Excel Advanced course

Macros

How do you set up macros for data reports I put together frequently?

RE: Macros

Hello Amanda,
I hope you enjoyed your Excel training session with us.

In response to your question, you can create macros to make a lot of the mundane Excel tasks run very quickly, depending on what you are looking to do.

When you want to record a macro, I first suggest running through the steps on a dry-run, to make sure you know exactly what you need to record in your macro. Then when you're ready, go to Tools > Macro > Record new macro. You will be asked to name the macro, and give it a keyboard shortcut if you would like. Then once you click OK, you will be in recording mode. Everything you do from here will be recorded as part of the macro, until you click the stop recording button. If you have specific requirements for your reports that I can help with, I'd be glad to go over those with you.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips


Server loaded in 0.09 secs.