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



  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, 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


  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


  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


  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


  Thursday, July 30, 2009 – Permalink –

Protected Spell Checker

Correct the protected


Unfortunately, Word's protection feature disables a huge number of important functions, even if you only protect a single section of a document.

Besides the spellchecker, many other items on the View, Insert, Format, Tools and Table menus are disabled, as well as most items on the Drawing, Database, Visual Basic and Picture toolbars.

This MS Word MVP FAQ Site article lays out the steps needed to

Enable the spellchecker in a protected document.

One of the important elements is "NoReset=True". The act of removing and then re-protecting a document will reset the data without this line.



In Office 2007 Protection is found on the Review tab:





See all Topics

Labels: , , ,


<Doug Klippert@ 3:03 AM

Comments: Post a Comment


  Friday, July 24, 2009 – Permalink –

May I Comment on Your Balloon?

Markup stuff


How to turn off balloons for comments and track changes in Word.

This article describes how to turn off the balloons that appear for comments and track changes in the right side margin of your Microsoft Word 2002 or Microsoft Office Word 2003 document.

To turn off or hide the balloons for comments and track changes in the right side margin of a Microsoft Word document, follow these steps:
  1. On the Tools menu, click Options.
  2. On the Track Changes tab, do one of the following:
    • In Word 2003, change the Use Balloons (Print and Web Layout) box to Never.
    • In Word 2002, click to clear the Use Balloons in Print and Web Layout check box.
  3. Click OK to close the Options dialog box.
Note This process only hides the balloons for comments and track changes. These steps do not remove any changes.

Frequently Asked Questions About Comments Using Tracking and Reviewing Features in Microsoft Word 2002/XP Tutorial
In 2007:






See all Topics

Labels: , ,


<Doug Klippert@ 3:29 AM

Comments: Post a Comment


  Wednesday, December 10, 2008 – Permalink –

Background Printing

Yes, you can!


Remember back in the old days of Word before 2003?

We would demonstrate how a background color or theme could be applied to a document. Then say something like, "But you can only see it on the screen."

That changed with 2003 and '07.

Go to Tools>Options.

(Word 2007
Click the Microsoft Office Button, and then click Word Options.On the Display menu, click to select the Print background colors and images check box under Printing Options, and then click OK.)

Go to the Print tab and on the Include with document section,
put a check next to "Background colors and images" and click OK.



Now when you apply Theme formatting it will be printed as well as the text.
(A caveat might be that on a black and white printer, the result can appear muddy)


To apply a theme to a document go to Format>Theme. These are the same themes (colors, graphics and fonts) used in FrontPage.


This Knowledgebase article also offers suggestions on how to get around the problem in Word 2002.
Word 2003 or Word 2002 document that includes a background



See all Topics

Labels: ,


<Doug Klippert@ 3:29 AM

Comments: Post a Comment


  Wednesday, November 19, 2008 – Permalink –

Certificate of Anything

Make your own


Give your kid an award for not setting the house on fire in the last 24 hours.

Make a formal presentation to your dog for scaring away imaginary burglars.

The desktop publishing power of your computer can create official (looking) honors.


Here's a collection of free templates:

Southworth.com
Free Award And Certificate Templates

EducationWorld.com:
Award Certificates

BrainyBetty.com
Certificate Templates
(These are PowerPoint templates)

Office.microsoft.com:
Certificates
(86 Certificates, labels, etc. Word, PowerPoint, and Publisher)



See all Topics

Labels: , ,


<Doug Klippert@ 3:12 AM

Comments: Post a Comment


  Thursday, August 14, 2008 – Permalink –

Sequentially Number Documents

Budget0056.doc


Here's an example of how to use an external text file to record incremental numbering.

"Sometimes, when working on a project, you may want to save your documents in sequential order (for example, "0001", "0002", "0003", and so on).

If you wanted to do this manually, you would need to sort through your working directory for the latest file number before you could assign the next number to a new file.

Using this fairly straightforward Word macro, you can make creating sequenced files as easy as pressing a button."


LogicalExpressions.com:

Save sequential number docs
(Kevin Christy)


Also see:

Autonumber Invoices



See all Topics

Labels: , , , ,


<Doug Klippert@ 4:00 AM

Comments: Post a Comment


  Tuesday, July 08, 2008 – Permalink –

Customize Envelopes

Your own #10


The default layout for envelopes is not sacrosanct to anyone but the postal service.
You can move objects around; add text and pictures.


GMayor.com:
ChangingWord Envelope Layouts
Graham Mayor


PC Magazine.com
Custom Envelopes in Word


Microsoft Support:
Create individual envelopes and labels
40 minute lesson


About.com:
Customizing Envelopes with Pictures

Slipstick.com:
Printing Labels or Envelopes for Contacts
Inserting Addresses into Microsoft Word Documents

"One of the advantages to using Microsoft Exchange or Microsoft Outlook is the ability to use information from the Address Book in Microsoft Word documents. Exactly how to do it, though, isn't obvious. The key is an AutoText entry called AddressLayout. This article shows you how to change this entry and how to add an Insert Address button to the Word toolbar."



From Answers.com:

"USAGE NOTE The word envelope was borrowed into English from French during the early 18th century, and the first syllable acquired the pronunciation (on) as an approximation to the nasalized French pronunciation. Other similar words borrowed from French in the modern period include envoy (17th century), encore, ennui, ensemble, entree (18th century), entourage, and entrepreneur (19th century). Most retain their pseudo-French pronunciations, with the exception of envoy, which, like envelope, is mainly pronounced with (en) now."

USPS.com:
Addressing your mail
Delivery Address
Standard Address Formatting



See all Topics

Labels: ,


<Doug Klippert@ 4:13 AM

Comments: Post a Comment


  Saturday, June 14, 2008 – Permalink –

Address Layout

Custom layout


When you use the Outlook as a source for addresses, you can customize the display to suit your own needs.

When you use the Insert Address button in the Envelopes and Labels dialog box it does not use the same format as the Insert Address button.

Here's the location to put the Address book on the Quick Access Toolbar in 2007:



Here's the work around:
Insert Address Button Does Not Use AddressLayout AutoText Entry

MacroButton; scroll down to Insert Address from Outlook>



Here are two sources with directions about how to reformat the AutoText entry: "AddressLayout".

Slipstick.com
Inserting Addresses into Microsoft Word Documents


Microsoft Knowlegebase:
HOW TO: Modify the Layout of an Address Book Entry



See all Topics

Labels: , , ,


<Doug Klippert@ 7:10 AM

Comments: Post a Comment


  Saturday, March 22, 2008 – Permalink –

Default Save

Choose your own location



When you choose to save most Office files, the Save dialog box defaults to the Documents or My Documents folder.

(The following directions work in 2007, but you need to click on the Office button in the upper left corner of the Window)

Word
you can change the default location by going to Tools>Options. On the "File Locations" tab you can modify the storage location.

Excel
Tools>Options. On the "General" tab change the default location.

PowerPoint
uses Tools>Options and the "Save" tab.

Access
Tools>Options and the "General" tab for Databases and Projects

Publisher
Tools>Options "General".

Outlook
will make you take an underground tour into the Registry to change the location to save e-mail attachments.

FrontPage/Expression Web
appears to require the same sort of spelunking.


Change the folder where e-mail messages and attachments are saved

Also:
D.C. Everest school district Weston, WI:
Office Default Paths

If you don't want to change the default, but would like to be able to quickly go to an alternate site, open the Save or Save Attachment dialog box. On the left side of the box is the Places Navigation bar. If you click the Desktop icon, that location will be used to save the file.

You can add spots to the bar. Browse to the specific folder. Highlight the folder and click the down arrow beside the Tools option. Select "Add to My Places."

The file or e-mail attachment can then be saved where you want.



See all Topics

Labels: ,


<Doug Klippert@ 7:50 AM

Comments: Post a Comment


  Monday, February 25, 2008 – Permalink –

Legacy files from 2007

Go back


Read this article closely. If you work in a situation where you need to work with legacy (pre-2007) files, it may be handy.

If you do most of your work in 2007, I wouldn't bother.


"When you use Windows Explorer or the desktop to create a new 2007 Microsoft Office file, a new Office file is created in an XML file format (.dox or .xlsx). For example, this behavior occurs when you right-click the desktop, you point to New, and then you click Microsoft Office Word Document. By default, files that you create in the 2007 Office system are in XML file formats.

This article is about how to create legacy Office files, such as .doc files, .xls files, .ppt files, or .mdb files in the 2007 Office system. You can create legacy Office files without opening any Office applications. To do this, you must modify some settings. The modified settings will apply to all the users who log on to the computer."

Knowledgebase 935787



See all Topics

Labels:


<Doug Klippert@ 7:51 AM

Comments: Post a Comment


  Tuesday, February 05, 2008 – Permalink –

Curly Quotes be Gone

Stop them up front


Word, by default, uses curly (“ ”) rather than straight quotes(" ").

Here's a video that shows how to go into Word options and turn this Auto feature off.

Next we need to turn off Moe and Larry




Curly quotes



See all Topics

Labels: , , , ,


<Doug Klippert@ 7:27 AM

Comments: Post a Comment


  Wednesday, May 09, 2007 – Permalink –

Footnote Customization

Line it out


In Normal View:
  1. Go to View>Footnotes.

  2. Click the All Footnotes box arrow, and select Footnote Separator from the drop-down list.

  3. Click on the existing separator line and delete it.

  4. Go to Format>Borders And Shading.

  5. On the Borders tab, select the border you want.

  6. Select the color you want.

  7. Click OK.

You will see the new separator line for your footnote will appear in Print Layout or Print Preview.

Also:
Footnote FAQ



See all Topics

Labels: ,


<Doug Klippert@ 6:50 AM

Comments: Post a Comment


  Tuesday, February 06, 2007 – Permalink –

Customize the 2007 Ribbon

Let the add-ins begin


It is said that the Office 2007 Graphical User Interface Ribbon cannot be as easily changed or modified like it has been in previous versions.

This may be partially true, but not all is lost.

Here is some information from the equine's mouth:


Learn how to customize the Ribbon user interface (UI) in the 2007 Microsoft Office release. Also learn how new features in Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System support RAD development of Ribbon customizations. (40 printed pages)

Customizing the Office (2007) Ribbon


Monsieurs MS also have a downloadable spreadsheets with the Control IDs. There are files for 2003 as well.

Lists of Control IDs


2007 Office System Add-In: Icons Gallery



See all Topics

Labels:


<Doug Klippert@ 7:52 AM

Comments: Post a Comment