December 18, 2007

Tip #2150 – Letter Case Mania

Letter Case Mania

Ever find that you're constantly trying to change the capitalization of words or sentences? What do you do?

Maybe you highlight the word or phrase and retype it.

Maybe you're the type who only replaces the individual letters that need to be changed. What a headache!

Are you the person who found the Change Case feature on the Format menu? You know, where you get the choices of sentence case, all lowercase letters, all uppercase letters, all title case letters or to toggle all letters between upper and lowercase.

What I have for you today are a few shortcuts for all of this change case stuff. It's something even faster than the Change Case choice on the Format menu.

Let's start with the most versatile choice.

Once you highlight the text to change, use Shift + F3. You'll scroll between sentence case letters, all lowercase letters and all uppercase letters.

That's good! Looks great, but what if you know you want all caps and don't cialis review feel like toggling through your choices?

Is there a quicker way?

Yep, you bet. (Isn't that why I brought it up in the first place)?

If you know you want your text all caps, simply try Ctrl + Shift + A.

And… if that weren't enough, there's another option altogether. You can use small caps. That is all the letters in capital letter formation, but slightly smaller than the usual capital letter.

Ctrl + Shift + K will put you straight to small caps, which is a good "attention getter" without completely shouting at the reader.

That's it! Three keys and you're on your way to the formatting you need.

Permalink • Print • Comment

Tip #1153 – MS Excel Text Into Columns

MS Excel Text Into Columns

Have you ever found yourself wondering what in the world possessed the person who created your MS Excel file to put both first and last name in the same cell?

Now how are you supposed to sort that list alphabetically by last name when first name is listed first?

The answer is that you can't—you have to separate the first and last names—somehow…

But how?

You could spend your time retyping the last name into the next column. It works but it's not a great plan since it could take "forever" if your list is really long.

Or… maybe you have other text / data that really should be separated into different cells for easy sorting and editing.

Would you like a fast way to separate the data? (This works best with data that's pretty consistent and not too complicated.)

Most of us would say "yes". (Even if you don't have an immediate use for this one, it's one of those handy little pieces of information that may just get you out of a jam one day. šŸ™‚

So let's get to that faster way…

The first thing you'll need to do is to highlight the data that needs to be separated.

Now go to the Data menu, Text into Columns choice.

A 3-step wizard will start to guide you through the process.

On step 1 check at the top that the data will be delimited.

Then click Next.

In step 2 you need to check the Space option in the Delimiters section. (Make sure all other choices are unchecked.) Basically what you're doing here is telling Excel what character separates your pieces of data—so that when it find a space it knows to stick the next piece of text in a new column.

Did you notice the preview of your data in the bottom window? See how the names are now divided into different columns?

cialis rebate

Click Next.

Step 3 will allow you to do some formatting and placement of your data—but for now, as beginners, just click the Finish button.

Poof!

Just like magic your first and last names are in two separate columns, ready to sort – no retyping necessary.

(Ok—maybe not magic but, if your list was long, you'll feel like it was when you realize how much time you just saved.)

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

Word Search & Replace – Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

 

Find and Replace in a Column or Row. You can use Word's searching capabilities to search just the information in a table column or row. The trick is to make sure you select the area you want searched, and then change the setting of the Search drop-down list in the Find and Replace dialog. Microsoft Word versions: 97 | 2000 | 2002 | 2003

 

Find and Replace in Text Boxes. Find and Replace can work great, but not necessarily for text within text boxes. This tip discusses all the ins and outs of working with text boxes when it comes to finding text within them. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

 

Finding an Unknown Character. Most of the text in a Word document is readily identifiable because you create it using well-known keystrokes: A, B, C, etc. Some characters are much harder to figure out, however, as they have no keyboard equivalent. If you need to search for or replace these characters, your first task is to figure out what they are. This tip provides an easy way to make that determination so that you can do the desired search or replace operation. Microsoft Word versions: 97 | 2000 | 2002 | 2003

 

Finding the Previous Occurrence. Using Word's Object Browser, it is very easy to move among different instances of what you want to search in your document. This tip explains how this tool can be used effectively to enhance your searching efforts. Microsoft Word versions: 97 | 2000 | 2002 | 2003

 

Ignoring Accented Characters in Searches. When writing in non-English languages, there can be many variations of accented characters that are used in a word. You might want to search for the word in a way that the accented character is ignored. Word sort of allows you to do this, if you just modify how you do the search. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

 

Keyboard Control of the Find and Replace Dialog Box. Hate to take your hands off the keyboard? This tip explains how you can use the keyboard to work with the Find and Replace dialog box, without the need to use the mouse at all. Microsoft Word versions: 97 | 2000 | 2002 | 2003

 

Mass Search and Replace. Word does not provide a way to do a find and replace through a group of documents. The macro and third-party solutions presented in this tip will help you find a way to find and replace exactly what you need. Microsoft Word versions: 97 | 2000 | 2002 |cialis professional generic color: #5b5959″> 2003

 

Matching At the Beginning or End of a Word. The pattern matching capabilities of Word's search engine are quite powerful. You can tailor your search pattern so that whatever you specify must occur at the beginning or end of a word. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

 

Ordering Search and Replace. Using the wildcard capabilities of Word's Find and Replace feature, you can do some fairly complex operations. This tip describes how you can use parentheses in what you are search for in order to affect what it is replaced with. Microsoft Word versions: 97 | 2000 | 2002 | 2003

 

Preserving Bookmarks During Replace Operations. Without an understanding of how bookmarks work, it is easy to wipe them all out by doing a replace operation. Microsoft Word versions: 6 | 95 | 97 | 2000 | 2002 | 2003

 

Removing All Comments. How to remove Word's comments from your document. Microsoft Word versions: 6 | 95 | 97 | 2000 | 2002 | 2003

 

Replacing Text with a Graphic. The Find and Replace feature in Word provides you with some powerful tools you can use to process a document. One such tool is the ability to replace text with graphics. This tip demonstrates how easy this type of editing is. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

 

Searching for a Specific Field. Fields can be a great boon to document development, as they allow you to insert different types of dynamic information in the body of the document. If you want to search for a specific type of field, you can do so using the techniques presented here. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

 

Searching for Borders. The Find and Replace feature in Word allows you to easily search for lots of different items or characteristics in your document. One of the things you cannot natively do, however, is to search for borders on paragraphs. This tip introduces two macros that make short work of finding any bordered paragraphs in your documents. Microsoft Word versions: 97 | 2000 | 2002 | 2003

 

Searching for Text that Does Not Have a Certain Format. You can easily use Find and Replace to find text that has a particular format to it. Most people don't know you can use the same tool to find text that does not have a particular format. Here's how to do this type of search. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

 

Selective Formatting in Replacements. Do you need to replace text with a term or phrase that uses multiple formats? You can perform this seemingly complex task using the powerful find and replace tools in Word, or you can create a macro that will do the trick for you. Microsoft Word versions: 97 | 2000 | 2002 | 2003

 

Selective Formatting in Searches. Need to search for text that has different formatting within the search term? Word can't handle something this complex, but you can create a macro to do the searching for you. Microsoft Word versions: 97 | 2000 | 2002 | 2003

 

Special Characters in Pattern Matching. The most powerful search engine in Word use pattern matching, but the way you specify special characters in a pattern-matching search is different than in a regular search. This tip examines some of the differences that can affect how you do your searching. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

 

Pasted from <http://wordtips.vitalnews.com/W191_Find_and_Replace.html>

 

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 the Semiologic theme and CMS • Sky Gold skin by Denis de Bernardy