SysChat is a free online computer support community. Ask questions, share resources, contribute knowledge and discuss technology. Join our growing community to access all features. Register Now!

SysChat » Tips 'n' Tricks » Microsoft Office » How to Create A Microsoft Excel Macro in 7 Steps

Microsoft Office

tips on microsoft office suite

Comment
 
LinkBack Tip Tools
 

How to Create A Microsoft Excel Macro in 7 Steps

By dwarkarao
12-03-2009
Macro is an absolutely amazing way to reduce the work when you repeat some set of steps every time.

People who use Excel surely understand the importance of macros. Macros are meant to reduce their work to a great extent.

Each month you setup the same Sums, Formulas, Text Formatting, Pivot Table, and maybe more.

This could be very time consuming if you completed these steps individually each month.

So, under such cases you can easily create macros and reduce this bulky work in few steps by using keyboard shortcuts.

Below are the steps to record a macro in Microsoft Excel:
  1. Think of the keys required to complete the tasks
  2. Now click on Tools>>Macros>>Record>>New Macro
  3. Now assign a NAME for the Macro
  4. And also assign a SHORTCUT KEY for the Macro
  5. And Click on OK button
  6. Perform the steps needed to create your report (the steps you complete each month, which includes formulas, text formatting, etc)
  7. Now click on the STOP button on the Macro Toolbar to stop recording and is will also save the Macro.
That is all, now you can test the created Macro.
Comment





Similar Threads
Tip Tip Starter Category Tips Last Post
Microsoft Office professional 2007 trial version linda General Software 8 02-23-2009 05:33 AM
Microsoft download I_Hate_My_Computer Networking 4 02-15-2008 02:59 AM
Exponents in Microsoft Excel jopes Microsoft Office 0 06-22-2007 12:08 PM
Microsoft Confirms Excel Zero-Day Attack Under Way Sami News 0 06-17-2006 01:15 AM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are on



» Ads



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54