If you are using MS Excel 2007, 2010 or the newer versions from the date of this writing, now you can send your Excel file as an email attachment using the commands found in Excel menus. This is the “Send As Attachment” command in Excel 2010. What this menu command does is actually simple. When you open your workbook in Excel and this workbook is intended to be sent to someone through email, you can click on the Send As Attachment button and then Excel will invoke or launch your… Read More
Posts in MS Office Tips
Microsoft Excel Power Shortcuts: Converting cell formulas to values
Microsoft Excel 2010, like its older version (2003 or 2007) are packed with huge sets of features and shortcuts waiting to be uncovered. In this article, we will discover how to copy the values of a cell excluding the formulas. Normally, when you copy the cells containing a formula, the formula is copied automatically and the cell references are updated dynamically. This is a very essential feature of Excel. Since the formula is being copied and the cell references in the formula are updated, the cells will then show up… Read More
Excel 2007/2010 Glitch: All Files Now Open as Blank
If you have been using Excel 2010 or 2007 for some time, you might have encountered this Excel problem scenario. If not, watch out since you may encounter it any time. The problem is, out of the blue, all the Excel files now open as blank. How to resolve this glitch? This is indeed a glitch of some sort since their are no specific setting changes that cause the problem to occur. Also, this happens to few people only using the same version of MS Excel. If you are troubled… Read More
Microsoft Excel: How to extract the “Month”, Day or Year in a DATE entry in a cell?
Suppose you are working in an Excel sheet containing cells with dates. Depending on your actual requirement, one of the things that you might want to do is to extract the day, month, or even the year in a date entry in an Excel cell. For instance, your cell A1 contains the date June 7, 2013. It could have been entered as 6/7/2013 but the cell was format to show the date in a long pattern. But as long as Excel recognizes the data as a DATE, then it stores… Read More
Excel 2003/2007/2010/2013: Copying a row and pasting in column and vice versa
When working with huge amount of data in Excel, there will always come a time that you want to copy the contents of a row and paste it in a column, or vice versa. Have you had such encounter before? Suppose your summary report lists years downwards, or in a column. But then your boss requires the years are listed across, that is, in a row. If there are just few years in the report, it will be just easy to re-type them manually. However, if the report has years… Read More
Emails forwarded using Outlook 2007 or 2010 are not showing the embedded images. Why? How to solve this problem?
This is a very rare issue with MS Outlook 2007 or Outlook 2010. When sending or forwarding an email with embedded pictures, the receiver will get the email but the pictures are not shown. The receivers have checked that their email programs were allowed to download and view images. Did this happen to you? Imagine this scenario: If you have had this scenario, it is then time to conclude that the problem is with your Outlook 2010 (or 2007). Again, this is not a common issue so only few people can… Read More
Different ways of creating or providing a drop-down box in Excel
In MS Excel, there are various way to create or provide a combo box or drop-down selection menu. One of the ways is described in my previous article. Besides the data validation method, described below are the other procedures in creating drop-down menu is MS Excel. The most common of the ways to create a drop-down lists are the following: Form Control Combo Box In order to create an ActiveX Control Combo Box, you need to enable your Developer Tab when you are using Excel 2007 and later versions. Click on the… Read More
Data Validation drop-down boxes are missing in a different version on Excel
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
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