Cancel/Close Window

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

software tips, tricks, tactics; Microsoft Office expert 
June 2009                                                                                             Issue #53
Greetings!   
crutches, accidentOn the last day of May, I fell in my backyard and broke my ankle in 3 places. After surgery to add 16 screws and 2 plates (ouch!), my personal and business plans for the summer quickly changed. The downtime has given me a chance to catch up on reading, movies, and work projects but also to reflect on a number of thoughts such as "How does the cat know exactly which key on the laptop to step on to create the greatest response?", "Next time you say that you need a break, be clear that you really just mean a short getaway", and most important, "Value technology but cherish relationships!"
 
Value Technology But Cherish Relationships
I am thankful that, with my laptop and phone, I've been able to start some new projects and wrap up a few others, stay connected with clients, reschedule training classes, and keep running a business. The biggest upside though are all of the personal emails, ecards, videos, and funny pictures I've received that have brightened up my day. Technology is essential to many of our lives but the support and help I've received from family, friends, neighbors, and clients has been much more critical to my health and well-being. I am especially thankful to the love of my life who has been caring for me 24/7! I encourage you to take a break from technology (after you read this issue ;-) to hug a friend or call (not just text) someone important to you!

Moving to Microsoft Office 2007 Webinars
Starting in July
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. To register for an upcoming webinar or to learn more, click to www.Office2007Webinars.com.

In This Issue
Feature Article-Understanding Sections in Microsoft Word
Quick Tips & Tactics-How to Go To the Excel Formula Bar
Mouse Bytes
About Dawn
Forward this issue to a Friend
Quick Links
Contact The Software ProŽ

Book Dawn for your next meeting
 
Feature Article 
Understanding Sections in Microsoft Word
(or Why Word Can Be So Frustrating)
The longer and more complex your document is, the more likely it is to need different sections. Word's sections aren't chapters, that is, they don't have anything to do with how you've divided your document with headings and subheadings. Sections are electronic divisions you create by adding section breaks to your document. Section breaks are a close cousin to page breaks, except a section can contain any number of pages. More important, each section in a Word document can have its own distinctive page formatting.

Many people work with Word for years without ever really understanding Word's sections. After all, the majority of Word documents are only a single section. In fact, a multiple page document can be just one section.
 

Documents Start with One Section
section breaks, divided documentsThink of your document as a large piece of undeveloped, flat land. Initially, it has one set of boundaries with the same look throughout. Now, you want to divide the land into plots for individual property owners who can develop their areas in any way they want. Each lot is divided with fences and property lines...in Word, these boundaries are called section breaks. The section breaks allow you to change the page formatting for one section without modifying the rest of the document.

When You Need Section Breaks
A section break separates the document into multiple sections for individualized formatting. With section formatting, a document can easily be divided into separate pieces such as a title page, report detail, appendixes, portrait vs. landscape layout, and other changes to the document structure. Section breaks also make it easy to switch between one column to multiple columns and then back to a single column of text.
 
Section breaks are needed in a document when page formatting changes within the same document, or your document includes more than one type of column formatting.
 
Specifically, section breaks are needed in the following circumstances:

  • section breaks, dividing Word documentsDifferent margins: For documents such as a letter, where the first page might require a two-inch top margin to make room for the letterhead, with the following pages requiring a standard one-inch top margin plus a header that should not start until the second page.
  • Different headers and footers: For documents that require different formatting for various headers and footers. (Note: trying to change headers and footers is probably one of the biggest time wasters in Word if you don't know about sections)
  • Different paper sizes: Multiple sections are required with documents with both portrait and landscape page orientation.
  • Different numbering schemes: Large documents often require different page numbering formats from one area to another. For example, the Table of Contents may be numbered with lower case Roman numerals (i, ii, iii) while the main body uses Arabic numerals (1, 2, 3) and the document concludes with Appendices using alphabetic numerals (A, B, C).
  • To restart automatic numbering for separate chapter: Word uses automatic numbering for figures and other items. If you have a multi-chapter document, you may want the numbers to restart with each chapter.
  • Columns: Multiple sections are used in documents with newspaper style columns combined with standard one column formatting. You can even change the number of columns on a single page.

Inserting Section Breaks
To insert a section break in Word 2007:

  1. Choose the Page Layout tab > Page Setup group > Breaks.
  2. When you click the Breaks button in the Page Setup group, the menu is divided into two parts: Page Breaks and Section Breaks.
  3. Choose the type of section break that you need for your document.

To insert a section break in Word 2003:

  1. Insert > Break.
  2. From the list of section break types, choose the type of section break that you need for your document.

Types of Section Breaks
There are four different types of section breaks in Word. For most complex documents, the Next Page section break is used most frequently.

Section breaks have two major distinctions. There are Next Page breaks, which create a new page for the new section, and there are Continuous breaks, which place a divider mark in the text with no visible interruption. Everything below that mark is in a new section. You use the Continuous break to change the number of columns or the margins in your document in the middle of a page.
 
The other two options-Even Page and Odd Page-are just variations on Next Page. They create section breaks and start the new section on the next even or odd page. For example, you use this option to make sure all your chapters begin on a right-hand page.
 
Section breaks are also automatically created any time you select a portion of text and then change page formatting; your choices will be applied just to the selected part of text. As needed, section breaks may be added at the start and end of the selected text.

How Section Formatting is Stored
It's important to note, in a single section document, section formatting is stored in the last paragraph mark. With multiple section documents, a section break stores the formatting for the section that precedes it. So, if a section break is deleted, section formatting applied to the section that preceded the break will change to match whatever section show hide screen marks, section breaks, dividing Word documentsformatting is stored in the next available break. (Note: it's a good idea to keep the Show/Hide option turned on so that you can easily see section and page breaks onscreen.)

Before deleting any section break, take note of all differences in section formatting between the sections before and after the break. Remember, after you delete a break, all section formatting in the section that preceded the break will revert to the formatting saved in the section following the break.

Understanding how Word formatting and section breaks work will simplify and streamline how you create and edit your Word documents.

Word long documents, complex documents, Word 2007

This article is an excerpt from the book, Word 2007: How to Simplify Long or Complex Documents available at www.WordLongDocuments.com.
To your success,
dawn signature 
Dawn Bjork Buzbee
The Software ProŽ 
Feedback@SoftwarePro.com
Quick Tips & Tactics 
Here's a shortcut tip that was requested three times in the last few weeks, and so, I thought that you might find it helpful too! 
Keyboard Shortcut to Go To Excel Formula Bar
 
To enter formulas into an Excel worksheet, just select a cell and start typing. To edit an existing formula, you probably make changes in the Formula bar (above the column headings) which you can access with a click of the mouse. That method's fine but some people (like me) prefer working with the keyboard as much as possible. If that describes you, press the [F2] function key instead of reaching for the mouse the next time you want to edit an existing formula. These are just a few of the Excel Shortcuts for Editing a Cell.

When you use [F2] to edit a cell, by default, [F2] positions the cursor in the cell (for "in place editing") instead of the Formula bar. To change the [F2] function key so it moves directly to the Formula bar:

Excel 2003 (and earlier):

  1. From the Tools menu, choose Options.
  2. Pick the Edit tab.
  3. Uncheck the Edit Directly In Cell option in the Settings area. OK to apply.
Excel 2007:
  1. Click the Office button and then pick Excel Options (at the bottom right).
  2. Select Advanced in the left pane.
  3. Uncheck the Allow editing directly in cell option. OK to apply.
Moving to Microsoft Office 2007 WebinarsWord2007
To attend an upcoming webinar in July, 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 
Who Moved My Delete Key?
delete key, laptopLenovo, which bought IBM's personal-computer business in 2005, put nearly a year of research into two design changes that debuted on an updated ThinkPad laptop in June. No, not the thinner, lighter form or the textured touchpad - rather, the extra-large "Delete" and "Escape" keys. The re-design was based in part on keystroke tracking which showed that, on average, employees used the "Escape" and "Delete" keys 700 times per week, yet those were the only "outboard" keys, or non-letter keys, that hadn't been enlarged.
 
Read the rest of this Associated Press/USA Today article at:
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