How to Write a Simple Macro in Microsoft Excel

Method 1 of 2: Excel 2007 and 2010

1. 1
   Click the Developer tab on the Ribbon at the top of the screen. If the tab is not showing up on your screen, you can add it as follows:
   • For Excel 2010: click the File Tab then select options. On the left hand side of the Excel options dialog box, click Customize Ribbon. Then, on the right hand side box select Developer.
     
   • For Excel 2007: click the Microsoft Office button, then Excel Options. In the Popular category, under Top Options for Working with Excel, select Show Developer Tab in Ribbon.
     
   Ad
2. 
   2
   Change the security settings. In Trust Centre, Under Macro Settings, click Enable All Macros, then click OK.
   • Note that this security setting is not ideal for basic use. When you've finished creating your macro, go back and un-click Enable All Macros.
3. 
   3
   Click Record Macro. You'll find it on the Developer tab under Code.
4. 
   4
   Name your macro. The first character of the name must be a letter; after that, you can use characters, numbers and underscores. Macro names cannot have spaces.
   • Don't use the same name for your macro as an existing cell reference.
5. 
   5
   Set a shortcut for your macro (optional). Type a letter in the Shortcut Key box. A lowercase letter will translate to CTRL + letter; an uppercase letter will be CTRL + SHIFT + letter.
6. 
   6
   Choose where to store your macro. In the Store Macro In list, select the workbook where you want to store the macro. If you want it to be available whenever you run Excel, select Personal Macro Workbook.
7. 
   7
   Describe your macro. Write this in the Description box.
8. 
   8
   Click OK to start recording your macro.
9. 
   9
   Perform the actions you want the macro to record.
10. 
    10
    Stop recording. Go to the Developer tab, click Code, then click Stop Recording.

Method 2 of 2: Excel 2003

1. 1
   Change the security level. Switch the security level from Medium to Low.
   • Click Tools -> Options -> Security.
     
   • Click Macro Security.
     
   • Select Security Level. Select Low.
     
2. 
   2
   Start recording your macro. Navigate to Tools -> Macro -> Record New Macro.
3. 
   3
   Name your macro. The character of the name must be a letter; after that, you can use symbols, numbers or underscores. No spaces are allowed.
   • Don't use the same name for your macro as an existing cell reference.
4. 
   4
   Code a shortcut for your macro (optional). Enter a letter in the Shortcut Key box. A lowercase letter will make the shortcut CTRL + letter; uppercase will be CTRL + SHIFT + letter.
5. 
   5
   Choose where to store your macro. In the Store Macro box, select a location for your macro. Click Personal Macro Workbook if you want it to be available whenever you open Excel.
6. 
   6
   Write a description of your macro.
   • When you're done, click OK.
     
7. 
   7
   Record your macro. Remember, Record Macro is still on. Carry out the actions that you want Excel to record as your macro.
8. 
   8
   Click Stop Recording. You can find this option on the Stop Recording toolbar.

oracle hyperion training in hyderabad

 Chresemo Technologies
H.No: 7-1-619/A, Shanti Nilaya, 3rd floor,
Behind HUDA maitrivanam, Gayatri nagar,
Ameerpet, Hyderabad-500038.

Company Number:

040-64104057
040-64104058

======================================

MindMajix Technologies

#506, 5th Floor
HUDA Maitrivanam
Ameerpet, Hyderabad - 500038
Andhra Pradesh, INDIA.
Phone no : +91 - 924 633 3245

seo institutes in hyderabad

Class Notes

• Rank #1 for Online SEO Training
  23/November/2013 ~ Comments Off
• Jobs For SEO Students of Sanjay Technolgies
  27/May/2013 ~ Comments Off
• Protected: SEO Class Notes for Sanjay Technologies Students
  24/November/2011 ~ Enter your password to view comments.

Read More

Contact Info

Sanjay Technologies 
Flat No. C1, 4th Floor, KVR Enclave,
Above ICICI Bank, Between Satyam Theatre and Gurudwara, Ameerpet,
Hyderabad-500016, Andhra Pradesh, India
Phone : 090595 18777, 086864 33311,
086863 44477, 086862 33311

Email: sanjay@seosanjay.com

Location

Call Now: 090595-18777, 086863-44477, 086864-33311




best search engine optimization(seo) Training institute In Hyderabad training by google certified trainer Mr. P Sai Ramesh 
seo class in telugu seo class in english seo classes in hindi we are also providing seo free training and also online seo training.for more details contact : 9533938444

Gmail Shortcuts

1. Control Main Browser Window
tab, then enter	When logging in to Gmail: Start typing user name followed by tab, type password then pressenter. Some browsers may require two tabs, then enter after typing the password.
alt+left arrow / alt+right arrow	One page back / one page forward
end / home	Jump to beginning of page / end of page.
page up / page down	Jump one page up / one page down.
alt+d, then multiple tab's	Move the focus of the browser to the main window. Jumps to the address bar first, then through toolbars until landing at the main window.
tab / shift+tab	Jump forward / jump backwards between input fields.
ctrl+r	Refresh page. Sometimes GMail seems to get stuck on certain pages won't allow shortcuts. Things tend to work fine after a page refresh.

▲ up

2. Navigate Main Gmail Window
g, then i	Go to inbox.
g, then s	Go to starred conversations.
g, then t	Go to sent mail.
g, then d	Go to drafts.
g, then a	Go to all mail.
g, then c	Go to contacts.
g, then l	Go to label. Use arrow keys from here.
c	Compose a new message.
escape	Reset state. Often necessary before using a Keyboard Shortcut to move out of the current task or field.
z	Undo previous action.

▲ up

3. Manage Message List
Some of these Shortcuts work for both Message List and Single Message view but may have different effects.
j / k	Move to next (older) / move to previous (newer) e-mail or conversation.
x	Select or unselect current conversation.
*, then a / *, then n	Select all conversations / Un select all conversations.
*, then r / *, then u	Select all read conversations / Select all unread conversations.
*, then s / *, then t	Select all starred conversations / Select all unstarred conversations.
shift+u / shift+i	Mark selected messages as unread / Mark selected messages as read.
o or enter	Open message.
#	Delete selected message.
v	Mov selected message. Use arrow keys and enter to proceed.
l	Add label to message, opens label menu. Use arrow keys and enter to proceed.
e	Archive selected messages.
!	Mark selected messages as spam.
m	Mute selected message. Archives the conversation and all future messages.
s	Star or unstar message.
y	Remove from current view: To archive while in Inbox, to Inbox while in Trash, remove star while in Starred Conversation, remove Label while in Labels.

▲ up

4. Manage Single Messages
Some of these Shortcuts work for both Message List and Single Message view but may have different effects.
j / k	Move to next (older) / move to previous (newer) e-mail or conversation.
n / p	Move to next part / previous part of conversation in message.
r	Reply to sender.
shift+r	Reply to sender in new window.
a	Reply to all.
shift+a	Reply to all in new window.
f	Forward message.
shift+f	Forward message in new window.
ctrl+s	Save Message. Cursor should be in field.
ctrl+[ / ctrl+]	Remove from current view and move to older / move to newer message (won't delete message, just changes view).
ctrl+{ / ctrl+}	Archive and move to older message / move to newer message.
u	Return to inbox or conversation list.
#	Delete selected message and jump back to the message list.
v	Move selected message.
l	Add label to message, opens label menu and jump back to the message list.
e or [	Archive selected messages and jump back to the message list.
!	Mark selected messages as spam and jump back to the message list.
m	Mute selected message and jump back to the message list.
s	Star or unstar message.
y	Remove from current view and jump back to the message list.

▲ up

5. Tasks in Gmail
Shortcuts for Gmail Tasks seem to be a bit buggy. shift+t adds message to the task list, but the focus never makes it to the task window. There seems to be no way to re-gain focus after. Page refresh with f5 and g, then k does the trick but is not pretty.
g, then k	Go to task window or opens task window (see limitations above)
shift+t	Add message(s) to tasks.
arrow keys	Move cursor up and down in task list.
ctrl+up / ctrl+down	Move current task up and down in task list.
tab / shift+tab	Increase / Decrease Indent
a...z or others	Edit Task
shift+enter	Edit task details, including due date or notes.
shift+esc	Shift the cursor from tasks to Gmail, but only one-way.
esc	Closes Task Window if focus is on it (see limitations above).

▲ up

6. The Rest
?	Displays the keyboard shortcuts help menu.
q	Move cursor to chat search.
/	Move to Search Mail field.
shift+n	Update conversation with new messages if there are any.