Posts in Tips & Tricks

Excel 2010: How to select multiple form controls (like combo boxes)

If you have MS Excel 2010 or 2013 and you are using the Developer tab to insert form controls or ActiveX controls like list boxes, or combo boxes, you might need to delete duplicate or unused controls. By default, when you want to delete a form control like a combo box and you delete the rows where the combo boxes are placed, only the rows are deleted but the combo boxes will float and pile up or overlap with other controls. It is always useful if you find a way to “Select… Read More

How to Protect Your Yahoo Mail Account After Being Hacked (The Last Step is a MUST!)

The internet is never a safe place and email accounts are being hacked everyday. Yahoo! Mail is not an exception. Though there are several reasons why email accounts are being hacked, like phishing, malware infection, or even server exploits, still one thing is true, email accounts can be hacked, like your Yahoo! Mail account. How can you tell that your account was hacked or compromised? Well, the obvious is when your known password is rejected, or when your contacts called you informing you that they are receiving emails that you… Read More

How to Print an Email Message in Hotmail / Outlook.com

Since the changing of the classic Hotmail interface to Outlook.com, several changes took place. One of these changes is printing your emails. This is because as an entirely new interface, the commands and links are arranged and organized differently. The steps below are the common ways print your emails in this new Hotmail interface: Step 1: Using your web browser, go to http://hotmail.com and then login to your account. Step 2: When signed in, click to open the email message that you want to print. Step 3: To print, please locate the “triple-dot” button at… Read More

How to Convert Individual Sheets in a Workbook Into Separate PDF Files

If you are using Microsoft Excel for work or business, you might find it useful to print the Excel sheets as PDF file for better reporting as the contents of the PDF files cannot be modified easily compared to a raw Excel file. Besides, most computers and mobile devices can read PDF files but cannot read Excel files as MS Excel is a proprietary software. There are basically two (2) ways to produce a PDF file from MS Excel file as described in the succeeding texts. Converting Excel file to… Read More

Setting Up a Vacation Reply (auto-responder) in Gmail

If you have been using Hotmail/Outlook.com using a web browser, then you must be able to setup your vacation auto reply system. (Haven’t tried it yet? Click this link for the procedures.) If you have Gmail, you also have that feature available.  By default, this feature is turned OFF in Gmail. The reason for this is because this feature shall only be onced once you are away for a vacation and that you are unable to get access to your Gmail account. This is the best and polite way of telling… Read More

Setting Up a Vacation Reply in Hotmail/Outlook.com

With the new Outlook.com interface of Hotmail, there are several cool features added to make your email experience better. One of these features is the Vacation Reply capability. This is also called an Out-Of-Office message in other email programs. When you are planning to go out-of-town with your family and expecting less time checking your Hotmail/Outlook.com emails, you can setup a Vacation Reply. This Vacation Reply is essential since your customized message will be automatically sent to people who contacted you in your Hotmail/Outlook.com account while you are away for… Read More

Setting Up a Vacation Reply in Yahoo Mail

Gmail has it. And so with Hotmail. If you are using Yahoo Mail, you too have the ability to use a Vacation Reply. This is a simply email template that Yahoo Mail will send to people who contact you while you are away for a vacation. This Vacation Reply or response is just a simple message informing the people who contatced you through your Yahoo Mail that you are out of the office and can attend to their business needs at a later time. This feature is applicable when you are using… Read More

Recovering data on damaged drives (HDD, Flash Disk Drives, External Hard Disk Drives)

We normally depend on local hard disk drives in storing our important data. Important documents especially those work or profession related, emails, and family pictures are usually stored in local hard drives, USB Flash drives or External Hard Disk Drives. Though storing your files in a local drive is not improper practice, I highly recommend that you keep backups for your important files. By backups I mean storing them in more than one drive just in case the boot drive is damaged by simple wear and tear. Hard disk drives… Read More

Microsoft Outlook keeps prompting for password. Not using Exchange. I cannot access Credential Manager

There is a very common issue with Microsoft products: bugs. I am very sorry to single it out but reality speaks and I believe you also have “buggy experiences” with your Microsoft software. When it comes to Microsoft Outlook software, versions 2007, 2010, 2013 and later, some people got annoyed with a perpetual prompt for network password as shown in the image at the left. You might be reading this because you too are having the same problem. That is not surprising, as thousands of people are searching for a… Read More