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 Office general help » Excel

Excel

ResolvedVersion 2007

Wed 2 Sep 2009, 16:48 Delegate Julia said...

Julia has attended:
Upgrade to Office 2007 course

Excel

How do I record a new macro

Fri 4 Sep 2009, 16:20 Trainer Amanda said...

RE: Excel

Hello Julia

Thank you for your question and welcome to the forum.

To record a macro in Excel 2007, you need to be able to see the Developer ribbon at the top of your screen.

If it isn't visible, then go to the Office button, select Excel options then go to Popular and tick Show the Developer tab in the ribbon'.

Then on the Developer ribbon, click the Record Macro button.

Give your macro a name (without any spaces in it) then click OK to start recording. When you have finished carrying out the steps that the macro should take, go to the Developer ribbon and click Stop Recording.

Kind regards
Amanda

Fri 11 Sep 2009: Automatically marked as resolved.

Microsoft Office tip:

Standard Ctrl Keys

Here are some standard Ctrl keys you can use in all your Office applications.
A - Select All
B - Bold Text
C - Copy
F - Find
G - GoTo
H - Replace
I - Italics
K - Insert Hyperlinks
N - New File
O - Open File
P - Print
S - Save
U - Underline
V - Paste
W - Save and Close
X - Cut
Y - Redo
Z - Undo

Other vary between applications. See additional lists.

View all Microsoft Office hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excel

Excel

RE: Excel

Microsoft Office articles

Microsoft Office tip:

Standard Ctrl Keys