If you'd like to batch open multiple hyperlinks in Excel, you can refer to this article. Here we'll introduce you 3 handy methods. Each of them has its pros and cons. You can choose any as per your needs.
In some cases, when viewing an Excel file...
Read more »
If you want to quickly get the data size of each worksheet in an Excel workbook, you can refer to this article. Here we will share 2 handy methods with you.
At times, when dealing with an Excel workbook which consists of a great amount of...
Read more »
If an Outlook task contains many attachments, to extract and save them to a local folder, in general, you have to save them one by one manually. Yet, in this article, we will introduce a method to batch save all attachments in one go.
At times,...
Read more »
In an Excel worksheet, if data is entered in nonadjacent cells, you may discover it a bit troublesome to select and copy the data in non-blank cells. Now, in this post, we will introduce 2 ways to quickly select all non-blank cells.
Excel users...
Read more »
In order to distinguish private items and non-private items in calendar more easily, you may wish to auto show private items in a specific color, such as red to highlight them. This post will introduce 2 ways to realize it.
Many users prefer to...
Read more »
Sometimes, you may want to convert multiple Excel workbooks to PDF files. Here, in this article, we will introduce 2 methods to get it in batches.
In some cases, you may need to convert an Excel workbook to a PDF file in that a PDF file cannot be...
Read more »
If you want to avoid entering duplicate values in a column in Excel, you can refer to this article. Here we will share you 2 simple approaches.
At times, when you edit an Excel worksheet, you may want to ensure the data in a column are unique,...
Read more »
If you want to let Outlook auto save all attachments from the senders whose email addresses are in a specific domain, you can read this article. Here we will introduce a quick method to you.
Perhaps all staffs in your company use the email...
Read more »
When an Excel workbook has many worksheets, in order to access them quickly, you may want to create a list of hyperlinks to all worksheets. In this article, we will share 3 methods with you.
If you have an Excel workbook which contains a great...
Read more »
You have an Excel workbook which contains a lot of charts spread in all of its Excel worksheets. Now, if you want to batch export all the charts to a Windows folder, you can use any of the 3 methods introduced in this article.
After creating...
Read more »