Creating a catalog for a workbook with many worksheets is necessary. Here we have a quick method to create a catalog in an Excel worksheet.
In our previous article How to Create a Catalog in Your Excel via Hyperlinks, we have talked about creating a catalog by inserting hyperlinks in to a worksheet. Creating a catalog for a workbook with many worksheets can be very useful. But adding hyperlinks one by one manually can be time-consuming. Therefore, here we have a new method to quickly create...
Read more »
You can use conditional formulas in conditional formatting. And in this article, we will explore how to use AND, OR and NOT functions in the conditional formulas.
In conditional formatting, you can use the combination of IF function and AND, OR or Not functions. Besides, in conditional formulas, you can omit the IF in the formula. Below we will talk about the usage in detail.
AND Function
In the image below, we want to highlight the months with the criteria: the sales volume of “DataNumen...
Read more »
If you’ve specified a default signature in Outlook, when you create a new message from a template, the signature will be added automatically too. If you dislike it, you can use the quick method introduced in this article to disable it.
When composing message templates in Outlook, you may get used to including the signature directly in the template. However, when you create a new email from the template, Outlook will automatically insert the default signature as well. In this case, there will...
Read more »
