There are many table styles in your Excel worksheet. But instead of using the pre-defined styles, you can also create your own custom table style in Excel. When you create a new table in the worksheet, you will see the default table style in the...
Read more »Invisible hyperlinks will sometimes cause trouble to you. And in this article, we will use VBA to find invisible hyperlinks in your Excel worksheet. In this image below, you can see that all the cells have the same format. But there exist some...
Read more »Copying and pasting is one of the most common tasks in Excel. In this comprehensive guide, we'll show you 7 effective methods for how to paste multiple cells into one cell in your Excel worksheet. 1. Introduction When working with Excel...
Read more »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...
Read more »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 »If there are a lot of data and information in Excel, it will be cumbersome to view data. Therefore, you can embed a scrollable area in Excel. In the image below, you can see the sales volume of many sales representatives. You need to move the...
Read more »Sometimes you need to display data in a column chart. In this article, we will show you 2 excellent ways to display data in a column chart that combines clustered and stacked column. It is very easy for you to insert a clustered column or a...
Read more »When there are many sheets in your workbook, you will spend a lot of time to go to a specific sheet. Here we will introduce two methods to finish this task. If there are many sheets in your workbook, you will find it irritating to find and go to...
Read more »