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 · Medium Priority · Version 2007

Susannah has attended:
Excel Intermediate course

Macros

How do you create macros?

RE: Macros

Hi Susannah, thanks for your query. In Excel 2007 you need the Developer tab visible on the ribbon to record a macro. You can get to activating tick box using the options button on the Office drop down menu - it's the third tick box down on the first screen that appears.

Then, you simply create a macro by clicking on "Record Macro" on the developer tab. After that, all your actions in Excel will be recorded and translated into a repeatable macro. Remember to press "Stop recording" when you're done!

Hope this helps,

Anthony

Mon 10 Jan 2011: Automatically marked as resolved.


 

Excel tip:

Deleting cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + -.

View all Excel hints and tips


Server loaded in 0.09 secs.