[April 15, 2008]

 

Everywhere you look this week it is a riot of color! Everything is blooming and it looks gorgeous! I even have some daffodils blooming in the woods. They look especially pretty sitting amidst the stark trees that have not gotten all their leaves yet.

It's been pretty quiet around my neck of the woods. It wasn't too pretty when I fell off of my bike today but nothing got hurt but my pride thank goodness!

Let's welcome Richard, Thomas, Valerie, and Lee, our latest Premium subscribers! Welcome to the family! Every new subscription helps me to make a monthly donation to The Covenant House, which helps homeless children. Thank you so much all of your for all of your loyal support!

Don't forget that it's not too late to buy my books on the latest version of MS Office! Just visit the Office Products page and browse. Premium subscribers always receive deep discounts on all products.

The greatest advertising is word of mouth so please be sure and tell everyone about my newsletter!

Carol's Signature

Table of Contents

Supercharged Arrow Keys in MS Word - More savings of time and keystrokes.

Quicker Formulas in MS Excel 2007 - Less Time, less keystrokes!

Number it your Way in MS PowerPoint - Make it the way YOU want it!

Supercharged Arrow Keys in MS Word

We all know the basic ways of navigating through a document in MS Word using the Page Up, Page Down, Home, End, and Arrow keys right? If I have done my job properly, you should be nodding yes right now. I am assuming that you all also know that the left and right arrow keys move you one character either way too.

So now that we have established what you DO know, how about if I try and teach you a little something about the Arrow keys that you do not know?

Follow along with the steps below:

  • The CTRL key + Right or Left Arrow will move your cursor one entire word in the selected direction.

What about the Up and Down Arrow keys you ask?

  • Use the CTRL key with the Up or Down Arrow key and you will find that you are moving up or down to the next paragragraph start. The first time you use the CTRL + the Up Arrow, you will go to the top of the current paragraph. After that, use the key combination again, and you will actually move up to the next paragraph.

Always looking out for you to save time and keystrokes!

Return to Table of Contents

Quicker Formulas in MS Excel 2007

MS Excel in this latest version, has some very easy browsing techniques. Having said that, suppose you aren't exactly sure what you are looking for? Suppose you know what you need but can't remember the name of the formula? It is easy to become aggravated under these circumstances. Surely there must be a quicker way to find it without going through the Formula Ribbon!

Well I'm here to tell you that there really is an easier way. When you cannot remember an exact formula name, you no longer have to roam around looking for it.

Follow the steps below to find out how:

  1. Start the formula with the usual equal sign (=) and they type the first couple of letters in the formula that you need.
  2. MS Excel 2007 will automatically provide you with an alphabetized list of formula names, starting with the letter(s) that you entered. It will even provide you with descriptions when selected.
  3. Browse through the list to select the correct formula that you need.

Now here is a handy little tip regarding this tip - an extra if you will.

  • To select the formula name, use your Tab key or, if you prefer, double click the formula with your mouse.

Great information to have, don't you agree?

Return to Table of Contents

Number it your Way in MS PowerPoint

Sometimes you give a PowerPoint presentation that involves more than one PowerPoint files. Isn't it just a tad confusing having the slide number of all the different files restart at number one? I have always thought so for sure!

The good news is you can adjust the slide numbering without merging the presentations together!

Follow the steps below:

  1. Click on File | Page Setup.
  2. In the latest version (2007), use the Design ribbon.
  3. Select the Number Slides From.

Page Setup

  1. Enter the number you want for the first slide in the presentation.
  2. Click OK.

Ah, a much easier and less confusing solution!

Return to Table of Contents

Included in the Premium Newsletter:

  • Oh Dear! How Do I Undo the Master Slide?
  • Text from MS Word to MS Excel Quickly
  • Free International Toolbar Add-In for MS Word, Etc.
  • A List of your Favorite Styles in MS Word

Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.