Excel Solutions

How to Use the Selection Pane to Manage Shapes in Your Excel Worksheet

Many users will ignore the functionality of selection pane in Excel. Therefore, in this article, we will talk about this feature in detail. The selection pane will take effect on shapes, including pictures, shapes, comments and other objects in an Excel worksheet. If in an excel worksheet, there are many such objects, you will be unable to deal with them easily. At this time, you can turn to the selection pane for help. Activate the Selection Pane Before you manage shapes in your Excel...

Read more »

How to Quickly Create a Catalog for Your Excel Workbook via VBA

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 »

How to Use AND, OR and NOT Functions in Conditional Formulas

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...

Read more »