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, namely preventing duplicate values in a column. It demands Excel to auto alert you every time when you enter duplicate values in a column. Thereinafter, we will share you 2 quick means to get it.
Method 1：Prevent via "Data Validation"
First off,...
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 addresses which are in the same domain. Since you frequently send emails with various attachments to each other, you may wish Outlook to auto save the attachments from such emails. In this case, Outlook will be demanded to auto check the email's sender...
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 amount of worksheets, you may find it troublesome to locate and access your desired worksheet. In this case, you can create a list of hyperlinks to all worksheets, which can let you jump to a specific worksheet simply by clicking on a hyperlink. It's...
Read more »
