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.

---

Microsoft Great Plains e-Commerce ? additional considerations for programmer

Microsoft Great Plains, designed back in 1990th as database transferable... Read More

International Support - Microsoft Great Plains VAR/Partner Selection ? Overview for V.P. IT

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Microsoft Office Selecting Secrets

Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More

IBM Lotus Domino or Microsoft Exchange?

IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More

Microsoft Great Plains: If You are Orphan Client ? What to Do and FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More

Spyware, Adware, etc. -- Terms and Common Sense

When reading an article where some term is used often,... Read More

The Death of Windows

I have always regretted how Microsoft price gouges and rips... Read More

5 Mac Security Tips You Can?t Live Without

So, you've bought a new Macintosh, and now you may... Read More

Intro to UNIX Shells

A UNIX Shell is in simplest terms, a command line... Read More

SQL Administrator Skills Required to Support Microsoft Great Plains

Microsoft Great Plains is becoming more and more popular and... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

Unwanted Files

A LOT OF UNWANTED FILES.When you uninstall an item of... Read More

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

Device Driver Basics

Most people understand that the "hardware" part of their computer... Read More

Benefits of Integrating Online Chat Software with CRM

Customer Relationship Management (CRM) is a strategy and processes used... Read More

Microsoft Great Plains eCommerce ? Stored Procedures Approach

Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More

The XP Firewall Isnt Enough

You might think you don't need a firewall... Read More

Software For Your Hard-Drive

All your software is stored on a hard-drive. But how... Read More

Information Products: A Business Owners Best Friend

We live in a post-industrial age where information is the... Read More

Groupware as a Document Manager: Collaboration Series #3

This article is the third of a series of articles... Read More

Microsoft CRM for Large Corporation ? Security

Microsoft Business Solutions CRM proved to be reliable solution in... Read More

Microsoft CRM Implementation & Remote Support

We would like to give you pluses and minuses of... Read More

ERP Consulting: Microsoft Great Plains Partner Future Directions

In the Clinton era the status quo was simple: you... Read More

Software Review: Xsitepro Total Site Management Software

It's not very often I get excited about a software... Read More

Linux vs Windows Operating Systems

With so many Microsoft Windows related viruses, errors, and other... Read More

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software... Read More

Scrap Booking Online: Word Perfect or Corel Graphics Suite?

Scrapbooks are very popular these days. I think that almost... Read More

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

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

Behave, Word, Behave!

If you copy something from a Web site or elsewhere...... Read More

FreeDOS

Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More

Constructionalist Parsing - Deciphering Natural Language

The research in the field of Natural Language Processing usually... Read More

Choose your Java Wisely

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

C++ Tutorial 2, Input and Variables

This is the tutorial where we really get into programming.... Read More