How to Create and Manage a Custom Table Style in Your Excel Worksheet

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 range. With different colors in adjacent rows, you can check values more convenient. But if you are bored with the default table style, you can also change it. You can click the button “Format as Table” and open the style list. In the image...

Read more »

How to Find Invisible Hyperlinks in Your Excel Worksheet via VBA

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 invisible hyperlinks among those cells. When you need to select a cell, you will certainly use your mouse and click it. But if the cell contains an invisible hyperlink, the computer will immediately launch the browser and open the hyperlink. This is...

Read more »

3 Easy Tips to CC or BCC an Outlook Meeting Invitation

When you create an Outlook meeting, you won’t be able to find “CC” or “BCC” field. But many users wish to CC or BCC a meeting invitation. In this article, 3 simple methods will be introduced in detail. Many users may have noticed that there are only “To” field in the New Meeting window without “CC” or “BCC” fields. However, like CC or BCC common emails, sometimes you may hope to CC or BCC meeting invitations to someone else. In reality, via making some extra efforts, you can achieve it. The...

Read more »