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

microsoft+excel+training - what macro

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training - What is a Macro?

microsoft+excel+training - What is a Macro?

ResolvedVersion Standard

What is a Macro?

I have heard the mention of Macros and it is a term I have heard used, but what exactly is a Macro?

RE: What is a Macro?

I meant it is a term I have heard on here as well as at my place of work. The question above looks like I have repeated myself!!

RE: What is a Macro?

a macro is a sequence of steps / commands that can be stored and then recalled with a single click or keyboard stroke.

For example, in Excel you may want to create a button that when pressed, will change the margins of a page, add gridlines, and change the Font to bold. By using a Macro you could record this action, and any time you press the button, it would repeat those steps to your active worksheet

RE: What is a Macro?

Does Macro do more than just storing certain commands? How is it different from VBA?

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

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