Monday, November 16, 2015

Kürzungen für jeder

Accessibility Shortcuts


Several resources are available to help increase speed and effectiveness for keyboard users. Here are keyboard shortcuts for leading Microsoft products that help save time and effort and provide an essential tool for some people with mobility impairments.

  • Internet Explorer (11/10/9/8/7/6)
  • Office (2013/2010/2007/2003)
  • PowerPoint
  • Publisher
  • Windows (8/7/Vista/2003/XP/2000)
  • Windows Media Player
Microsoft.com Keyboard Assistance.


See all Topics

Thursday, November 12, 2015

Mail Merge Page Printing

One big page


After completing a merge to a new document, the status bar may indicate that the insertion point is located on page 1 of 38 pages. This is a bit of mis-information.

If you turn on Show/Hide and look at the merged document in Normal view, you'll see that the merged document has section breaks rather than page breaks.

If you try to print what should be Page 1, the entire document will print.

To print just the first section, use "s1" in the Print dialog box.



Another way to handle it is to go to Edit>Replace and replace

"^b" (section break)

With

"^m" (manual page break)



From Office.Microsoft.com:
In the Pages box, type instructions to print one of the following:

Noncontiguous pages

Type the page numbers with commas between them. Type the range of pages with a hyphen between the starting and ending numbers in the range. For example, to print pages 2, 4, 5, 6, and 8, type 2,4-6,8
A range of pages within a section

Type p page number s section number. For example, to print pages 5 through 7 in section 3, type p5s3-p7s3
An entire section

Type s section number. For example, type s3
Noncontiguous sections

Type the section numbers with commas between them. For example, type s3,s5
A range of pages across sections

Type a range of page numbers and the sections that contain them with a hyphen between the starting and ending numbers in the range. For example, type p2s2-p3s5



See all Topics

Wednesday, November 11, 2015

Graphics from the '50s

Remember it the way you want to


Original fifties clipart? Just in time for the holidays, some Ozzie and Harriet style pics.



"Most communities in the fifties had small town print shops that doubled as printers of local news and advertising papers. These printers could not afford graphic artists so they used stock clipart supplied by large companies who distributed common graphics for use in advertising sections of the papers. They were provided for the printer in lots of categories to meet any advertiser's needs."

Retrographix.com


See all Topics

Thursday, November 05, 2015

Merge Pictures

Different picture to every letter in a mail merge



A variation of this technique could also be used with an IF statement to display different pictures based on some criteria, such as Zip code.
  1. Open the Excel worksheet that you use as the mail merge data source.

  2. Insert a new column that has a column heading such as Picture.

  3. For each row of the Excel worksheet, insert in the Picture column the path and the file name of the picture that you want to use for that record of the data source. Additionally, enclose the path and the file name in quotation marks (").

    For example, copy the path and the file name of the picture in Windows Explorer. Then, paste the path and file name into the Excel worksheet.

    Note The path and the file name of each picture in the Picture column will appear similar to the following example:


    "C:\Documents and Settings\username\My Documents\My Pictures\foldername\filename.jpg"

  4. On the Edit menu, click Replace. Then, replace each instance of a single slash mark (\) with double slash marks (\\) in each path.

    For example, each path should now look similar to the following example:

    "C:\\Documents and Settings\\username\\My Documents\\My Pictures\\foldername\\filename.jpg"

  5. Save and then close the Excel worksheet. Then, quit Excel.
In Word, follow these steps:
  1. Open the mail merge main document.

  2. If the Excel data source is not attached, attach the data source. To do this, go to Step 3 of 6 in the Mail Merge task pane. Click Browse, and then attach the Excel data source.

  3. Click Next: Write your letter.

  4. In the mail merge main document, move the insertion point to the location where you want the picture to appear.

  5. On the Insert menu, click Field.

  6. In the Field dialog box, click IncludePicture under Field names, and then click OK.

    Note You may receive the following error message:

    Error! Filename not specified

  7. Press ALT+F9 to display the field codes in the mail merge main document. You will see a field that is similar to the following field:

    { INCLUDEPICTURE \* MERGEFORMAT }

  8. Move the insertion point into the field immediately following INCLUDEPICTURE.

  9. Press the SPACEBAR, and then click More items on the Mail Merge task pane.

  10. In the Insert Merge Field dialog box, click the picture merge field, such as Picture, and then click Insert.

  11. Click Close to close the Insert Merge Field dialog box.

    The INCLUDEPICTURE field should now look similar to the following field:

    { INCLUDEPICTURE { MERGEFIELD "Picture" } \* MERGEFORMAT }

  12. Press ALT+F9 to hide the field codes in the mail merge main


  13. Click Next: Preview your letters.


  14. Click Next: Complete the merge.

  15. In the Mail Merge task pane, click Edit individual letters.

  16. In the Merge to New Document dialog box, click OK.

  17. On the Edit menu in the merged document, click Select All.

  18. Press F9 to update the fields in the merged document.
    (Word mail merges are not dynamic)

  19. To print your letters from the merged document, click Print on the File menu. Each printed letter will contain the picture that you specified in the Excel data source.
Knowledgebase #909132:
Different picture to every letter in a mail merge


See all Topics

Saturday, October 31, 2015

Almost All You Need to Know

Collection of Word explanations



Shauna Kelly is a Microsoft Word MVP.

She has compiled a gathering of important Word how to's and whys.
For new users of Microsoft Word
Basic concepts - Introduction
Styles in Microsoft Word
Tips for understanding styles
Formatting
How the Styles and Formatting pane works
Numbering, Bullets, Headings, Outlines
How to control bullets
Templates
What is the relationship between a Word document and its template?
Layout
How to keep a figure on the same page as its caption
Sharing Microsoft Word documents
What happens when I send my document to someone else?


Making the most of Word in your business:
Microsoft Word FAQ


See all Topics

Saturday, October 24, 2015

Clip Art Gallery

Sprinkle carefully


Judicious use of Clip art can spice up a document. Here's an article about how to customize existing pictures including:
  • Display clip-related toolbars
  • Customizing your clip art
  • Cropping
  • Sizing
  • Adding text wrapping
  • Blurring
  • Rotating and flipping
  • Adding a drop shadow
Edit clip art in Word


 

Halloween clips


See all Topics

Thursday, October 22, 2015

Split View

Top and bottom


If you need to look at more than one part of a document at once, consider splitting the window.

To split the current window, just go to Window>Split from the main menu.
(View>Split in 2007)

Another way is to use the splitter control between the file tab channel and the scroll bar for the doc.



To create new windows for the same document, just go to Window>New Window and create as many views on the same document as you would like. (View>New Window in 2007)


Split Screen Feature - Word 2013


See all Topics

Friday, October 02, 2015

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

Monday, September 28, 2015

Merge Formatting

$ lost


The data in Access or Excel has been formatted. You have leading zeros, percents, currency is formatted and so on.

Word 2000+, however loses the formatting when a mail merge is attempted.

Here's a fix.

Word has three potential data access methods, the "old fashioned" ODBC or DDE and the newer OLE DB.

ODBC and OLE DB can, quickly, extract data from a source application without opening the program. The application does not even have to be installed.

The downside is that these methods do not transfer the formatting in the data file. Individual MERGEFIELDs need to be formatted in Word.

DDE can be used with Excel and Access. It communicates with the source and carries the formatting into the target document. This is how it worked before Word 2002.

To have a choice go to:
Tools>Options>General "Confirm Conversions at Open"

When you connect to the Data Source, a dialog box will give you the opportunity to choose the type of connection to use.


If you don't see DDE, check Show all.
Also see:

Cindy Meister:
Mail Merge FAQ

Here are some other Mail Merge resources:
Mail Merge Links


See all Topics

Monday, September 14, 2015

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


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


See all Topics

Monday, September 07, 2015

WordPerfect?

Word!


I used to ask "How many have ever used WordPerfect?" Over the years it has gone from about 50% to blank stares.

WordPerfect (WP) couldn't bring itself to accept the existence of Windows, and Microsoft ran past, taking over the market.

Word is Object-Oriented, WordPerfect is Stream-Formatted.
"What does this mean? Well, this basically means that when you make a change to a WordPerfect document, the changes take effect 'From THAT Point Forward'. You generally don't need to select an Object (e.g., a word, sentence, or a paragraph) in order to effect a change. You can simply select a color, a font, a paragraph style, etc, and the whole document will be affected (as stated, from that point forward). Stream Formatted is, as you can imagine, like a stream of formatting that flows throughout the document.

Word, on the other hand, is object-oriented. Every letter, word, sentence, and paragraph is an object. To help people grasp the concept of object-oriented programming, Microsoft uses a simple analogy: oranges. You can imagine that an orange has several attributes that can be changed: it has a color, a texture, etc. It can be changed by being painted or peeled. Therefore, once you understand that you need to select an object when you want to manipulate your Word document, you begin to understand how to work in Word."

WP vs. Word

WP is still around. Mostly used in the legal profession by those who still bemoan the loss of powdered wigs.

Here are some references:

The history of WordPerfect:
Almost Perfect
(a book by W. E. Peterson)

Wikipedia:
WordPerfect


See all Topics

Sunday, August 30, 2015

Too Many Slices

More data than the pie will hold


A pie chart displays the per cent of the whole is represented by the component elements. Four salesmen, four slices of pie.

The problem arises when there are 10 or so components that vary in size. The labels begin to overlap and the chart is difficult to read:


One suggestion that Chris Weber offers is to rearrange the order of the slices:


The article uses MS Graph in Access, but the techniques are applicable in all the other applications that can use graphs.

SmartAccess:
Easy as Pie. . .

"Chris Weber provides you with a generic method to control the data for pie charts that are actually readable."

(A downloadable example file is also provided


See all Topics

Friday, August 28, 2015

Redact That!

Redact that!

Weapon of Mass Obfuscation


"Redaction is the careful editing of a document to remove confidential information.

The Microsoft Office Word 2003 Redaction Add-in makes it easy for you to mark sections of a document for redaction. You can then redact the document so that the sections you specified are blacked out. You can either print the redacted document or use it electronically.

Sensitive government documents, confidential legal documents, insurance contracts, and other sensitive documents are often redacted before being made available to the public. With the Word 2003+ Redaction Add-in, users of Microsoft Office Word 2003+ now have an effective, user-friendly tool to help them redact confidential text in Word documents."

The redacted document can be protected and saved. The add-in creates a copy of the original, so original material is still available.



Hide Information:
OfficeWatch.com

Word 2003 Redaction download


Word 2007 Redaction Tool


See all Topics

Friday, August 21, 2015

Wildcards

Seek and find


When you are looking for a particular word or file, wildcards can be used to refine the search.

An asterisk (*) can be used to represent any number of characters. A search for pop* would return popsicle, popcorn, pop1, pop2, pop37, pop29, and pop's favorite chair.

A question mark (?) is a stand-in for a single character. Popc??? would bring back only the word popcorn. Pop? searches for pop1 and pop2, but not pop37 etc.

That's a simple look at wildcards. Word has a rich variety of symbols that can do quite complex search and replace operations.

Here are some links to more detailed discussions:

Word MVP:
Using Wildcards

Felgall Pty Ltd:
Sydney, AustraliaWildcard information

Graham Mayor:
Find and Replace


See all Topics

Tuesday, August 11, 2015

Custom Dictionary

Spell it the way you want to!


Although Office has its own dictionary, it probably does not contain all the words and jargon that you use. If this is the case, you can add your own frequently used terms, and names to the dictionary.
  1. Open Word
  2. From the Tools menu, click Options
    (See link below for 2007)
  3. Select the Spelling and Grammar tab
  4. Click the Custom Dictionaries button
  5. Place a check beside the dictionary you want to modify
  6. Click the Modify button
  7. In the Word field, type in the word you want to add to the dictionary and click the Add button Click OK
  8. Click OK to close the Custom Dictionaries dialog box
  9. Click OK to close the Options dialog box
If you want to remove a word from the dictionary, complete steps 1 through 7. Select the word you want to remove and click the Delete button.
The Custom.dic file is a text file. You can create it or edit it using notepad.
Multiple dictionaries can be created for special purposes, like a list of employee names.
The Custom.dic file is used by all of the Office applications that do Spell checking.
How to add a custom dictionary in Word

About.com: Working With Dictionaries in Word

Microsoft.com How to create an exclude dictionary in Word

Copy the Custom Dictionary to a Floppy Disk and Use It on Other Computers

Error when you add a word to the custom dictionary


See all Topics

Tuesday, July 21, 2015

List All Files

All files in a folder


Here is a macro that will produce a list of all the files in a selected folder.
  • The folder name for the listed files
  • The file names of the files found
  • The file sizes of the files found
  • The dates and times of the files found
  • The total number of files listed
Macro to List All Files in a Folder


See all Topics

Wednesday, July 15, 2015

Free Photos

and other graphics


Robin Good has compiled a list of places that provide royalty free images.
" Finding quality images and photos for complementing an important article, essay or news report is already quite a challenge for many. Imagine when the goal is not just too find good images, but find some that you could openly and freely use without needing to pay royalties or one-time publishing rights to someone."

Free Photographs and Other Visuals

A dozen sources are listed including:
PD Photo.org
"PDPhoto.org is a repository for free public domain photos. Unless something is clearly marked as being copyrighted, you can assume it is free to use. But if you intend to use an image you find here for commercial use, please be aware that standards for such use are higher. Specifically, you should assume no model release was obtained. And pictures featuring products or property should be used with care. The photos are here to be used, but I don't want you to get either of us in trouble over it."



Copyright Information


See all Topics

Monday, July 13, 2015

Microsoft Word 2007-2013 Tutorials

How it's done


Microsoft Office Online:
"It's time to get up to speed with Microsoft Office Word 2013. Learn the best ways to use the new Ribbon, get a handle on finding popular commands, and understand what the new file format does for you."

Microsoft Word 2013 Tutorial

Word 2010 for 2003 Upgraders

Also:

BayconGroup.com:

Microsoft Word 2007 Tutorial


See all Topics

Sunday, July 05, 2015

Word Form or Content

Shape or substance



"The legibility of a typeface should not be evaluated on its ability to generate a good word shape.

Word shape is no longer a viable model of word recognition. The bulk of scientific evidence says that we recognize a word's component letters, then use that visual information to recognize a word. In addition to perceptual information, we also use contextual information to help recognize words during ordinary reading, but that has no bearing on the word shape versus parallel letter recognition debate. "

The science of word recognition
by Kevin Larson
From EyeMagazine
Suggested by:
Microsoft Typography

Also see:
Cmabrigde


See all Topics