Solutions

How to Create a Catalog in Your Excel via Hyperlinks

Due to the ability of processing thousands of data, Excel has become the first choice of most of the companies. Thus, today we have the Excel tips of creating a catalog by inserting hyperlinks into a worksheet. In your work, you are likely to meet with many worksheets with the same attributes. For instance, here is an Excel file about student scores of different classes. And there are many worksheets. So you can try adding a new worksheet and insert hyperlinks into it. Thus, you...

Read more »

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 »