Posted on Nov 19, 2007 under Office Tips |
By default the slash (/) key acts as a shortcut to the Excel menu bar. Here’s how to disable this so that you may use the slash character within your Excel 2007 spreadsheet.
1. From the Office Button menu, select Excel Options.
2. Choose Advanced, and then scroll down until you see the Lotus compatibility section.
3. In the Microsoft Office Excel menu key: field, replace the slash with a character that you do not use frequently, and then click OK.
Posted on Nov 19, 2007 under Office Tips |
Set the font you wish to use by default every time you start a new document in Word 2007.
1. Launch Word and hold down CTRL and press D.
2. Choose the font type and size that you want to be the default every time you open Word.
3. Click Default… in the bottom left corner of the Font window. Click Yes.
Posted on Nov 19, 2007 under Office Tips |
How to change the of the quotes in Word 2007 from the straight to the curved or “smart” version.
1. From the Office Button menu, select Word Options.
2. Select Proofing, and click AutoCorrect Options… .
3. Click the AutoFormat As You Type tab.
4. Under Replace as you type, put a check in the “Straight quotes” with “Smart quotes” box and click OK.
Posted on Nov 19, 2007 under Office Tips |
Word 2007 include some powerful templates that make creating a resume easy. Here’s how to access them.
Use the included default templates.
- Click the Office button and select New.
- In the Templates section, select Installed Templates.
- Select the appropriate resume template by double-clicking.
You can get many more templates from Microsoft.
- Click the Office button and select New.
- In the Microsoft Office Online section, select Resume.
- Select the appropriate resume category.
- Double-click the template you wish to use.
Posted on Nov 19, 2007 under Office Tips |
Set your Word Document to begin numbering your pages starting with a different number than 1.
1. Under the Insert tab, in the Header & Footer group, click Page Number.
2. Click Format Page Numbers.
3. In the Start at box, enter the page number you would like to Word to start numbering pages.
If you have a cover page and you want the first page of the document to start at 1, set the Start at setting to 0.
Posted on Nov 19, 2007 under Office Tips |
How to install the Word 2007 Equation Editor so that you can make math equations within Word documents.
1. Go to Control Panel
2. Double-click Add/Remove Programs.
3. Click once on the Microsoft Office 2007 entry and click Change.
4. Select Add or Remove Features, and click Continue.
5. Click the plus sign next to Office Tools.
6. Click Equation Editor, and select Run from My Computer.
7. Click Continue. Click Close when the install is complete.
Posted on Nov 19, 2007 under Office Tips |
Disable the feature in Word 2007 that automatically starts entering numbered or bulleted text for you.
1. From the Office Button menu, select Word Options.
2. Click Proofing.
3. Click AutoCorrect Options, and then click the AutoFormat As You Type tab.
4. Under “Apply as you type“, deselect Automatic bulleted lists and Automatic numbered lists.
Posted on Nov 19, 2007 under Office Tips |
A problem where the Outlook 2007 security blocks links with a certain extension and gives an error:
Cannot open file
This usually happens with files with an extension of .EXE, .BAT, .MDB, or .MSI
1. Click Start–>Run, type Explorer in the Start Search box, and click OK.
2. On the Tools menu, click Folder Options.
3. Click the File Types tab, and click New.
4. Type the file extention (i.e. .exe, .bat, .mdb, etc.) in the File Extension box, and click OK.
5. Click to select the file extension you typed under Registered file types, and then click Advanced.
6. In Edit File Type dialog box, type the file extension next to the icon, and then click New.
7. In the New Action dialog box, type OPEN for Action, and then type the path to Outlook:
“DriveLetter:\path\Outlook.exe” /x “%1″
Click OK two times.
Note By default, the path of the Outlook.exe file is as follows:
“C:\Program Files\Microsoft Office\OFFICE12\Outlook.exe” /x “%1″
8. Click Close and restart Outlook 2007. You should now be able to open the file.
Posted on Nov 19, 2007 under Office Tips |
Pull back a message you sent by using the recall feature in Outlook.
1. Go to the Sent Items folder.
2. Open the message you wish to recall.
3. Click Actions–>Recall This Message.
To recall the message:
Select Delete unread copies of this message.
(Note: the recipient needs to have Outlook opened for the message to be deleted)
To replace the message:
Select Delete unread copies and replace with a new message, click OK, and type your new message.
To be notified about the success of the recall or replacement:
Check the Tell me if recall succeeds or fails for each recipient check box.
5. Click OK.
Posted on Nov 19, 2007 under Office Tips |
When trying to use Dictation Mode in Microsoft Word on a tablet PC, it doesn’t work.
Go to your Control Panel and select Regional and Language Options, then select the
Languages tab, then Details.
Under Installed Services, verify that the following are installed:
(1) Tablet PC Correction.
(2) Tablet PC Correction for Windows Journal.
(3) Tablet PC Text Insertion.
(4) Ink Correction.
Beneath those entries, you should have Keyboard with the matching location (example: US) as you do under Default Input Language above the Installed Services pane. Beneath that, it should show Speech Recognition. If any of these entries do not exist, you will need to use the Add button to add them.
Also check the Advance tab and verify there is NO check mark in “Turn off advanced text services” and that there IS a check mark in “Extend support of advanced text services to all programs.” Once all these are verified, tap the OK button and restart your system.
This article applies to Office 2003 and Word 2002
Posted on Nov 18, 2007 under Office Tips |
If your mailbox is getting full you will be sent an email message to tell you that your mailbox is approaching the quota. If you do not reduce the size of your mailbox, you will be unable to send email, and you’ll receive an email headed “Your mailbox is over its size limit”.
To clean out your mailbox:
1. Check the following folders and delete everything that you don’t need to keep.
a. Inbox
b. Outbox
c. Sent Items
Sorting the items by Size may be helpful it ridding yourself of the files that take up the most space. Highlight the items to be deleted, then press Shift and Delete together to permanently delete the items.
2. Delete everything in your Deleted Items folder. To do this, go to the folder, select the Tools menu and click on Empty Deleted Items.
If you are using Outlook 2003, look in the Large Mail folder (located under Search Folders) for emails you can delete. This shows you all large files in any folder in your mailbox, including those with big attachments. If you need to keep attachments, save them elsewhere on your hard drive.