2 Methods to Find and Select Cells with the Same Format in Your Excel Worksheet

In your Excel worksheet, you will format cells that meet certain criteria. When you need to select cells, you will spend a lot of time. Here we will introduce two effective methods for you to find and select those cells. Sometimes you need to select cells with the same format and then finish some tasks. For example, you need to change the format or delete the format for those cells. However, in most cases, those cells will be separated in different places. Therefore, you will find it hard to...

Read more »

How to Monitor SQL Server Database Growth using TSQL and Excel

Monitoring database growth is a key factor in planning a server's resource. Use this script and create easy to understand database growth report Why You Need to Monitor Database Growth If you are a SQL Database administrator and if you are not having "SQL Server database capacity planning" in your key task list, then you can be sure that databases on your server will fill up your disk space pretty soon. Tracking the size and growth of SQL databases is one of the primary task of Capacity...

Read more »

How to Delete Emails of Gmail Account from Both Outlook and IMAP Mail Server

If you are using Gmail account via IMAP in Outlook, you may find that the emails, which you’ve deleted from Outlook, still exist on Gmail server. This article will teach you how to make the emails to get deleted from both Outlook and IMAP server. By default, Gmail account is configured to archive emails instead of deleting them. More specifically, when you delete an email of Gmail account via IMAP in Outlook, it just removes all the deleted email’s labels, such that it will still exist in...

Read more »