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
Posts in Tips & Tricks
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
Enabling and Disabling Protected Mode in Microsoft Internet Explorer
As internet or web technology is continuously advancing, online threats are also improving their attack strategies. This is the main reason why internet protection software are essential to businesses and individuals alike. Aside from the standard threat protection that you can get from the various antivirus or security applications, you can also have a second layer of protection in your Microsoft Internet Explorer web browser. This security feature of Internet Explorer can be likened to a “web application firewall” for web application security. This feature is called “Protected Mode” in… Read More
Emails in IncrediMail 2.0 not opening when clicked. IncrediMail appears frozen!
There is a known issue when using the well-known email program called IncrediMail, with its latest stable version 2.0. Regardless of the version of Windows that IncrediMail 2.0 is running, in this problem scenario, every time you click to open an email, nothing happens, as if IncrediMail’s emails are frozen. This freezing problem is caused by corrupted indexes that IncrediMail is using. These indexes are located in the Message Store folder. How to Locate The Message Store Folder To access the Message Store folder, you need to know from your… 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
Email Tip: How to restore or revert to your old Yahoo Mail interface
With the good intentions of providing a better mailing experience among millions of Yahoo Mail users, recently Yahoo Mail launched its newly improved interface that triggers mixed reactions among the people. Some people want the new changes, but other people want the old Yahoo Mail. As described in this previous article, Yahoo Mail now offers a lot of features for their users. Features that are similar or even better than those in Hotmail, Gmail or AOL. But for those who do not want these changes, there is still a way to… Read More
Email Tip: How to get rid of the Sign in to Windows Live Mail pop up
Starting with Windows Vista, Microsoft changed its built-in email client for the better. The former Outlook Express of Windows XP become Windows Live Mail, an integral part of the Windows Live Essentials software suite. For Windows Live Mail users, especially if they are using a Microsoft account with their email client, can encounter a problem regarding a perpetual prompt of the sign in screen for Windows Live Mail that looks like this screen below: Basically, this screen is not required in order to use Windows Live Mail. This is only… Read More
Do I need an e-commerce website?
Most people especially those technologically challenged ones find an e-commerce system a very huge solution for small-time or startup businesses. They are partly correct. Think of Amazon, E-bay, NewEgg, and most computer manufacturers like HP and Dell, they are huge companies so they can afford to build and maintain an online marketing portal – an e-commerce system. However, creating and launching your own online store, or the so-called e-commerce website, is no longer expensive nowadays because of SaaS e-commerce platform. SaaS means Software As A Service. And the best and… 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