April 2, 2008

10+ keyboard shortcuts for speeding your work with Excel data

Date: October 5th, 2007

Author: Jody Gilbert

Shortcuts can save you a considerable amount of time when you’re entering or modifying data in a worksheet — but only if you can remember them. This list offers ingredients in viagra a quick reminder of some old standbys, along with a few shortcuts that are less well known but equally useful.

A comprehensive list of Excel shortcuts is available as a PDF download.

Action Shortcut
Complete an entry and move to the next cell Enter
Insert a new line within a cell Alt+Enter
Enable editing within a cell F2
Fill selected cells with an entry you typed in one cell Ctrl+Enter
Cancel an entry Esc
Fill data down through selected cells Ctrl+D
Fill data through selected cells to the right Ctrl+R
Create a name Ctrl+F3
Insert a hyperlink Ctrl+K
Insert the current date Ctrl and ; (semicolon)
Insert the current time Ctrl and : (colon)
Delete from the insertion point to the end of the line Ctrl+Delete
Add blank cells Ctrl and Shift+ (plus)
Delete selected cells Ctrl and – (hyphen)
Create a chart from a range of data F11

Permalink • Print • Comment

December 21, 2007

Mouse – snap to and change pointer icon

Q:
I feel like I use my mouse too often and I was just wondering if there was an easy way I could cut back. Do you have any suggestions? Thanks for all your help!

A:

Well, it's possible and here's how! You just have to enable the "snap to" feature for your mouse. Go to Start, Control Panel and click on the Printers and Other Hardware (on some XP systems, there is a Mouse selection) link. Choose the Mouse link and then click on the Pointer Options tab. The second choice there is Snap To. Checkmark that box and click OK.

cialis tabs align=”justify”>To change your pointer icon, select the  Pointers tab and use the drop down menu to view the selections.  The additional displays are shown in the box below.

So, from now on, your mouse pointer will automatically move to the default button in any dialogue box. Every time you're doing something on your computer, the mouse pointer will take care of the finishing touches for you and you won't have to worry about moving your hand back over to your mouse. This feature also helps to eliminate wrist injuries, such as carpal tunnel, because you don't have to use your mouse quite so much. And let's be honest, who can argue with that?!

Permalink • Print • Comment

December 19, 2007

The Ultimate Word Keyboard Shortcut List

Quite often, I receive e-mails requesting complete lists for keyboard shortcuts.

Unfortunately, I never really have one. Most of the lists I put in the newsletter are ones I compile from a variety of references.

And, to be quite honest, I wasn't too worried about a "whole" list, because most people I've worked with have difficulty learning that much material all at one time.

But, I've stumbled upon a way to get MS Word to make a full list, so for those of you who really want the "complete" list of keyboard shortcuts, this one is for you!

In all versions of Word, you'll need to begin with an open blank document.

For those of you with older versions of Word, you need to go to the Tools menu, Macro submenu, Macro choice (or Alt + F8).

If you're running Word 2007, you need to click the Macro button on the Developer ribbon. (If you don't see the Developer ribbon, go to the Office button, Word Options button and in the Popular section, check the "Show Developer tab in the Ribbon" and click OK).

No matter which version you're running, we're all looking to choose Word commands under the "Macros in:" field in the Macros dialogue box.

From the list that appears in the Macro name: field, you need to select ListCommands.

Next, cialis sale click Run.

When the List Commands window opens, choose either "Current menu or keyboard settings" or "All Word commands." (I've made both of these lists. The "All Word commands" choice produced a much longer list that contained all the commands, even if there wasn't a keyboard shortcut to list. A good portion of the 42 pages had no shortcuts for me to use. As a result, I whole heartedly recommend you choose the first option).

When you've made your choice, click OK.

You will be returned to your document and Word will create a table of your shortcuts.

The first column is the command name.

The second column (titled "Modifiers") is the combination of Alt, Ctrl and Shift that you will need to use with the key listed in the third column.

The last column is the menu where the command can be located in Word.

That's it!

You can save and/or print the document as a reference tool.

One last thought: for those of you who may be overwhelmed by such a long list, never fear. I'm positive you'll still find smaller, more manageable lists included in this newsletter from time to time!

Permalink • Print • Comment

December 17, 2007

List of keyboard shortcuts for Word 2002 and for Word 2003

View products that this article applies to.

 

This article was previously published under Q290938

For a Microsoft Word 2000 version of this article, see

211982

.

For a Microsoft Word 97 version of this article, see

157935

.

SUMMARY

The following is a list of keyboard shortcuts that are available in Microsoft Word 2002 and in Microsoft Office Word 2003. This list is a compilation of the individual keyboard shortcut lists available in Word 2002 Help and in Word 2003 Help.

 

NOTE: Shortcut keys mentioned in the Help topics, menus, and dialog boxes refer to the U.S. keyboard layout. Keys on other layouts may not correspond exactly to the keys on a U.S. keyboard. If you are using a different language keyboard layout from the version of Word you are using, you may have to make adjustments when using shortcut keys.

 

MORE INFORMATION

Command Name Shortcut Keys
———————————-
All Caps CTRL+SHIFT+A
Annotation ALT+CTRL+M
App Maximize ALT+F10
App Restore ALT+F5
Apply Heading1 ALT+CTRL+1
Apply Heading2 ALT+CTRL+2
Apply Heading3 ALT+CTRL+3
Apply List Bullet CTRL+SHIFT+L
Auto Format ALT+CTRL+K
Auto Text F3 or ALT+CTRL+V
Bold CTRL+B or CTRL+SHIFT+B
Bookmark CTRL+SHIFT+F5
Browse Next CTRL+PAGE DOWN
Browse Previous CTRL+PAGE UP
Browse Sel ALT+CTRL+HOME
Cancel ESC
Center Para CTRL+E
Change Case SHIFT+F3
Char Left LEFT
Char Left Extend SHIFT+LEFT
Char Right RIGHT
Char Right Extend SHIFT+RIGHT
Clear DELETE
Close or Exit ALT+F4
Close Pane ALT+SHIFT+C
Column Break CTRL+SHIFT+ENTER
Column Select CTRL+SHIFT+F8
Copy CTRL+C or CTRL+INSERT
Copy Format CTRL+SHIFT+C
Copy Text SHIFT+F2
Create Auto Text ALT+F3
Customize Add Menu ALT+CTRL+=
Customize Keyboard ALT+CTRL+NUM +
Customize Remove Menu ALT+CTRL+-
Cut CTRL+X or SHIFT+DELETE
Date Field ALT+SHIFT+D
Delete Back Word CTRL+BACKSPACE
Delete Word CTRL+DELETE
Dictionary ALT+SHIFT+F7
Do Field Click ALT+SHIFT+F9
Doc Close CTRL+W or CTRL+F4
Doc Maximize CTRL+F10
Doc Move CTRL+F7
Doc Restore CTRL+F5
Doc Size CTRL+F8
Doc Split ALT+CTRL+S
Double Underline CTRL+SHIFT+D
End of Column ALT+PAGE DOWN
End of Column ALT+SHIFT+PAGE DOWN
End of Doc Extend CTRL+SHIFT+END
End of Document CTRL+END
End of Line END
End of Line Extend SHIFT+END
End of Row ALT+END
End of Row ALT+SHIFT+END
End of Window ALT+CTRL+PAGE DOWN
End of Window Extend ALT+CTRL+SHIFT+PAGE DOWN
Endnote Now ALT+CTRL+D
Extend Selection F8
Field Chars CTRL+F9
Field Codes ALT+F9
Find CTRL+F
Font CTRL+D or CTRL+SHIFT+F
Font Size Select CTRL+SHIFT+P
Footnote Now ALT+CTRL+F
Go Back SHIFT+F5 or ALT+CTRL+Z
Go To CTRL+G or F5
Grow Font CTRL+SHIFT+.
Grow Font One Point CTRL+]
Hanging Indent CTRL+T
Header Footer Link ALT+SHIFT+R
Help F1
Hidden CTRL+SHIFT+H
Hyperlink CTRL+K
Indent CTRL+M
Italic CTRL+I or CTRL+SHIFT+I
Justify Para CTRL+J
Left Para CTRL+L
Line Down DOWN
Line Down Extend SHIFT+DOWN
Line Up UP
Line Up Extend SHIFT+UP
List Num Field ALT+CTRL+L
Lock Fields CTRL+3 or CTRL+F11
Macro ALT+F8
Mail Merge Check ALT+SHIFT+K
Mail Merge Edit Data Source ALT+SHIFT+E Mail Merge to Doc ALT+SHIFT+N
Mail Merge to Printer ALT+SHIFT+M
Mark Citation ALT+SHIFT+I
Mark Index Entry ALT+SHIFT+X
Mark Table of Contents Entry ALT+SHIFT+O
Menu Mode F10
Merge Field ALT+SHIFT+F
Microsoft Script Editor ALT+SHIFT+F11
Microsoft System Info ALT+CTRL+F1
Move Text F2
New CTRL+N
Next Cell TAB
Next Field F11 or ALT+F1
Next Misspelling ALT+F7
Next Object ALT+DOWN
Next Window CTRL+F6 or ALT+F6
Normal ALT+CTRL+N
Normal Style CTRL+SHIFT+N or ALT+SHIFT+CLEAR (NUM 5)
Open CTRL+O or CTRL+F12 or ALT+CTRL+F2
Open or Close Up Para CTRL+0
Other Pane F6 or SHIFT+F6
Outline ALT+CTRL+O
Outline Collapse ALT+SHIFT+- or ALT+SHIFT+NUM –
Outline Demote ALT+SHIFT+RIGHT
Outline Expand ALT+SHIFT+=
Outline Expand ALT+SHIFT+NUM +
Outline Move Down ALT+SHIFT+DOWN
Outline Move Up ALT+SHIFT+UP
Outline Promote ALT+SHIFT+LEFT
Outline Show First Line ALT+SHIFT+L
Overtype INSERT
Page ALT+CTRL+P
Page Break CTRL+ENTER
Page Down PAGE DOWN
Page Down Extend SHIFT+PAGE DOWN
Page Field ALT+SHIFT+P
Page Up PAGE UP
Page Up Extend SHIFT+PAGE UP
Para Down CTRL+DOWN
Para Down Extend CTRL+SHIFT+DOWN
Para Up CTRL+UP
Para Up Extend CTRL+SHIFT+UP
Paste CTRL+V or SHIFT+INSERT
Paste Format CTRL+SHIFT+V
Prev Cell SHIFT+TAB
Prev Field SHIFT+F11 or ALT+SHIFT+F1
Prev Object ALT+UP
Prev Window CTRL+SHIFT+F6 or ALT+SHIFT+F6
Print CTRL+P or CTRL+SHIFT+F12
Print Preview CTRL+F2 or ALT+CTRL+I
Proofing F7
Redo ALT+SHIFT+BACKSPACE
Redo or Repeat CTRL+Y or F4 or ALT+ENTER
Repeat cialis professional online Find SHIFT+F4 or ALT+CTRL+Y
Replace CTRL+H
Reset Char CTRL+SPACE or CTRL+SHIFT+Z
Reset Para CTRL+Q
Revision Marks Toggle CTRL+SHIFT+E
Right Para CTRL+R
Save CTRL+S or SHIFT+F12 or ALT+SHIFT+F2
Save As F12
Select All CTRL+A or CTRL+CLEAR (NUM 5) or CTRL+NUM 5
Select Table ALT+CLEAR (NUM 5)
Show All CTRL+SHIFT+8
Show All Headings ALT+SHIFT+A
Show Heading1 ALT+SHIFT+1
Show Heading2 ALT+SHIFT+2
Show Heading3 ALT+SHIFT+3
Show Heading4 ALT+SHIFT+4
Show Heading5 ALT+SHIFT+5
Show Heading6 ALT+SHIFT+6
Show Heading7 ALT+SHIFT+7
Show Heading8 ALT+SHIFT+8
Show Heading9 ALT+SHIFT+9
Shrink Font CTRL+SHIFT+,
Shrink Font One Point CTRL+[
Small Caps CTRL+SHIFT+K
Space Para1 CTRL+1
Space Para15 CTRL+5
Space Para2 CTRL+2
Spike CTRL+SHIFT+F3 or CTRL+F3
Start of Column ALT+PAGE UP
Start of Column ALT+SHIFT+PAGE UP
Start of Doc Extend CTRL+SHIFT+HOME
Start of Document CTRL+HOME
Start of Line HOME
Start of Line Extend SHIFT+HOME
Start of Row ALT+HOME
Start of Row ALT+SHIFT+HOME
Start of Window ALT+CTRL+PAGE UP
Start of Window Extend ALT+CTRL+SHIFT+PAGE UP
Style CTRL+SHIFT+S
Subscript CTRL+=
Superscript CTRL+SHIFT+=
Symbol Font CTRL+SHIFT+Q
Thesaurus SHIFT+F7
Time Field ALT+SHIFT+T
Toggle Field Display SHIFT+F9
Toggle Master Subdocs CTRL+\ Tool SHIFT+F1
Un Hang CTRL+SHIFT+T
Un Indent CTRL+SHIFT+M
Underline CTRL+U or CTRL+SHIFT+U
Undo CTRL+Z or ALT+BACKSPACE
Unlink Fields CTRL+6 or CTRL+SHIFT+F9
Unlock Fields CTRL+4 or CTRL+SHIFT+F11
Update Auto Format ALT+CTRL+U
Update Fields F9 or ALT+SHIFT+U
Update Source CTRL+SHIFT+F7
VBCode ALT+F11
Web Go Back ALT+LEFT
Web Go Forward ALT+RIGHT
Word Left CTRL+LEFT
Word Left Extend CTRL+SHIFT+LEFT
Word Right CTRL+RIGHT
Word Right Extend CTRL+SHIFT+RIGHT
Word Underline CTRL+SHIFT+W

 

Pasted from <http://support.microsoft.com/default.aspx?scid=kb;en-us;290938>

 

Permalink • Print • Comment

December 3, 2007

Outlook Keyboard Shortcuts

Time for a Fast Forward

Love your keyboard and hate your mouse?

Do you find that the old routine of mouse, keyboard, mouse, keyboard simply takes up too much of your precious time when you're going through your e-mail?

Looking for a few MS Outlook keyboard shortcuts to make your e-mail time more productive?

If you answered, "Yes, yes, yes," here's exactly what you've been looking for:

  • Ctrl + Shift + I will take you straight to the Inbox.

  • Ctrl + Shift + O will put you into the Outbox.

    cialis order

Once you're in a mailbox:

  • Enter (while a message is highlighted) will open the message.

  • Ctrl + N will open a new e-mail message.

  • Ctrl + R will reply to the current message (either highlighted or already opened).

  • Ctrl + F will forward the current message (either highlighted or already opened).

Once you're in a message:

  • Tab will advance you one field forward (from the To: field to the Cc: field, etc).

  • Shift + Tab will send you one field backwards.

And finally (at least for this tip):

  • Ctrl + Enter will send your e-mail message.

It seems to me this may put you well on your way to a more efficient, mouseless e-mailing process!

Permalink • Print • Comment
« Previous PageNext Page »
Made with WordPress and an easy to customize WordPress theme • Sky Gold skin by Denis de Bernardy