Microsoft Office Selecting Secrets

Stop the Runaway Mouse

What's the "runaway mouse?" You've seen it...you may have even yelled at your computer when it happened. All you want to do is select (highlight) some text or data in a Microsoft Office document by dragging your mouse. Suddenly, your mouse has a mind of it's own and moves too far too fast. I've even heard people shout out "Whoa!" as they try to handle the out of control mouse.

What should you do? First, stop dragging your mouse! To stop the "runaway mouse" add some keyboard shortcuts. To begin, move to the top of the area you want to highlight. Then, press and hold down [Shift]. Move to the end of the area by pressing any directional keys such as the [Down] arrow or [Page Down]. Keep holding down [Shift] and continue moving to the end of text or data that you want to highlight. When you have the area you want then perform the next action: formatting, editing, etc.

Still like the mouse? Press and hold [Shift] and click to pick the end of the selection area even if it is at the end of the document. The key is not to drag; use the scroll bar if you need to make big moves.

Excel bonus: Okay, I admit there is a dragging trick in Excel. Instead of pulling harder on the mouse to move to the end of the selection, stop on the scroll bar. If you hop on and ride the scroll bar and gently pull the mouse, you can easily maintain control.

Easy Keyboard Selection Secret

Even better than the [Shift] key is a hidden selection trick. I compare this to taking the measurements of a large room--it's much easier with a friend holding the measuring tape at one end while you take your time to move to the other end. Ever have a measuring tape snap back when you try this yourself? The hidden trick is the [F8] function key.

To use this selection trick, simply:

1. Move to beginning of the selection area.

2. Press [F8] once.

3. Look in the bottom center or left corner of your status bar for EXT; don't expect anything to flash or pop up; EXT stands for Extend Selection.

4. Take your time moving to the end of the selection area with your keyboard and/or the mouse.

5. Perform the action to the selected area such as formatting, cut, copy, etc. The EXT mode turns off as soon as you do an action. Just move anywhere to clear the highlight. What if you change your mind and you want to turn off the Extend Selection without continuing? In Excel, press [F8] again or press [Esc]. In Word, press [Esc] to cancel. Move anywhere to clear the highlight.

Selecting Multiple Items

To select more than one item such as 2 different paragraphs in Word, 4 cells in Excel, 3 graphics in PowerPoint, or 10 files in Windows Explorer, choose either [Shift] or [Ctrl]. The basic steps work in Microsoft Office, Windows Explorer, and many other Windows programs.

To select a contiguous (touching) area use [Shift]:

1. Click once on the first item.

2. Press and hold [Shift].

3. Click on the last item that you want to highlight and everything in between will also be selected.

4. Perform an action such as formatting.

To select non-contiguous (unrelated) items use [Ctrl]:

1. Click one on the first item.

2. Press and hold [Ctrl] and, click on each of the other items, press [Ctrl] again to unselect.

3. Perform the action to finish working with the highlighted area. Some ideas for these options:

? Pick files from File > Open to open all of these at the same time in your Microsoft Office program.

? Choose multiple slides in the PowerPoint slide sorter to apply a transition.

? Highlight groups of cells or sections of text and apply formatting.

? Select drawing objects to group, move, or change formatting.

Selecting Tricks in Word With the Selection Bar

Have you ever used the selection bar? Just think of this as the left margin of your Word document. To locate the selection bar area, move your mouse to the left of text until it changes from an upper case "I" to a white arrow. Selection tricks to try with the selection bar:

? Click once to highlight entire line.

? Double-click to select the whole paragraph.

? Triple-click (can you do it?) to highlight the entire document (great for overall changes such as font formatting).

Easy Select All

To make changes to an entire document or file, press [Ctrl] + A to Select All or choose File > Select All (if available).

© 2004 by Dawn Bjork Buzbee

Dawn Bjork Buzbee is The Software Pro? and a certified Microsoft Office Expert and Microsoft Office Specialist Master Instructor. Dawn shares smart and easy ways to effectively use software and technology through her work as a speaker, trainer, and consultant. Visit http://www.SoftwarePro.com for great Microsoft Office software tips and tricks or to contact Dawn.

In The News:


pen paper and inkwell


cat break through


Microsoft CRM Conversation Gateway: VoIP - Implementation & Customization

Microsoft CRM is winning market share step-by-step from such the... Read More

Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

Microsoft Great Plains fits to majority of industries, in the... Read More

Microsoft Great Plains GL: General Ledger ? Overview For Consultant

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Reduce TCO: The Java Database Way

TCO (Total Cost Ownership) is the buzzword in... Read More

The Opera Alternative

Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More

Choose your Java Wisely

Java has come along a long way. Many would agree... Read More

What You Must Know About Spyware Right Now

Spyware is like the new technological nuclear weapon on the... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software... Read More

Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

If you would like to pick something from Microsoft, or... Read More

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

Do You Want Your Own Fully Programmable ERP? - Part 1

We are in a transition phase in the Managerial Administration... Read More

Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example

Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More

Great Plains DOS Support ? Notes for Consultant

Great Plains Accounting, accounting package for mid-size and small companies... Read More

Antivirus Software ? Get The Bugs Before They Get You!

You turn on your computer, and it doesn't look quite... Read More

Microsoft Great Plains Implementation in Russia ? Overview for Consultant

Microsoft Business Solutions Great Plains is very popular ERP platform... Read More

eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains

eStore Advantage allows front-office applications to communicate with back-office business... Read More

Screenshots Vista Windows

Features Additionally, Vista will include many other new features.Aero Vista... Read More

Lotus Domino: Application Integration ? A Programmer View

There are two approaches for application integration:? Programmer's approach ?... Read More

What is Fleet Maintenance Software?

Simply put, fleet maintenance allows companies to monitor and maintain... Read More

Anti-Spyware Protection ? Holes in the Shining Armor

Looking at all the ads which promise to get rid... Read More

Brand Your Websites URL With a Favicon

Have you ever noticed that when you look at your... Read More

Theres Gold in Your Websites Server Log

Many Webmasters have never bothered to view their website's server... Read More

Tools for Customizing Great Plains

Microsoft Business Solutions ? Great Plains has captured the US... Read More

Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant

All of us know that Microsoft bought former Great Plains... Read More

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants

We'll give you non formal view, based on our consulting... Read More

Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist

Currently Microsoft Business Solutions is on the way of creating... Read More

Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

Spyware and malware are large problems for Internet users today... Read More

Editing Your Photos Using Microsoft Picture It Publishing Platinum 2002 - A Great Dinosaur

I started using PIP (Picture It Publishing) Platinum 2002 right... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Microsoft CRM Customization - Processing In/Out-Going Email Messages

We would like to give you several situations, when you... Read More

Programming Environments And The Software Production Process

Introduction: The creating of a computer program involves a number... Read More