Cancel/Close Window

>>Back to eMagazine Archives
>>Back to The Software Pro Home

software tips, tricks, tactics; Microsoft Office expert 
May 2009                                                                                             Issue #52
Greetings!   
Travel freezes...time crunches...fewer people doing more work...offices spread across the country...these are just some of the reasons why many of us are looking at creative ways to quickly learn the answers we need.
 
happy people, webinar training, computerAlthough I am still speaking at conferences and delivering multiple-day training seminars, I've seen a huge increase in requests for webinars or virtual learning. Using web technology, you can invest as little as an hour to learn what you need to know about a targeted topic and take away great tips and tactics. Plus, the training takes place right at your desktop!
 
Moving to Microsoft Office 2007 Webinars
After more than two years providing onsite and remote training for Microsoft Office 2007, I'm rolling out my first public webinars on the new and updated features in Microsoft Office 2007. Still struggling with Office 2007? What can you expect when you are upgraded to Microsoft Office 2007? Save weeks of frustration and take away timesaving tips, tactics, and techniques in these content-packed web sessions. Find out how to easily work with the new and improved features in Office 2007.
 
Web training for Moving to Office 2007 is offered in two parts of one hour each. I have so much to share--these will be packed with great techniques and tips! Each webinar is value priced at $37 each or $60 for both. To register for an upcoming webinar or to find out more, click to www.Office2007Webinars.com.
 
Request a Webinar
Still using Microsoft Office 2003? Need to know more about specific programs in Office 2007 or 2003? Over the next few months, I'll be announcing additional webinar sessions to help you quickly move forward and be more productive with the software on your desktop. What topics do you want to learn more about? Let me know at Webinars@SoftwarePro.com
In This Issue
Feature Article-Microsoft Office: Selecting Secrets
Quick Tips & Tactics-Remove Names from Outlook's AutoComplete List
Mouse Bytes
About Dawn

Forward this issue to a Friend

Quick Links
Contact The Software ProŽ

Book Dawn for your next meeting
Feature Article 
By request, this is a repeat of one of the most popular featured articles from a previous issue.
Microsoft Office: Selecting Secrets
Stop the Runaway Mouse
computer mouse, selecting tips, highlight textWhat'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
select text, F8 function key, shortcut key, highlight tipEven 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 the Open dialog box 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
microsoft word, selection bar, select text in wordHave 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 (in Office 2003, if available).

More Selecting Shortcuts in Word & Excel
Want more ways to use the Word selection bar, the [F8] extend selection key, and other tricks to highlight your data? For instance, did you know that [Ctrl] + a mouse click will highlight an entire sentence? Check out these handouts for Word and Excel:
To your success,
dawn signature 
Dawn Bjork Buzbee
The Software ProŽ 
Feedback@SoftwarePro.com
Quick Tips & Tactics 
Remove Names from Outlook's AutoComplete List
outlook, autocomplete, outlook emailMicrosoft Outlook includes a handy AutoComplete feature. Have you noticed that Outlook offers a matching list of names or addresses when you begin to enter a name or email address in the To, CC, or Bcc field of a Message or Meeting Request form? This AutoComplete list is built from sent items in the past whether or not a name is in your Contacts list. However, if there's a name or email address that's no longer valid, or you sent an Outlook item with an incorrect email address in the past, those names and addresses continue to display in the dropdown list--quite annoying!
 
To delete a name you no longer need, begin typing a name in one of the address fields, and then use the arrow keys to select the invalid entry in the AutoComplete list. Finally, press the [Delete] key to permanently remove it from the list.
Moving to Microsoft Office 2007 WebinarsWord2007
To attend an upcoming webinar, click to www.Office2007Webinars.com
 
office 2007, webinarsMoving to Microsoft Office 2007-Part 1
Office 2007 is the most significant update in over 10 years. Even though the core function of each program remains, the look and feel of Office 2007 is dramatically different. Familiar menus and toolbars are gone, a radical user interface was added, and well-known steps need to be re-learned.

In Part 1 explore (1 hour):
  • 5 key changes to the Microsoft Office 2007 interface
  • How to manage new file formats and file compatibility
  • Microsoft Office 2007 tips, tricks, and shortcuts
Find out more at  at Office 2007 Webinars-Part 1.
 
Moving to Microsoft Office 2007-Part 2
Are your favorite commands in Office 2007 missing in action? Frustrated by new features and hidden commands? What improvements does Microsoft Office 2007 offer you in the programs you use every day? Even though the core function of each program remains, the look and feel of Office 2007 is dramatically different. In addition to a brand new user interface, a number of features in the top Office 2007 programs have been added or updated. What was changed and how can you easily take advantage of these improvements?
 
In Part 2 explore (1 hour):
  • Top New Features in Word 2007
  • Top New Features in Excel 2007
  • Top New Features in Outlook 2007
  • Top New Features in PowerPoint 2007

Grab your seat at Office 2007 Webinars-Part 2.

Mouse Bytes 
Bing! Like Bing Cherry?
bing cherry, bing search engineMicrosoft's new search engine, reportedly code-named Kumo, will actually be called Bing! Tech columnist John C. Dvorak (with tongue-in-cheek) explores the real meaning behind those four characters (But It's Not Google and more). Read the column at PC Magazine.com.
About Dawn
Dawn Bjork Buzbee is The Software ProŽ with over 25 years experience transforming geek speak into people friendly. A professional software speaker, trainer, consultant, and author, Dawn has helped more than 100,000 individuals to learn smart, easy, and productive ways to use software and technology more effectively.
 
Microsoft has awarded Dawn with the certifications Microsoft Certified Trainer (MCT), Microsoft Office 2007 Master Instructor, and Microsoft Certified Application Specialist (MCAS) Instructor for her expertise in Microsoft Office 2007 and Windows Vista. Dawn also holds the distinctions as a Certified Microsoft Office Expert and a Certified Microsoft Office Specialist Master Instructor with a proven track record in Microsoft Word, Excel, Outlook, PowerPoint, and Access. Training and coaching is also available on many other popular desktop programs. 
>>Find out more

>>Back to eMagazine Archives
>>Back to The Software Pro Home