You can do as follows to turn off the spam filter in Gmail completely: Login Gmail. Click the Show search options icon in the top search box. 3. In the pop-up dialog, input -me in the From field, so that messages sent by yourself will not match this filter. Otherwise, they will be put under both Inbox and Sent labels. 4. In the Doesn't have field, input a random word that will never appear in ANY message. For example, I choose the following...
Read more »At times, in data analysis, you may need to split the contents of an Excel worksheet into multiple Excel workbooks according to a specific column. Now, in this post, we will teach you 2 quick ways to get it. Many users frequently need to split an Excel worksheet that contains huge rows of data into multiple separate Excel workbooks based on a specific column. For instance, here is my sample Excel worksheet. I would like to split this sheet's data on basis of the "Price of single license...
Read more »Sometimes you need to copy cells that meeting certain criteria. And here we will introduce 2 useful methods to copy the target cells. In an Excel worksheet, there will certainly be a lot of data and information. However, those cells contain values that meet certain criterion will separate in different range. As a result, it will be difficult when you need to collect them. In this worksheet, you need to copy cells that is larger than 350. And if you sort those cells one by one and then...
Read more »