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.

---

Groupware: What Works the Way Businesses Do?

GroupwareThe internet is full of 1.5 million to 7 million... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

Internet Relay Chat - A Basic Introduction

What is IRC?IRC is Internet Relay Chat. It is a... Read More

Why do Manufacturers Invest in Business Management Software?

With many manufacturing shops heading over seas in favor of... Read More

Business Planning Software

Once a business idea is selected, it is highly recommended... Read More

Easy Guide to RAID Recovery

What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

Should I Use Windows Update?

Should one use Windows Update?This topic has good and valid... Read More

Adware, What Is It?

Adware is a type of Spyware program that displays some... Read More

Microsoft Great Plains international implementation ? USA / Mexico ? overview for consultant

Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More

Is Software Tester a Most Infamous Person in a Software Project Team?

The fact that a software tester is a most infamous... Read More

Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

Usually workflow & messaging is realized in CRM and then... Read More

10 Steps To Secure And Manage Your Passwords

Passwords protect your most sensitive personal, financial and business information.... Read More

Basic Steps To Optimize Your Internet Security

After seeing many people complain about their weak Internet security... Read More

.Net Charts and Graphs Interact with Businesses and Customers

Bar charts, bar graphs, and any other chart or graph... Read More

Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist

Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More

Builders Beware

Which Type of Shop Can Rely On A Home Built... Read More

Your Computer May Be Infected, Heres How To Check (NOT about virus)

NOTE: Please take time to read on - it may... Read More

eCommerce development for Microsoft Great Plains: tools and highlights for programmer

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

SQL Administrator Skills Required to Support Microsoft Great Plains

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

Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system... Read More

5 Mac Security Tips You Can?t Live Without

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

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More

Collaboration Software: Index of Collaboration Software Technologies

Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... 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

MCP Market News: Microsoft SQL Server & SQL Reporting Services

Are you ready? SQL Server 2005, the next-generation data management... Read More

How To Avoid Getting Hooked By Pfishing

"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

There are plenty of articles out there about how to... Read More

Google Brings the Earth to Your Desktop

Google Inc. has launched a new software package that allows... Read More

The End of Spyware?

The US House of Representatives has recently passed the "Spy... Read More

Think Of This

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

Why Stick With Email Clients Like Outlook?

Trying to figure out a stream in banning one email... Read More

Software Tools To Help Your Business Sell More

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