Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Sunday, March 14, 2010 – Permalink –

This blog has moved


This blog is now located at http://unofficialwordstuff.blogspot.com/.
You will be automatically redirected in 30 seconds, or you may click here.

For feed subscribers, please update your feed subscriptions to
http://unofficialwordstuff.blogspot.com/feeds/posts/default.

<Doug Klippert@ 8:29 AM

Comments: Post a Comment


  Saturday, March 06, 2010 – Permalink –

Hidden Data

Secrets revealed

Ed Bott has a discussion on Metadata. That information, such as names and notes, which is hidden in Word documents.

EdBott.com




See all Topics

Labels: ,


<Doug Klippert@ 3:05 AM

Comments: Post a Comment


  Friday, February 26, 2010 – Permalink –

Word Features

New or reacquaint

2007 came up with a number of new and impoved features. Most are the same in 2010.
Here's a description of some built in tools.

Beyond the Ribbon




See all Topics

Labels:


<Doug Klippert@ 3:31 AM

Comments: Post a Comment


  Thursday, February 18, 2010 – Permalink –

Custom QAT

Access additions


Applications put most of the most-used commands on the Home tab's Ribbon, not everything is there. You may want to add Close, Close All, or Print commands, for example.

In the upper Left corner is the Quick Access Tool bar.

To update the QAT:
Click the down-pointing arrow to the right of the QAT.
Choose any common commands (New, Close, Print, etc.) by checking the option.




See all Topics

Labels:


<Doug Klippert@ 3:33 AM

Comments: Post a Comment


  Tuesday, February 09, 2010 – Permalink –

Merge Formatting Extended

Manipulation

When you merge data into Word, it takes on the formatting of the target document.
This tip allows you the dictate the appearance of merged data.


VitalNews.com




See all Topics

Labels: ,


<Doug Klippert@ 3:41 AM

Comments: Post a Comment


  Thursday, February 04, 2010 – Permalink –

Command Reference

2003-2007-2010

Those of you that are just now making the switch to the Ribbon world, will find this valuable.

ComputerWorld.com




See all Topics

Labels: , ,


<Doug Klippert@ 3:15 AM

Comments: Post a Comment


  Tuesday, February 02, 2010 – Permalink –

Office Training

Suggestions

TechRepublic lists a number of areas that you might explore when training is needed for a new Office version.

Here are a few:

  • LINKS TO TIP SHEETS AND ARTICLES
    "Instead of telling your users to go out to Microsoft.com and do a search, put hyperlinks to the printer-friendly version of tip sheets and articles on your company’s main portal page. Providing links to information you know they need will help you cover the training bases. And presenting the links on an internal web site they already use will show your users that it’s okay to go outside of their four firewalls to learn something new. Include your favorite hyperlink in your signature line so it goes out in every e-mail you send."
  • ONLINE TRAINING
  • E-LEARNING
  • WEBCASTS
  • VIRTUAL TRAINING
  • MULTILINGUAL SCREENTIPS AND TRANSLATIONS
  • COMMAND REFERENCE GUIDES
  • OFFICE ONLINE AT WORK
10 ways to train your users on Office 2007 for free




See all Topics

Labels:


<Doug Klippert@ 3:54 AM

Comments: Post a Comment


  Monday, February 01, 2010 – Permalink –

Tips for Word and Excel

Also some Windows hints


This site has useful information about:

  • Word
  • Word VBA
  • Excel
  • Excel VBA

    and
  • Windows
Tribbs.co.uk




See all Topics

Labels: , ,


<Doug Klippert@ 3:33 AM

Comments: Post a Comment


  Tuesday, January 26, 2010 – Permalink –

Where's the Template

Find and/change storage spots



Describes the different template categories and the locations of templates in 2007 Office programs. Also describes the registry settings that control where to find your custom templates.

Support.Microsoft.com




See all Topics

Labels: ,


<Doug Klippert@ 3:46 AM

Comments: Post a Comment


  Monday, January 25, 2010 – Permalink –

Character Codes

HTML and ALT+


Here's another table with the codes needed to insert characters that do not appear on the keyboard:

Keyboard Shortcuts




See all Topics

Labels: ,


<Doug Klippert@ 3:46 AM

Comments: Post a Comment


  Sunday, January 17, 2010 – Permalink –

Merge Word to PDF

Not just MailMerge anymore

Sure, you can create a merged letter and have 30 pages of individualized information.
What now? How do you create separately named documents to, maybe, send as attachments?
Another task might be to convert those 30 docs to PDF. Oh, the hours wasted!

Graham Mayor, a retired newsgroup junkie, offers a solution.
It's a macro that will convert the merged output as individually named doc(x), and/or PDF files.
I've used it, and now wonder what I can do with the time I'm saving.






GMayor.com

Merge with Attachments



See all Topics

Labels: , , , ,


<Doug Klippert@ 3:10 AM

Comments: Post a Comment


  Monday, January 11, 2010 – Permalink –

Merge Access with Word

Database integration



"You can merge Microsoft Office Access 2007 data with a Word 2007 document by using the Mail Merge Wizard. This demo shows you how to create a simple form letter and how to troubleshoot problems. You can also use this feature to create address labels or any other type of Word document in which you want to display Access data."
Office.Microsoft.com




See all Topics

Labels: ,


<Doug Klippert@ 3:45 AM

Comments: Post a Comment


  Wednesday, January 06, 2010 – Permalink –

Typography and Word 7+

Shape and display

Here are some suggestions about how to make your text easier to read.

"Ever wonder why some text seems easier to read than others? A few basic formatting changes can make reading text much easier. Factors like line spacing, font choice, font size and margins are key to legibility. "

Office.Microsoft.com




See all Topics

Labels: ,


<Doug Klippert@ 3:24 AM

Comments: Post a Comment


  Sunday, January 03, 2010 – Permalink –

Keyboard and Key Tips

Finger it out



2007 apps look different because of the ribbon, but the keyboard can still be used to speed up tasks.
Microsoft has an online course that may help

After completing this course you will be able to:
Accomplish tasks by using sequential shortcut keys, known as Key Tips, shown on the Ribbon.
Navigate around the Ribbon using the TAB key and arrow keys.
Accomplish tasks by using key combinations — keys you press at the same time - exactly as you've done in previous versions of Office.
Office.Microsoft.com/Training




See all Topics

Labels: ,


<Doug Klippert@ 3:54 AM

Comments: Post a Comment


  Thursday, December 31, 2009 – Permalink –

Forms in Word

With and without code


Data entry forms can be designed and presented using VBA code. Another simpler way to do it is to construct a form directly in the Word document.
"Have you ever been asked to fill out a form in a word processor, only to discover that when you attempted to enter information, the lines on the form moved all over the page? Not to mention that the form was difficult and time-consuming to fill out? Most people don't realize that you can easily create professional-looking forms in Word."


  • Part I: Create professional looking forms in Word

  • Part II: Adding Automation to your Word forms

  • Part III: Learn more about VBA macros to automate your form

  • Part IV: Use custom dialog boxes in your Word forms

  • Part V: Linking your AutoForm to a database
Please Fill Out This Form!

By Dian Chapman at TechTrax

Also:

 Fun with Forms

Cindy Meister



See all Topics

Labels: , , ,


<Doug Klippert@ 3:13 AM

Comments: Post a Comment


  Saturday, December 19, 2009 – Permalink –

Notes from Word

Import it all



One technique that can be used when preparing a PowerPoint show, is to import material from an existing Word Outline.

If the Word document is formatted with Heading styles, Heading 1 will become a new slide and the subsequent headings, 1 through 6 will become bullet points on the slide.

It may be desirable to prepare notes for each slide while developing the Word outline. Notes don't appear on the slide, they are placed on a separate page that can be printed out for the speaker or handed out to the audience.

Bill Dilworth has written a macro that moves information that has been formatted, say at Heading 6, and places it on the notes page:

"This macro outline allows the user to use Word's "Send To PowerPoint" feature, then run this macro to get notes from MS Word to PowerPoint as notes. The macro allows you to set the text level you want to become the notes.


Word Outline to Notes Page in PowerPoint




See all Topics

Labels: ,


<Doug Klippert@ 3:25 AM

Comments: Post a Comment


  Tuesday, December 15, 2009 – Permalink –

Change Insert Picture Target

File location


If you would like to specify the folder Word will default to when you go to Inset>Picture:
  1. From the Tools menu, click Options.

  2. Select the File Locations tab.

  3. Select ClipArt Pictures from the File Types list.

  4. Click the Modify button.

  5. Navigate to the folder you want Word to default to.

  6. Click OK. OK.



In 2007-10, you'll find the entry by
  1. Click on the Office logo

  2. Go to Word Options>Advanced

  3. Scroll down to General

  4. Click the File Locations button



See all Topics

Labels: , , ,


<Doug Klippert@ 7:24 AM

Comments: Post a Comment


  Thursday, December 10, 2009 – Permalink –

Templates are Digital Stencils

Make your own


If you have a document; such as a report or reoccurring newsletter, one way to reduce the production time is to create a template.

These preformatted, boiler plated documents can then be fleshed out without having to reinvent the sardine.

Here are some tutorials to help you along:

AddBalance.com
Template Basics

About.com
Word Templates




See all Topics

Labels:


<Doug Klippert@ 3:55 AM

Comments: Post a Comment


  Wednesday, December 09, 2009 – Permalink –

Sparklines

Quick graphic reinforcement


A graph or chart can give the reader a visual representation of a great deal of data. Concepts or results can be more easily grasped by a well formatted graphic.

Charts, usually, take up more space in a document than is absolutely required.

Edward Tufte has come up with the concept of Sparklines (Sparklines:Intense, Word-sized Graphics)
.
These are small graphs about the same height and width as common words. They are not out of place in the text of a document.

Sparklines give the reader a snapshot of the data that quickly supports the material being discussed.



See:
Bisantz Sparklines

The Sparkmaker can create Sparklines for Word, Excel, or PowerPoint. They can also be produced in HTML.




See all Topics

Labels: , , ,


<Doug Klippert@ 3:27 AM

Comments: Post a Comment


  Monday, December 07, 2009 – Permalink –

Hidden Macro Names and Shortcuts

Revealed


Word has built in macros to perform routine actions such as using the Format Painter to copy formatting.

Rather than trying to guess the name or look up the shortcut keys, use this seldom mentioned trick to find toolbar macro names.

Press the three key combination of Ctrl, Alt, and + (the plus sign on the Numbers keypad).

The mouse pointer changes to a 4-leaf clover.

Click on a toolbar icon. Word will display a form revealing the macro name and the assigned shortcuts.



(It works the same way in 2007-10)




See all Topics

Labels: ,


<Doug Klippert@ 7:22 AM

Comments: Post a Comment


  Friday, December 04, 2009 – Permalink –

Password Background

Unencrypted

Alan Myrvold has written a background article on how Office handles passwords and what password strength means.

"Word, Excel, and PowerPoint have been able to password protect documents for several versions by setting the 'password to open'. What we felt could be improved was the ability to enforce password strength rules, similar to what may be required when logging into your computer at work."






See all Topics

Labels: ,


<Doug Klippert@ 3:56 AM

Comments: Post a Comment


  Tuesday, December 01, 2009 – Permalink –

REDUSE MISSPELLINGS

You might be missing typos in tables

If you've ever found typos in a table or list that you're positive you remember spell checking, chances are that the typos are in words that are purposely skipped during the spell check.

By default, SpellChecker ignores words that are all upper-case or that have numbers in them. In most cases, this is probably fine. However, especially with purchased data, you'll occasionally come across tables where everything is capitalized.

Fortunately, you can change the way SpellChecker works so that all words are included.

To do so, run the SpellChecker on a data selection that will cause the Spelling dialog box to be displayed.

Then, click the Options button and clear the Words In UPPERCASE and Words With Numbers check boxes.

Finally, click OK and then Cancel.




See all Topics

Labels:


<Doug Klippert@ 3:46 AM

Comments: Post a Comment


  Monday, November 30, 2009 – Permalink –

Find the Word

And Replace


Word has one of the most complete and malleable Find/Replace systems of any application.
Here is a 26 page report on how to use it from Editorium.com.
While your there, sign up for the free newsletter.

Advanced Find and Replace for Microsoft Word

"One of Word's most powerful features, especially for editing, is Find and Replace using wildcards and character codes. This free tutorial (a Word document) will take you step by step through what you need to know. If you don't download anything else here, be sure to get this--and work your way through it. It's well worth the effort."


Editorium.com/Freebies



See all Topics

Labels:


<Doug Klippert@ 3:08 AM

Comments: Post a Comment


  Wednesday, November 25, 2009 – Permalink –

Spell Check On

Spell check off


You can run Spelling and Grammar checking in Word by clicking on the ABC icon on the Standard toolbar (it's on the Review ribbon in Word 2007), going to Tools> Spelling and Grammar, or just hitting the F7 key.

As you go through the document, you may find areas that you would like to correct. You don't have to close the Spell checker, just click into the document, make the changes and click Resume in the Spell checker dialog box.

You can also flip focus to the document with Ctrl+Tab.
Then go back to checking with Resume.




See all Topics

Labels: ,


<Doug Klippert@ 3:59 AM

Comments: Post a Comment


  Sunday, November 15, 2009 – Permalink –

Color News

A multidiscipline subject


Here is a study about how color effects a reader's choice of concentration.

It was intended for newspaper publishers, but the same knowledge can be used in Web design, PowerPoint, or any other reporting application. Word and Excel will also benefit.

Color, Contrast, and Dimension in News Design

ColorProject

The Poynter Institute is a school for journalists, future journalists, and teachers of journalists.
Poynter.org




See all Topics

Labels:


<Doug Klippert@ 3:07 AM

Comments: Post a Comment


  Thursday, November 05, 2009 – Permalink –

Change Code to Comments

Fast solution


When you're testing procedures, you can temporarily convert a block of VBA code to comments that will be ignored during a trial run.

Doing so manually by inserting an apostrophe before each line of code can be a real chore.

To simplify this task,
  1. Open any module in the Visual Basic Editor (VBE)
  2. Choose View >Toolbars>Edit from the menu bar to display the Edit toolbar.
  3. Select the lines of code that you want to turn into comments.
  4. Click the Comment Block button on the Edit toolbar (it's the sixth button in from the right end of the toolbar).
Each line of the selected code is now preceded with an apostrophe. To convert the comments back to executable code, select the appropriate lines and click the Uncomment Block button, which is immediately to the right of the Comment Block button.




See all Topics

Labels:


<Doug Klippert@ 3:43 AM

Comments: Post a Comment


  Friday, October 30, 2009 – Permalink –

Thumbnail Views

Little pages


The Thumbnail view can be used to see the layout of a page or to jump from one page to another.

With Word 2003 and 2007, Thumbnail views are available in Normal, Print Layout, Outline, and Reading Layout views. Go to View>Thumbnails to display the Thumbnail pane to the left of your document. In 2007+ go to View>Navigation tab>Show.

Thumbnail versions of your document will appear in a new pane to the left of your current document. Click on a thumbnail page and Word 2003/7 will automatically jump to the selected page.






See all Topics

Labels: , ,


<Doug Klippert@ 3:12 AM

Comments: Post a Comment


  Friday, October 23, 2009 – Permalink –

Calculation Tool in Word

Select and Add


In Excel an instant answer is displayed on the Status bar, when a series of numbers is selected.

If you would like to calculate lists or columns of numbers in Word, look at ToolsCalculate. It will display the answer AND let you paste the result in your document.

ToolsCalculate can be added to a menu or tool bar. Pre-2007, it is available through Tools>Customize.
  1. On the Commands tab, select All Commands in the Category list, then scroll down the Commands list until you find ToolsCalculate.

  2. Drag it to the menu bar and hover the mouse over "Tools" until the Tools menu drops down.

  3. Drop Tools Calculate somewhere on the menu or drop it on a toolbar.

  4. Close the Customize box.
For directions see:
MVPS.org FAQ
  1. Type the numbers you want to calculate, along with the appropriate mathematical operators.

    Word can calculate numbers in a line, in a column or row in a table, or in a column separated from other columns with tabs. Word can also calculate numbers interspersed throughout the text in one or more paragraphs if you include a space on either side of each number.

  2. Select the numbers and operators.

  3. From the Tools menu, choose Calculate.

    Word calculates the result and displays it for a few seconds in the status bar. The result is stored on the Clipboard.

  4. To insert the result into your document, position the insertion point and choose Paste from the Edit menu (CTRL+V) or click the Paste button on the Toolbar.
This is left over from the halcyon days of Word 2.0 when Woody Leonard and Ed Bott were but children.


In 2007-10,
  1. Click the Office logo
  2. Go to Word Options on the bottom of the box.
  3. Go to Customize.
  4. Select All Commands and find Calculate.
The Calculate icon will now appear on the Quick Access toolbar.



Of course, you could use formulas:
 MicroSystems.com




See all Topics

Labels: , ,


<Doug Klippert@ 3:11 AM

Comments: Post a Comment


  Sunday, October 18, 2009 – Permalink –

Theses by the Numbers

Colour or Color?


The University of Calgary has a step by step tutorial on how to write a thesis.

  1. Choose a template
  2. Download a template
  3. Guidelines
  4. Styles & their Relevance
  5. Saving your files
  6. Writing - hints & tips
  7. Creating the Front Matter
  8. Assembling Chapters
  9. Page Numbers
  10. Printout & Submission

Included are Word Thesis Templates

Some of the hints may provide you with some help even if you use the letter "U" in a more parsimonious manner. See all Topics

Labels: ,


<Doug Klippert@ 3:57 AM

Comments: Post a Comment


  Monday, October 12, 2009 – Permalink –

Adjust a Page Border

Fix the box


There is a border around your title page, but the bottom line doesn't print. Usually the reason is that the bottom line (or on a landscape page, the right border) falls within your printer's unprintable area. Here are some suggestions for finding just where that area is and how to adjust your border so that it will print.

  • Find your printer's unprintable area

    Your printer manual may specify the unprintable areas. Inkjet printers, in particular, often have a large unprintable area at the bottom of the page.

    Here's a way to discover them for yourself in Word.

    1. Choose File>Page Setup>Margins tab. Change all four margin settings to 0". Choose OK.

    2. You're told that one or more margins are set outside the printable area of the page. Choose Fix.

    3. Word adjusts the margin settings to your printer's minimum values. Jot down your printer's settings for your future reference, then Cancel the dialog.

  • Adjust the Page Border

    1. Set the insertion point on the page that's bordered, then choose Format>Borders and Shading> Page Border tab. Choose Options.

    2. At the Border and Shading Options dialog, note that the default settings are to have all four borders set to 24 pt (which is 1/3"), and to have Measure from: set to Edge of Page.

    3. To maintain the measurement from the edge of the page, yet move the borders in more toward the center, set the measurements for each of the four margins to 31 pt (the maximum allowed).

      For an alternative setting, set Measure from: to Text. Now the Margin settings measure outward from your text margins. You can set the Margin values anywhere from 0 pt to 31 pt.

    4. Click OK>OK. Use the Standard toolbar's Print Preview tool to evaluate your results.

The border is measured from your text margins, not from your actual text. So, if your bottom border still doesn't print, increase the size of your bottom margin, then adjust the other margins as needed for a balanced appearance.




See all Topics

Labels: , , ,


<Doug Klippert@ 3:20 AM

Comments: Post a Comment


  Tuesday, October 06, 2009 – Permalink –

Unicode is Big

More symbols and letters


This free download lets you see and select more characters in the Unicode set. The Unicode Character Grid shows all assigned characters and private use characters in Unicode 5.2.




Here's a blog covering Scripts, Unicode, Character Encoding and BabelStone Stuff
BableStone Blog




See all Topics

Labels:


<Doug Klippert@ 3:24 AM

Comments: Post a Comment