MS Excel has some known inconsistency or incompatibility when it comes to its data validation list feature. The exact problem is that, if your file contains data validation lists created in Excel 2007, these data validation lists are gone when you open it in Excel 2010. If this “data validation” thing in Excel is new to you or something that you have not tried so far, please read this article for the complete and detailed procedures in creating and using data validation lists: http://www.technicalforum.org/ms-office/excel-200720102013-using-data-va… Let us take as an example… Read More
Posts in MS Office Tips
How to import your saved contacts or address book to Outlook 2010
You can easily save your existing MS Outlook contacts or address book by exporting them into a CSV file. This process is documented in my previous article. However, even if the contacts are not coming from MS Outlook 2010, you can still use them in your MS Outlook 2010 software. For instance, you have an older version of MS Outlook like 2003 or 2010, you can still use this saved address book file with your MS Outlook 2010 provided that the exported file meets the CSV requirement of MS Outlook. If… Read More
How to show the Developer Menu/Tab in Microsoft PowerPoint 2010
If you are using MS PowerPoint 2010 after the initial installation, the Developer tab is disabled by default. Therefore, without the Developer tab, the Macro features, Add-ins and controls are not available. The Developer Tab buttons are shown below: To enable this Developer tab, here are the steps: Step 1: Open MS PowerPoint 2010 Step 2: Click on File menu Step 3: Click on Options Step 4: On the PowerPoint Options dialog box, click on Customize Riboon command in the left panel Step 5: In the Customize Ribbon group, select “Main Tabs” Step 6: Locate and click on the “Developer” item to put a check… Read More
How to export contacts or address book in Outlook 2010
Suppose you have thousands of email addresses or contacts in your MS Outlook 2010 and you want to move this contacts to your MS Outlook 2010 in another computer, or when you simply want to have a safe backup copy of your emails, all you need to do is export your contacts as an external file. This will give you a CSV file that opens in MS Excel. To export all your contacts from Outlook 2010, follow these detailed procedures: Step 1: Open MS Outlook 2010 Step 2: In the bottom left panel,… Read More
How to show the Developer Menu/Tab in Microsoft Word 2010
If you you just installed your MS Office 2010 software package, by installation default, the Developer menu is not visible. As a result, you cannot add controls to your MS Word document and you cannot code a macro. Here is a screen shot of the Main Tabs of MS Word 2010 where the last tab is the View tab: To enable or show the Developer menu or tab, here are the steps: Step 1: Open MS Word 2010 Step 2: Click on the File menu Step 3: Click on Options Step 4: In the Word Options dialog box, locate and click on “Customize Ribbon” on the left sidebar or panel… Read More
How to recall an email sent using MS Outlook 2010
Have you tried sending an email to a wrong person and you want to retrieve the said email before the person could have actually read it? This kind of situation can really make you feel uneasy and sometimes critical. This is because the email message can contain a confidential information that must only be read by the right contact. However, if you are using an email software especially MS Outlook 2010, you can recall the email message sent in error. In order to recall an email sent in error using… Read More
Enabling the Developer Tab in MS Publisher 2010
If you are using MS Publisher 2010 for the first time after a recent installation, the default behavior is that the Developer tab is disabled. This means that the macro feature, add-ins and customizations, controls and ActiveX are not available. The last menu in the Main Tabs is View. When the Developer tab is enabled, it will be shown as the last tab in Main Tabs shown below: To enable the Developer tab, follow the steps described below: Step 1: Open MS Office Publisher 2010 Step 2: Click on the File menu Step 3: Click on Options… Read More
How to show the Developer Menu/Tab in Microsoft Excel 2010
When you install MS Excel for the first time, the default setting has the Developer tab “disabled”. This means that the Macro button not available including all VBA programming aspect of the Excel file. To enable the Developer Tab, here are the steps: Step 1: Open MS Excel 2010 Step 2: Click on File menu Step 3: Click on Options Step 4: In the Excel Options dialog box, click on Customize Ribbon in the left panel Step 5: In the Customize Ribbon group, select Main Tabs Step 6: Click on the the “Developer” item to put a check on it to “enable” the Developer tab Step 7: Click OK button to… Read More
How to re-use several beautiful slide templates in a single PowerPoint file
When you are using Microsoft PowerPoint 2007 or 2010, beautiful slide templates are already built in. Also, there are several hundreds and even thousands of PowerPoint templates available for free download in various websites that work for both PowerPoint 2007 and 2010. However, when you are working with a template, all slides are identically designed. That is, the first slide is unique, then the rest of the slides follow identical template design every time you add a new blank slide. How about if you want a completely different template or… Read More
Moving Outlook 2007 / 2010 Contacts from one computer to another
Backing up Outlook contacts is a very important task that ensures email addresses and other contact infomation are copied and stored in a separate file and location. Microsoft Outlook Technical Support people offers several and various ways of doing the back, as well as other online outlook tech support. Microsoft Outlook support contact information are not readily available online. However, various forums and support groups offer support for Outlook issues for free or for some small fees. In fact, various technical support companies like iYogi.com and JustAnswer.com offer Microsoft outlook… Read More