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.

---

Vlans

In order to implement VLANs in a network environment, you'll... Read More

Implementing Microsoft CRM: setup and configuration ? notes for IT specialist

Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More

Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

Some introduction into Great Plains Software products, now Microsoft Business... Read More

Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer

Microsoft Business Solutions Great Plains is written in Great Plains... Read More

Microsoft CRM Implementation & Customization: MS CRM Fax Gateway

With this small article we are continuing Microsoft Business Solutions... Read More

Microsoft CRM Implementation for Large Corporation ? overview

Microsoft Business Solutions CRM is now approaching the phase of... Read More

Constructionalist Parsing - Deciphering Natural Language

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

Resume Software ? Advantages Revealed

The various resume software offered, particularly on the internet, can... Read More

The Death of Windows

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

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

Microsoft CRM Integration & Customization: SharePoint Document Gateway

MS CRM is very close to document workflow automation, including... Read More

Great Plains Dexterity: Customizations & Source Code Programming

Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More

Lotus Notes Domino and Microsoft CRM Integration

Well, even if the combination might look very unusual, we... 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

Microsoft Great Plains Multicurrency ? Overview For Implementation Consultant

When you first think about multicurrency ? you probably have... Read More

Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

In this small article we will be looking at the... Read More

Accessing XML Using Java Technologies

The most important benefit of XML is its simplicity. Though... Read More

Lotus Domino: Reports and Connectors ? Crystal Reports, XML, ODBC/JDBC, OLE

Lotus Notes Domino is very efficient in electronic document workflow... Read More

Snort for Network IDS

What is Snort?Snort is an open source network intrusion detection... Read More

Things You Can Do With Windows XP!

Did you ever give a thought to the number of... Read More

Microsoft CRM Implementation & Remote Support

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

C++ Tutorial 1, Introduction to C++

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

Keep Your Software Simple! A Review of EditPlus

I like my software simple. If it's too complex or... Read More

What to Do if All Screensavers Fun is Grayed Out?

Finally, you have some time to personalize your desktop with... Read More

Exactly What Does FTP Stand for and What Can it do for Me?

FTP stands for "file transfer protocol". FTP is basically a... Read More

Think Of This

Think of this, first we had the HAM Radio, then... Read More

Microsoft Great Plains Upgrade ? Things to Consider and FAQ

If you have Microsoft Great Plains and support it for... Read More

10 Things You Could be Using Photoshop For, But Probably Arent

Most people don't use Photoshop to its fullest capabilities. Here... Read More

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... Read More

Microsoft Great Plains SOP: Sales Order Processing

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

Microsoft Great Plains ? Licensing & Product Versions

Current Microsoft Business Solutions Great Plains has more that 10... Read More

Microsoft Great Plains eCommerce ? Stored Procedures Approach

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