Articles | Photoshop blog | Photography blog | about me | e-mail

Helen Bradley - MS Office Tips, Tricks and Tutorials

I'm a lifestyle journalist and I've been writing about office productivity software for a long time. Here you'll find handy hints, tips, tricks, techniques and tutorials on using software as diverse as Excel, Word, PowerPoint, Outlook, Access and Publisher from Microsoft and other applications that I love. My publishing credits include PC Magazine, Windows XP mag, CNet, PC User mag, SmallbusinessComputing.com, Winplanet and Sydney Morning Herald.

Tuesday, December 1, 2009

Word 2007 - Add a Date Picker control

Word 2007 has a cool Date Picker control you can use to insert a date into a document.

To insert one into your document first display the Developer tab by selecting the Office button, click Word Options and from the Popular category choose the Show Developer tab in the Ribbon option.

Now click the Developer tab and, in the Controls area you'll find entries for the Building Block Gallery and for elements such as a Date Picker and a Text Box which you can use in your documents.

Select Design Mode, click the Date Picker control to add it and then click Design Mode again to exit that mode.

The user will see a Click here to enter a date option and, when they click the content control, a dropdown date picker will appear allowing them to select a date to insert into the document.

To ensure the date is formatted in a particular way, with Design Mode enabled click the Date Picker and choose Properties from the Ribbon. From the Properties dialog select a date format to use from the list.

You can use content controls like these to create memo and fax cover sheets complete with prompts to your user as to the details required.

Labels: , , , ,

Add to Technorati Favorites

Tuesday, November 24, 2009

Word 2007: Make your own Click and Type controls

Word 2007's new Content Controls let you do some pretty snazzy things in your Word documents.

You will have worked with Word's own controls when you add a cover page or header and footer using the Insert tab options in Word 2007. In this case you may have noticed that, if your document already has a title configured in the document properties, the title appears automatically on the cover page and in the header.

Alternatively, if it doesn't have a title, when you double click the Title area and type one, any other object in the document that includes a title will be updated automatically. This behavior occurs because the document information is inserted using content containers which are linked to the document properties.

You can take advantage of this behavior in your own designs and you can create and use unlinked content containers to prompt for details to be inserted in your own documents.

To see how content containers work you’ll need to display the Developer tab which you can do by selecting the Office button, click Word Options and from the Popular category choose the Show Developer tab in the Ribbon option.

Click the Developer tab and, in the Controls area you'll find entries for the Building Block Gallery and for elements such as a Date Picker and a Text Box which you can use in your documents.

So, for example, to prompt a user to insert an entry from the Quick Part Gallery, click where you want the Quick Part Gallery entry to appear. Click the Developer tab and click the Design Mode button so you are in design mode.

Now click the Building Block Gallery button. This inserts a small content container with the words [Choose a building block] as the prompt. Exit Design Mode by clicking Design Mode button once again and you will see that the document contains a clickable link in this position prompting the user to choose a building block.

In practice, all the user needs to do is to click on the Choose a building block link to show the dropdown list and they can then select the building block to insert at this position in the document.

You can also provide a link that the user clicks on to type custom text. To do this, check you're in Design Mode and select the Text button from the Controls group. Between the markers type the text describing the content to be inserted in this position.

To test this, deselect Design Mode and click the element to see it highlighted and type the text prompted for. The text you type appears in line with regular text in the document and can be formatted by right clicking on the text and apply a format to it.

Note, however, that the entire content control is formatted at the one time and individual letters and words cannot be formatted independently of the others.

Labels: , , ,

Add to Technorati Favorites

Thursday, June 18, 2009

Word 2007 - smart date entry


Word 2007 has some totally cool new tools for entering data in your documents. Trouble is they are hidden so most folks don't know they are there.

To start, display the Developer tab by clicking the Office button > Word Options > Popular > Show Developer tab in the Ribbon.

Now click the Developer tab and, in the Controls area you'll find entries for a range of tools including the Date Picker. To insert the date picker into your document click Design Mode and then click the Date Picker button. Click Design Mode again to exit that mode.

Now your user will see a Click here to enter a date option and, when they click the content control, a dropdown date picker will appear allowing them to select a date to insert into the document.

To ensure the date is formatted in a particular way return to the Developer tab, click Design Mode and click the Date Picker in the document. Click the Properties button on the Ribbon and from the Properties dialog select a date format to use. Make sure to deselect Design Mode before you return to your document.

Labels: , , ,

Add to Technorati Favorites