Office Solutions

How to Change the Default Programs to Open Outlook Attachments

When you double click on a pdf attachment, Photoshop shows up and attempts to open the pdf file. It will fail absolutely. In this case, you have to change the default program to open the pdf attachment. I have ever encountered this issue as well. At that time, I tried to open a spreadsheet attachment that is usually opened by Excel application, but WordPad showed up instead of MS Excel. Finally I have no choice but to change the default programs in Windows Control Panel. Change the Default...

Read more »

How to Display the Remaining Days of Your Outlook Tasks

Outlook shows due date in Task list as default. You can also show the certain number of remaining days before the due date via the method introduced in this article. In To-Do list, we can check the due date of every task. To a certain extent, it can remind us to complete the tasks as soon as possible. But actually there is a more direct approach. That is to show the certain number of remaining days before the due date. Here are the concrete steps. Customize a Column of “Remaining Days”...

Read more »

How to Change the Case & Capitalization of Texts through Excel Functions

Apart from dealing with data, Excel is also able to deal with information. And now follow us and see how the three functions (UPPER, LOWER, PROPER) work. Of course, in your worksheet, there will be a lot of information. And sometimes, for certain words, you should change their cases. besides, conditions also includes that the first letter of a word should be in uppercase. But if there are many words in your worksheet, it will be very inconvenient to change the form. So here you can use the...

Read more »