Tuesday, April 17, 2018

Do You Like Type

Or do you love it?


Fonts have traits, character, even spirit. Wichita University ran a psychological study on how people "feel" about typefaces.


" This study sought to determine if certain personalities and uses are associated with various fonts. Using an online survey, participants rated the personality of 20 fonts using 15 adjective pairs. In addition, participants viewed the same 20 fonts and selected which uses were most appropriate.

Results suggested that personality traits are indeed attributed to fonts based on their design family (Serif, Sans-Serif, Modern, Monospace, Script/Funny) and are associated with appropriate uses.

Implications of these results to the design of online materials and websites are discussed."


Personality of Fonts




For instance when it came to business documents, 78.2% chose Times New Roman, 75.6 thought Cambria was appropriate, while only 5.3% wanted their attorney to use Gigi.


See all Topics

Saturday, April 14, 2018

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


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

Monday, April 09, 2018

Plain Language

Twaddle free




THE WHITE HOUSE
June 1, 1998

MEMORANDUM FOR THE HEADS OF EXECUTIVE DEPARTMENTS AND AGENCIES

SUBJECT: Plain Language in Government Writing
"The Federal Government's writing must be in plain language. By using plain language, we send a clear message about what the Government is doing, what it requires, and what services it offers. Plain language saves the Government and the private sector time, effort, and money."

The Plain English Network
Plain language can be understood by YOUR reader at first reading. It doesn't mean writing for a certain grade level - it means organizing and writing for your reader. Writing in plain language saves time and money for writers and readers.

Introducing Plain Language

Plain language matches the needs of the reader with your needs as a writer, resulting in effective and efficient communication. It is effective because the reader can understand the message. It is efficient because the reader can read and understand the message the first time.

Also:
LegalWriting.net
Plain language produces clear, concise, and readable documents


And then for no reason ,other than most writing is twaddle, here's a review of:

How Mumbo-jumbo Conquered the World:
A Short History of Modern Delusions
by Francis Wheen.




It's entitled: "Twaddle unswaddled".
Appropriate or not, it is fun to say.


See all Topics

Monday, April 02, 2018

Labels by Merging

Demos


As part of their series of demos, Microsoft has information on creating mailing labels from a database, or mailing list.

Create labels with mail merge

Here is another entry concerning some of the fine points.

More label info

Also, if you place a graphic in the first cell, it will be duplicated in each box.


See all Topics

Thursday, March 29, 2018

Index Concordance

Order!


Creating a Table of Contents can be easy if you use Styles. Word will automatically insert a TOC when you place the insertion point and then use Insert>Reference Index and Tables and choose Table of Contents.
(2007+  Reference Tab>Table of Contents group)

An Index or Concordance can be more difficult.

In a larger document, you may want the reader to be able to locate key words. You could go through the whole document and mark each word you want included, but there is an easier way.
  1. Make a list of the important words.
  2. Create a two-column table in a new document.
  3. In the first column, enter the word or phrase.
  4. In the second column, enter the index entry
    (If you need a sub-category, type the main entry followed by a colon (:) and then the sub category.)
  5. Save the file.
When it comes time to create the Index, place the insertion point, go to Insert>Reference Index and Tables. Choose Index and then AutoMark. (2007 – Reference Tab>Index group) Browse to the location of your Index file. Word will now automatically use your list to mark the main document and insert an Index.

Also: Word for Word:
An Index or a Concordance for Your Book?
Microsoft KB:
How to create a table of contents and index with field codes in Word


See all Topics

Monday, March 26, 2018

Publisher Merges

Not just Word


You know that you can send e-mail merges using Word. Try it with Publisher.

Design a newsletter and let it rip.




Merge Publisher


See all Topics

Friday, March 23, 2018

Troubleshoot Word

Problem solvers



If you have trouble opening a Word document, or it is not working well, try these suggestions:

FIRST
Delete all of Word's temp files.
  1. Go to Edit>Replace
  2. Make sure to include all of your local drives in the search and that "include subfolders" is checked.
  3. Search for:
    *.tmp
  4. Then delete all these temp files.
Word leaves shards of temp files wherever the document file was stored. Word's temp files start with a tilde (~), so in most cases you can delete: ~*.* SECOND
  1. Use Edit>Find to locate Normal.DOT.
  2. Rename it (Normal.OLD) or delete it. Word will create a new copy when it restarts.
The only caveat here is be careful that you don't have important macros stored in Normal.DOT. If you rename, you can recover them. THIRD
If that does not correct the problem, try this next step:
  1. Go to Start>Run and type:
    winword.exe /a
    (Note that there is a space before the /a)
  2. Then press ENTER. This starts Word without any add-ins, global templates, or Normal.DOT.
    Look in Tools>Templates and Add-ins to see if there are any files that can be un-checked.
If you need even more help, go to: 
Knowledge base:

 How to troubleshoot problems that occur when you start Word or when you work in Word


See all Topics

Thursday, March 22, 2018

VBA Named Arguments

An easier read


Use named arguments for cleaner VBA code.

Most likely, you use positional arguments when working with VBA functions. For instance, to create a message box, you probably use a statement that adheres to the following syntax:

MsgBox(prompt[, buttons] [, title] [, helpfile, context])


When you work the MsgBox function this way, the order of the arguments can't be changed.

Therefore, if you want to skip an optional argument that's between two arguments you're defining, you need to include a blank argument, such as:
MsgBox "Hello World!", , "My Message Box"


Named arguments allow you to create more descriptive code and define arguments in any order you wish. To use named arguments, simply type the argument name, followed by :=, and then the argument value.

For instance, the previous statement can be rewritten as:

MsgBox Title:="My Message Box", _
Prompt:="Hello World!"


(To find out a function's named arguments, select the function in your code and press [F1].)


See all Topics

Saturday, March 17, 2018

Word Math

An Add-in, of course


Microsoft has a downloadable add-in for Word called Microsoft Math.

"To use the add-in, open Word 2007+, type Alt-= to create a RichEdit math object, type an equation or expression, and right-click on the equation to see options for solving and graphing within Word."

Math Add-in


See all Topics

Wednesday, March 14, 2018

Merge to More Than One Document

Custom content



In the Data Source, include a field for the type of letter the recipient requires.

In the Main merge document, enter IF fields, such as:

{IF {MERGEFIELD "LetterType"=1} {INCLUDETEXT "C:\\Project\\Letter1" \* MERGEFORMAT} ""}
{IF {MERGEFIELD "LetterType"=2} {INCLUDETEXT "C:\\Project\\Letter2" \* MERGEFORMAT} ""}


  • The curly brackets { } cannot be entered from the key board. Either use Insert>Field, or Ctrl+F9.
  • Word uses spaces in the If..Then..Else statement.
  • The last two quote marks "" are "empty" , so nothing will be entered.
  • Notice the \\ in the path statement. A path is not needed if the Main document is in the same folder as the letters.
  • To see the field codes, use Alt+F9 to toggle the view on and off.
Letters 1 and 2 can have completely different texts, formats and layouts. One can be an invitation to a sale, the other can be a dunning letter. (To carry over different formatting, leave out the \* MERGEFORMAT switch)

After setting up the main document for mail merging, insert all of the fields you want to merge.

Copy the individual fields and paste them in the correct locations in Letter 1 and 2.

Go back to the main document and erase all of the text and fields EXCEPT for the IF statements.

Letters 1 and 2 do not have to be set up a merge docs, or connected to a data source. Their text will be inserted in the Main document depending on the field type.


See all Topics

Friday, March 09, 2018

Curly Quotes be gone

Stop them up front


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

Here's an article 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

Friday, February 23, 2018

Migrate to Word +++

Move the parts.


If you've been having trouble with converting to Word 2007+, this might help.

This topic discusses migration considerations for Microsoft Office Word 2007+, including:

  • Migrating files to the new file format

  • Migrating AutoText entries

  • Migrating customizations

  • Migrating Add-ins

  • Migrating AutoCorrect entries

  • Migrating the data key
Microsoft - Migration considerations

Changes in Office 2013

Changes to Office 2016



See all Topics

Saturday, February 17, 2018

Font Lister

A look see


I haven't seen, lately, how many fonts you can have on a machine, but I know it's a lot more than earlier versions.

Here is a free download that will create an HTML file that will show all the fonts installed on your computer.

"Using FontList, you can change the predefined sample text, exclude seldom used fonts from the list and change the path for the HTML file.

In your browser, you can change the style of a font and zoom in on a font. You can also view the character map of a font. And, for some, maybe the most important feature, you can create a print out of all your fonts.




FontList


See all Topics

Thursday, February 15, 2018

Match Format Paste

Copy/Paste formatting in Word, PowerPoint or Excel



When you copy information from a Web page or another document, the formatting will also be copied.

To match the formatting of the target document, copy the text and place the cursor where you want to insert the copy.

Then, go to Edit>Paste Special, and select the Unformatted Text option.
(Click the arrow under Paste in the Clipboard group on the Home tab in 2007+)

The clipboard text will be pasted to match the target.

Another way when using Word 2002 + is to click on the "Smart icon" that appears at
the lower right corner of the pasted text. You can then choose to keep the original formatting, match the destination formatting, keep text only, or apply a new style.

An additional way to transfer just the formatting between documents is to highlight the text with the formatting you wish to copy and then hold down the Ctrl key and the Shift key and press the C key (Ctrl+Shift+C). Release the keys. Select the text you want to have formatted. Hold down the Ctrl key and the Shift key and press the V key (Ctrl+Shift+V). Only the formatting is copied, not the text.
In Excel use Edit>Paste Special and select the "Formats" option.


What's So Special About "Paste Special"? Video

Paste Special can also be used with graphics.

You can change Word's default behavior; choose whether to paste Inline or Floating.

Microsoft Word MVPS FAQ


See all Topics

Wednesday, January 31, 2018

Page Breaks

Demo tutorial


You can control when Word decides to break for a new page.
Ctrl+Enter is the keyboard shortcut, but there are a number of variations.

This MS link has both Demos and text tutorials.
Page breaks

BTW, a merged document is made up of Section breaks, not Page breaks.

For ease of printing, Replace ^b with ^m


See all Topics

Monday, January 29, 2018

Word News (Still)

Here's another good newsletter



Editorium
Jack M. Lyon, a book editor who got tired of working the hard way and started creating programs to automate editing tasks in Microsoft Word. He's been editing more than twenty years and started working on the computer in 1985.
(Unfortunately has not published recently, but still full of good information)


A few back issues of Editorium Update arranged chronologically:

  • Deleting Unused Styles
  • Pasting Tracked Revisions
  • Indexing with a Two-Column Concordance
  • Fancy Sorting
  • Editing by Concordance
  • Making a Concordance
  • Numbers by Chicago
  • Fixing Typos Automatically
And more.


See all Topics

Tuesday, January 23, 2018

Office VBA Tips

Video + Free code


"Learn tips and use sample code for several Office applications. These tips can help you to be more productive and can also be a starting point for developing your own tools, utilities and techniques."
  • Update Word Document Statistics in the Title Bar
  • Create Outlook Rules Programmatically
  • Delete Repeated Text Throughout a Word Document
  • Run Macros Based on the Value of One or More Excel Spreadsheet Cells
  • Disable Related Controls on a PowerPoint Slide After a User Clicks an Input Control
  • Display Reminder Information When a User Opens an Office Document
  • Synchronize an Access Main Form to a Subform and Vice Versa
  • Log Worksheet Changes to an XML File
  • Merge Body Text from Multiple Outlook E-mail Messages to a Word Document
  • Use the Office Assistant as an Alternative to Displaying and Retrieving User Input
Ten Tips for Office VBA Developers

VBA Tips & Tricks

Getting Started with VBA in Office 2010

Download Office 2013 VBA Documentation


(VBA is VBA and is, in most cases, usable in all versions of Office)


See all Topics

Tuesday, January 16, 2018

Drawing Canvas

More than I want


The Draw layer has been around since about Word 97, but it has not been as intrusive as it is in Word 2002+.

Try to place an AutoShape on a page and the Drawing Canvas pops up by default.

To turn off this feature, go to:
Tools>Options.
On the General tab, remove the check mark from
"Automatically create drawing canvas when inserting AutoShapes"

To just dismiss it each time, choose your AutoShape and then touch the Delete or Esc key before drawing the object.

Here's some more information.


Knowledge Base
General Information About Floating Objects
(a discussion of Word's floating objects and layers)

As I understand it, the Drawing canvas is not really a new layer. The following illustration shows the classic layers. It is from the Knowledge base article:
How to Place Text over a Graphic


___________________
/                   /
/   <SURFACE OF     /
/       PAPER>      /
/                   /  /
Front drawing layer  -------------------  /
MAIN TEXT LAYER  =================== / /
Back drawing layer  -------------------/ / /
/ /
Front drawing layer  -------------------/ /
(Header/footer) BOTTOM TEXT LAYER  =================== /
Back drawing layer  -------------------/



You can dump the layer in 2007 in the Office button Word Option equivalent of Tools>Options:



Smart Art 2013


See all Topics

Sunday, January 14, 2018

Keyboard ALT Codes

Quick inserts


Here is a collection of Alt codes. There is also a free download that you can post near your computer.

  • Alt Codes for Letters with Accents for Languages
  • Alt Codes for Bullets, Symbols and Other Special Characters
  • Alt Codes for Mathematical Symbols - Symbols used in Mathematics
  • Alt Codes for Currency Symbols
  • Alt Codes for Drawing
  • Alt Codes for Characters from the Greek Alphabet
  • Alt Codes for "Additional" Letters particularly for Nordic / Scandanavian Languages
  • Alt Codes for Spanish
  • Intellectual Property Right symbols.
  • Alt Codes for Arrows
  • Alt Codes for Punctuation and Editing
  • Alt Codes in Computer Programming
Alt Codes


See all Topics

Friday, December 29, 2017

Word to PP

Send outline to PowerPoint


That old 2003 version allowed you to send a Word file to PowerPoint and have it create a slide show.

After styling with Heading 1, 2, etc, go toFile > Send To > Microsoft Office PowerPoint.

2007+ is a little different (duh!)

For Microsoft Office 2007+

Word 2007+ doesn't allow you to publish to PowerPoint 2007 by default.

Here's the solution:

After you are done in Word 2007+, save it as a Word document.

Now open PowerPoint 2007+.

Click on the Office Button at the top left hand corner.

Click Open.

Under Files of type, select All Outlines.

Now select the Word document and click Open.

Alternately,

In Word 2007+, right click on the ribbon.

Select Customize Quick Access Toolbar.

Under "Choose commands from:", select Commands not in the ribbon.

Look for "Send to Microsoft Office PowerPoint".

Click OK.

The command will then be added onto the Quick Access Toolbar (QAT).



Word to PowerPoint

Word 2010 to PP 2010


See all Topics

Monday, December 18, 2017

Single Space +

2007+ gives you more than you ask for


This quote from The Microsoft Office Word Team's Blog explains their thinking behind making line spacing "looser" in 2007 than it was earlier.


"(A) lesson here for me is that lots of people seem to think of Word as a typewriter (remember typewriters?). There are many examples of this, in the way people construct a table of contents for their Word documents, use the TAB key to align columns, and the way they always hit ENTER twice after typing each paragraph (for those who are fans of extra space between paragraphs).

Many, many of the feedback comments on the line-spacing issue had to do with wanting "single spacing." But, of course the line spacing in the new template is single spacing. It's just that it's a little bit "more" than single spacing used to be: 1.15, instead of 1.0.

But what is 1.0? You might think that if you're using an 11-point font that line spacing of 1.0 would be 11 points. But if you lay out paragraphs that way - depending on the font you're using - the parts that stick below one line will crash into the parts that stick up from the line below. You need to allow some extra space between lines.

In a former life when I set type on a Compugraphic phototypesetting machine, the convention we used was about 20% extra space, so we'd set 10-point type on a 12-point line. Larger fonts demanded more breathing room. This was at a newspaper, so we spaced things a bit tighter than you'd expect to see in, say, a report or a brochure (or, dare I say a professional looking document).

What does single spacing really mean anyway?



How to fix it:
Default line spacing in Word 2007 differ from earlier versions of Word


See all Topics

Wednesday, December 13, 2017

2003-07-10-13 Compatbility

Exchange the future and the past


"Microsoft has added new file formats to Microsoft Office Word, Excel, and PowerPoint 2007+. To help ensure that you can exchange documents between Microsoft Office releases, Microsoft has developed a Compatibility Pack for the Office Word, Office Excel, and Office PowerPoint 2007+ File Formats"

Use earlier versions of Excel, PowerPoint, and Word to open and save files from 2007-13 Office programs

Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint


See all Topics

Tuesday, December 12, 2017

Tab Leaders

You can lead a tab to ...........


Setting Tab Leaders in Word

Fred Smith.........................$44.59

This makes your list easier to read

  1. Select the line on which you want to create a tab

  2. Click on the Format menu and click on the Tabs menu item
    (you will see the Tabs dialog box)

  3. In the Tab Stop Position field enter the distance to the last column: 5", 6" or what ever is appropriate

  4. Then select the tab alignment; Decimal, Right, Center or Left

  5. Select the type of leader to use

  6. Click Set and then OK
Enter the name, or first entry, and then touch the Tab key. Word will automatically enter as many leading characters as required. When you can type the amount, it will be aligned on the decimal or any other alignment you might have chosen.
Here's what it looks like in Word 2007+:



Also:

About.com:
Creating Tab Leader Lines


See all Topics

Tuesday, December 05, 2017

Send Access t Word

Reformat reports


Not everyone has Access installed on his or her machine.
Access is not the most versatile instrument for complex formatting.

If you wish to share your findings, Access does have the ability to re-format Reports into Word documents.

Open the Report in Access and go to Tools>Office Links.
One of the choices is to "Publish It with Microsoft Word."
Here's the command in 2007+:



When the data is sent to Word, you will be asked to confirm that you wish to convert the file to "Rich Text Format (RTF)" Click OK.

(RTF is a "universal" format. The Report can be re-saved as a Word "DOC" or "DOCX" file.)

Microsoft KB:
How to send the current record to Word with automation


Use a table or query as a mail-merge data source (2007+)


See all Topics

Sunday, December 03, 2017

First Look at Word 2010-2013

We all have to start somewhere


Here is a 30 minute course:

After completing this course you will be able to:

  • Create and save a document.
  • Accept or reject suggested revisions for spelling and grammar as you type.
  • Change page margins.
  • Adjust spacing by deleting any extra spaces between words or extra lines between paragraphs.
Create your first document in Word

First look at Word 2010

First Look at Word 2013


See all Topics

Thursday, November 30, 2017

Function Toolbar

F what?



In Word 2007+, you can see the shortcut keys by pressing the ALT key.

Word (2002-2003) has a rarely seen "toolbar" that lets you use your mouse to perform function key actions. In addition, when you press Shift you'll see what the Shift + function key combinations do, press Ctrl and you'll see those shortcuts, and so on.

The toolbar is automatically placed at the bottom of the screen (underneath the document area; right above the status bar); like any toolbar, you can drag it and dock to it any side of the screen, or let it float. To display the Function Key Display toolbar:

  1. Go to Tools>Customize.
  2. Select the Toolbars tab, then check Function Key Display
  3. Click the Close button.
Press the Ctrl, Alt, or Shift keys to see the toolbar buttons (shortcut hints) change. Click on the buttons and the appropriate action will be performed.

See:
Allen Wyatt's Word Tips


See all Topics

Friday, November 24, 2017

Foxy or Ipsum

=rand(p,s)


In Word 2007+, =rand() produces a selection from the Help file.

=lorem() displays:


Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Maecenas porttitor congue massa. Fusce posuere, magna sed pulvinar ultricies, purus lectus malesuada libero, sit amet commodo magna eros quis urna.
Nunc viverra imperdiet enim. Fusce est. Vivamus a tellus.
Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Proin pharetra nonummy pede. Mauris et orci.


If you want some history, try Lipsum.com



Pre 2007:

To insert practice text in the document, type:
=rand()
and hit the ENTER key.

The whole equation would be:
=rand(p,s)
"p"is for p>aragraphs. "s" is for s>entences.

=rand(2,3)
would produce 2 paragraphs containing 3 sentences each.


It is said that:

The Italian edition of Microsoft Word 2000 produces:
"Cantami o Diva del pelide Achille l'ira funesta."

This is the first line of the Italian translation of Homer's Iliad.

In Spanish it's:
"El veloz murciélago hindú comía feliz cardillo y kiwi."

"The quick Hindu bat ate happy golden thistle and kiwi."

In French it's:
"Servez à ce monsieur une bière et des kiwis."

"Serve this gentleman a beer and some kiwis."

Other Panagrams

Choose Your Ipsum


See all Topics

Saturday, November 18, 2017

Task Panes

VBA at your own risk



From the MVPS.org site:

Word's Task Panes VBA Reference
The Mother of All Task Pane articles
By Steve Hudson

"Task Panes display within a Work Pane's area. A Work Pane is created by the combination of two objects. These objects are shrouded in misery and thwart most attempts to play with them. The whole area is hidden away from the Kill Cursor invoked with CTRL+ALT+-, which changes to a hand when waved over a Work Pane.
Functions are hidden away from the macro recorder. To make it easier, if it is not in this reference, it is hidden. It is like when a spy is caught and the government disavows all knowledge of their actions.
The Task Panes are spies from Microsoft that are known to only a few objects, in these versions of Office anyway.

Warning
The author gleefully notes at this point that the human race has enough intelligence to get itself into cauldrons of boiling water that it cannot climb out of and that means you and me both!
If you like to be ultra-safe, stay away from this reference and wait for MS to hand over full functionality. You will end up crashing Word many times and you can really damage your user interface."

(Ctrl+Alt+-, can be used to remove an item from a menu. Type the shortcut and then click on a menu item)


See all Topics

Tuesday, November 14, 2017

Some Issues in Word

A collection of hows


Here are a few:




See all Topics

Thursday, November 09, 2017

Compare — Combine

Changes in '07


For a number of reasons, including collaboration, documents need to be reconciled. A resultant or master document must be distilled from different versions.

Here are some directions:

Compare - Combine

Comparing and Combining Documents

Back in the old days of 2003, you could save "versions" of documents. That's gone:
Bye-Bye Versions


See all Topics

Friday, October 27, 2017

Resume Writing

Get a Job



There are a number of templates installed in Word that will help in creating a good looking resume.
Get started on your job hunt with Word templates

Here are some suggestions about what a resume should look like:

About.com
Resume and Cover Letter Guide

The Riley Guide:
Prepare Your Resume for Emailing or Posting on the Internet


Want to work for Microsoft?

Microsoft's Zoe Goldring and Gretchen Ledgard:
What is it like to interview at Microsoft?

Chris Sells:
Interviewing at Microsoft

Blog:
Technical Careers@Microsoft


See all Topics