Tuesday, November 3rd, 2009
In the past Microsoft Word included the AutoText and AutoCorrect features and, like many users, you may have adapted AutoCorrect to use in creating boilerplate documents.
Some other users tweaked the AutoText tool so they could use it to insert content, such as graphics and text.
The AutoText tool no longer appears in Word 2007 and it has been replaced by a Quick Parts Gallery which makes saving, organizing and assembling documents from stored paragraphs, aka Building Blocks, much easier to achieve.
Find the Quick Parts tool on the Insert tab and click the down pointing arrow to open the Quick Parts Gallery.
Here you have a number of options including Document Property which lets you insert some of the common document properties into your document by clicking on the one to insert.
The Field option lets you insert fields much as you could in earlier versions of Microsoft Word.
The Building Blocks Organizer is the newest feature and this is a repository of text blocks which you can add to your Word documents. These Building Blocks can be sorted by Name, Gallery or Category. Some of the Building Blocks come built-in to Microsoft Word and others are legacy AutoText entries from earlier installations of Microsoft Word.
You can insert a Building Block into a document by selecting the entry in the list and click Insert.
Thursday, October 29th, 2009
Or you might need a blank calendar so you can print blank pages to complete by hand.
So, when you need a blank calendar you can easily create one in Outlook. Choose File > New > Folder and give your folder the name you wan to use for your calendar.
From the Folder Contains list choose Calendar Items, from the ‘Select where to place the folder’ list choose Calendar, and click OK.
Click the Calendar option to display your calendars and, in the list, your new calendar’s name will appear.
You can click its checkbox to display it. If there is already one calendar visible, clicking its checkbox will display both calendars side by side or in overlay mode.
To change the display, right click the Calendar tab and choose either, View In Side-by-Side mode or View in Overlay mode.
Friday, October 23rd, 2009
To find and remove duplicates from a list of data in Excel 2007 first format the area as a table by selecting it and, from the Home tab, choose Format as Table.
Click on any cell in the table and choose Table Tools > Design tab on the Ribbon.
Select Remove Duplicates to display the Remove Duplicates dialog. In this dialog are the Column headings for your data and all are selected by default. To remove the duplicate data from your worksheet leave all the column headings selected and click Ok.
If you want to remove rows where only certain data matches, leave the column headings for those particular rows selected and deselect the column headings for those columns which may have data that differs from one row to another. Now click Ok.
It is sensible to save your worksheet before running this Remove Duplicates option just in case you delete data by accident. If this happens and if you haven’t closed the file, you can recover it using the Undo button.
If you are using an earlier version of Excel, here are links to earlier relevant posts:
Excel – finding duplicates
Check for duplicates in an Excel list
Thursday, October 15th, 2009
When an Outlook appointment falls due, by default, Outlook is set up to do something to tell you about it. Exactly what it does depends on how it is setup.
To change the default settings for all new appointments choose Tools > Options > Preferences tab and, in the Calendar area, enable the Default reminder checkbox and set up the amount of time before an appointment that you will receive a warning about it. 15 minutes is the default but, if you prefer it to be 30, for example, then set it to this.
Choose the Other tab > Advanced Options > Reminder Options to set other options such as whether the reminder is displayed by default and whether a sound will be played and, if so, the WAV file that sounds.
Saturday, October 10th, 2009
To add your own text to the Quick Parts gallery, type the paragraph or open a document which contains it and select it.
Click the Quick Parts button and choose Save Selection to Quick Part Gallery and, when the Create New Building Block dialog appears, type a name for the Building Block.
This will be the name you’ll use to identify it in the list so make it self-explanatory of what the Quick Part contains.
Select the Gallery to add it to, in most cases this will be the Quick Parts Gallery.
Select a Category from the list or click the Create New Category option to create your own subcategory of the Quick Parts Gallery. By creating sub categories you can organize your Quick Part entries so that they are easier to find.
Type a description of the Quick Part, if one is needed to identify it, and, from the Save In list, choose buildingblocks.dotx which is the default setting.
From the options dropdown list you can select to Insert Content Only, or insert the content in its own paragraph or its own page depending on how the content should be used. Click Ok when you are done.
In future you can insert the Quick Part into a document by clicking the Quick Part button and then select it from the dropdown list.
If it does not appear in the list, click the Building Blocks Organizer and select the Building Block by name.
You can locate building blocks in the organizer by sorting on the Gallery column and locate the Quick Part area which is where your building blocks will appear. Click the one to insert and click Insert.
Tuesday, October 6th, 2009
When you are setting up meeting dates in Outlook 2007 and earlier, you can use what is called “natural language” to specify the date.
For example type ‘Friday week’, ‘this Saturday’, ‘Christmas Day’ or even ‘second Monday in December’ and Outlook understands what you mean and sets the appointment date to suit your needs.
This saves you having to know the numerical date or clicking open the calendar especially if you have meetings that are scheduled by the week day rather than by date.
Tuesday, October 6th, 2009
In past versions of PowerPoint each slide could have only one text placeholder that would behave as a PowerPoint text placeholder – you could add text boxes but the text couldn’t be formatted in them the same way as it could when you used a placeholder. Now you can have multiple text placeholders on a slide.
To see these at work, choose View > Slide Master to move to the Slide Master View and then click the Slide Master tab at the left of the Ribbon.
Select the master that you want to add an additional placeholder to and select Insert Placeholder from the ribbon.
From the list, select the type of placeholder to use – these include placeholders for text, picture, chart, table, SmartArt, media and clipart. You can, if desired, add multiples of these placeholders to a slide so you can have a slide layout that has all the elements on it that you need.
For example, you may wish to have a text placeholder next to a chart or text and a picture located side by side. Each placeholder can be sized and positioned anywhere on the slide.
Thursday, October 1st, 2009
So, while I need to use their full name in their contacts entry in my Contacts list, I’d prefer to see them shown using their nickname so I recognize it better.
To do this, I’ll open the person’s entry in my contacts list and, in the ‘File as’ area type their nickname and choose Save and Close.
Now, whenever I look for their entry in the list, they’re filed by the nickname that I associate with them and not names that aren’t so recognizable.
Tuesday, September 22nd, 2009
If you find yourself making changes by accident you can disable this feature so that contacts can only be edited by opening the Contact’s information dialog.
To do this, select the Contacts folder and display the view you don’t want to be able to edit in. Choose View > Current View > Customize Current View > Other Settings and disable the ‘Allow in-cell editing’ checkbox.
Now you can look at the contacts but you won’t be able to change them without switching to another view.
Wednesday, September 16th, 2009
This lets you get the details you have recorded about a contact to someone else without having to pull all the details across manually. It’s simple and quick.
To do this, select the Contacts module and open it. Double click to open the contact’s details that you want to send to someone.
From the Contact tab on the Ribbon click the Send dropdown list and choose In Internet Format (vCard).
This opens a new message dialog with the details attached in a .vcf format file. All you need to do is to enter the recipient’s email address and your message and click Send.
When the recipient receives the message, they can click the attachment to open it and add the person’s details automatically to their Contacts list.
Thursday, September 10th, 2009
To do this, first open your Contacts area and select the Contacts to email as a group. You can do this by Control + Clicking on each contact to select them.
Then select Tools > Mail Merge to create the message. Choose Only Selected Contacts and then select whether to create a printed document or to email it and then click Ok to switch to Word to finish the process there.
Thursday, September 3rd, 2009
When you regularly email a lot of people at once, it makes sense to assemble a distribution list to simplify the task. Then you can send the email to all the people in the list in one step, rather than having to select each member individually.
To create a distribution list in Outlook, select Tools > Address Book and choose File > New Entry.
From the “Select the entry type” list select New Distribution List.In the “Put this entry” area, select Contacts and click OK.
Give your list a name and, to add members to it from your existing Contacts, click the Select Members button. Double click the members in the dialog to add them to the Members area at the foot of the dialog. When you’re done, click Ok.
To add the details of someone who isn’t in your existing Contacts, click the Add New button, then type their details into the dialog.
When you’re done, click Save & Close to finish.
In future you can add the list name to the To area in an outgoing email to send the email to the list members, or better still, include it in the BCC line to keep the members secret from each other.
Thursday, August 27th, 2009
To add an email address to your Contact list from the message window, right-click the address in the From: details at the top of the screen – it doesn’t look like this is clickable but it is.
Select Add to Outlook Contacts from the shortcut menu.
The Contacts dialog opens automatically with the email address in place, enter any other details you want to record and click Save & Close to end.