Tag Archives: Microsoft Office

How to change Product Key for Office 2013 Home and Business

The small company I support bought 5 computers and each comes with a product key for the Microsoft Office 2013 Home and Business. For some reason,  I put a same key for the second Office installation. And I didn’t find out till the activation process gave me the error indicating that the same product key has been activated in some place else. Continue reading

How to freeze top 2 rows in Excel 2007 and 2010

Challenge:

In Office Excel 2007 and 2010, there are three Freeze Panes options (Freeze Panes, Freeze Top Row, Freeze First Column) in View tab Window Group. It is easier to just freeze the first row and the first left column with the last two options. But when I select the first two rows and hit the Freeze Panes, by default Excel freezes four equal panes starting from the middle point. Then how can I just freeze the top two rows?

Solution

Just place your mouse or click the cell A3, then View / Window group / click on Freeze Panes / click on Freeze Panes. In this way, your top TWO (2) rows will be freeze.

More detail…

The option Freeze Panes will freeze all rows above the currently selected cell and also all columns to the left of selected cell. So if you want the 2 top rows and no columns, then put select cell in A3 and select freeze panes. Similarly, if you want 4 top rows freeze, then click to select the cell A5, and click Freeze Panes. Or, if you want 2 left columns and no rows, then select the cell C1.

How to export Outlook Distribution List to .csv file format

[Updated on 2008-12] This post can be treated as one of the “how-to” serials on Outlook tips.

I know we can export Contacts from Outlook directly into .csv (Comma Delimited) files, but not the same case in Distribution list. That is understandable since Distribution lists are not creating any new Contacts, just grouping these existing contacts.

But I need to export these Contacts into different .csv files based on the Distribution Lists I already created before. So I had to do extra steps to make the export happen.

Step 1: Save Distribution List as Text file

Continue reading

How to create email distribute list: import contacts into Outlook contacts easily

I need to post a serial how-to in Outlook for some of my clients. This one is part of “how to create email distribute list” and copy & paste from this website.

If you have e-mail addresses or other contact information in a program and want to import the data into Microsoft Outlook, follow the steps below.

Export and Convert the Data

Use the program’s export or save as feature to save the data into a “Comma Separated Value (.cvs) file to enable it to be imported to the Outlook Contact list.

  1. Open the .csv file with Microsoft Excel or another program to prepare the data for export.

  2. The open file should be similar to the image shown below.
  3. To successfully import these addresses over to Outlook proper labels must be assigned to the enteries in the Excel file. Insert a row above the current list of entries. Name the three column headings as Nick Name, Full Name and E-mail Address appropriately.

  4. The Excel file should look like the image shown below.

  5. Save the Excel spreadsheet as a ” Comma Separated Value ” file with a .csv extension on to your Desktop.
  6. Click Yes if prompted to retain the format of the Excel file and then close the Excel program.

Continue reading

How to organize the large email boxes in Microsoft Outlook

Outlook_2003 Last Friday, I spent half of my day on helping my friend to clean up its Outlook files. The main reason was that he kept all his emails since day one and the mail box was too huge to accept any new incoming emails (not sure the limitation on PST file from Microsoft is now still 2GB or not). I understand the importance of archiving correspondences between clients and my friend, so my strategy was to split all emails into a few PST (Personal Folders File) files which would be under the size limitation. And at the meanwhile, I set up an auto archive mechanism to move old emails to other pst file in the future automatically.

I know I was supposed to send him a detail instructions on how to do such things as my promised. But I could not get close to the computer during my busy weekend. So I am publishing all my steps here today, for him it will be a instruction via URL; and for all of you (include myself), a future reference post.

Continue reading

Cannot use right click or drag/drop of mouse in Microsoft Word and Outlook 2003

Word_Icon_A Today I tried to copy and paste an email in Outlook 2003 but found out the SELECT ALL function of my mouse did not work. I could not highlight any texts in the mail body, and I could not even see the copy & paste options and the whole context menu by right clicking my mouse. 

Since I know I configured in the Outlook to use Microsoft Word 2003 as the primary email compose tool, I opened a new Word Window to see how things do in the Word. Same thing happened in Microsoft Word 2003, I could not use all my mouse right clicking.

Continue reading

How to easily enter numeric characters as text strings in Excel

This tips came from my mailbox as a training company’s newsletter, and I would like to share with you all since I feel it might be useful to you too. Based on the email, it should be working on versions of Excel 97/2000/2002/v. X/2003.

You’ll occasionally find that seemingly simple entries cause problems because Excel tries to interpret numeric values as a date. For instance, say that you have a column of product codes with values like 9-12, 10-22, and 8-2099, or you have data labels that describe the age ranges 1-3, 4-6, 7-9, and 10-12. Excel automatically converts the codes to 12-Sep, 22-Oct, and Aug-99. Likewise, Excel converts the range labels to 3-Jan, 6-Apr, 9-Jul, and 12-Oct.

Continue reading

Google Desktop 5.5 causes problem in Outlook 2003 which cannot open Forwarded Email Attachments

Since last week (at least I think from then) I could not open any attached emails in my Office Outlook 2003 any more. When some one forwarded an email to me with the original emails as an attachment, I clicked the attached email but nothing happened. Even I saved it as a msg file, but I could not open and read it in Outlook 2003 by double clicking as I used to.

I did not relate this problem with my Google Desktop till I checked on the web. It Seems that anyone who enabled latest version of Google Search add-in in Outlook 2003 would have the similar problem. Besides the attached emails, they could not open the added email items in the Calendar appointments. The version of Google Desktop Personal could be 5.5 beta, or similar version of Google Desktop Enterprise. I checked mine, which is Google Desktop 5.5.0709.30344-en-pb.

Continue reading

How to un-protect Microsoft Excel worksheet without password

Today one of my co-workers in Finance department asked me to take a look at an Excel worksheet. He needed to add something in but all modification options like Insert, Delete were grayed out. He mentioned he was not the original guy did this worksheet and the guy who did this worksheet had left.

Continue reading

How to play a YouTube movie in PowerPoint 2003

You TubeIf you like a very interest video clip from the YouTube and want to share with your co-workers in your next presentation, you should be able to play it in a PowerPoint presentation using a specific ActiveX control and the Macromedia Flash Player. Since videos on YouTube are almost flash-like files, you can add an ActiveX control to the PowerPoint slide and create a link from it to the video clip.

Please make sure you can play flash file on your computer before you proceed.

  • The ActiveX control, called Shockwave Flash Object, must be “registered” on your computer for you to play the YouTube video clip within PowerPoint. If it is not registered, download the latest version of the Macromedia Flash Player from the Macromedia Web site; this will register the control on your computer.
  • Older versions of the Shockwave Flash Object may be registered on your computer. To guarantee that complex animations run properly, we recommend that you install the latest version of the Macromedia Flash Player.

Continue reading

[OUTLOOK] Error in registry for extension Exchange Extension

Today when I started Microsoft Office Outlook 2003, I received the following error message:

Microsoft Office Outlook

Error in registry for extension “Exchange Extensions”.
The syntax or format of the registry entry is incorrect. Check the registry settings and compare the registry for this extension to other extensions in the registry.

Continue reading

How to use Automation to send a Microsoft Outlook message using Access 2000

There are six main steps to sending a Microsoft Outlook mail message by using Automation, as follows:

  1. Initialize the Outlook session.
  2. Create a new message.
  3. Add the recipients (To, CC, and BCC) and resolve their names.
  4. Set valid properties, such as the Subject, Body, and Importance.
  5. Add attachments (if any).
  6. Display/Send the message.