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...
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...
Read more »Sometimes you need to show or hide gridlines to fulfill some tasks. Here we will provide 3 quick methods to show or hide gridlines easily. In your Excel worksheet, the gridlines can help you distinguish different cells. But on the other hand,...
Read more »