How to Configure a Receive-only or Send-only Email Account in Outlook

Would you like to create a receive-only or send-only email account in Outlook? This article will teach you how to accomplish it in detail. In reality, no matter to configure a receive-only or send-only email account, you can use a similar method to achieve it with effortless ease. You should firstly set up the email account with a fake outgoing or incoming mail server, and then configure the account not to send or receive mail items via defining Send/Receive groups. Here are the elaborate...

Read more »

How to Quickly Select or Unselect all Checkboxes in Your Excel Worksheet by VBA

Checkbox is a good helper when you will analyze certain information. And in today’s article, we are going to introduce the method to quickly select or unselect all checkboxes in your Excel worksheet. Checkbox is a kind of form control object in Excel. You will sometimes mark some options by checkboxes. The image below demonstrates a list about the products. You can use the checkboxes to select or unselect certain products. While in some analysis, you will need to select all the...

Read more »

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 »