Question

Explain the steps to create Macros in spread sheet in detail . fast plz​

Answer 1

Answer:

Write a macro from scratch in Visual Basic

1. On the Developer tab, in the Code group, click Macros.
2. In the Macro name box, type a name for the macro. ...
3. In the Macros in list, click the template or document in which you want to store the macro. ...
4. Click Create to open the Visual Basic Editor.

Hope it helps you...

Answer 2

Answer:

Spreadsheets are infinitely flexible—especially in Excel, one of the most powerful spreadsheet apps. Most people use only a small percentage of their seemingly countless possibilities, however. Yet it doesn't take years of training to take advantage of spreadsheets' power and the automation magic of Excel macros.

You likely already use functions like =sum(A1:A5), the simple bits of text that add, average, and calculate your values. They're what make spreadsheets a powerful tool for crunching numbers and text. Macros are the next step: They're tools that automate simple tasks and help you get more done in less time. Here's how to unlock that new part of your Excel skill set by building your own macros in Excel.

Explanation:

Hope it helps you...