Tag Archive


accdb repair access recovery access repair Contacts corrupt Outlook corrupt PST damaged Outlook damaged PST Data Backup Data Loss Data Recovery excel recovery Excel tips Excel VBA Hard Drive inbox repair tool mdb repair mdf recovery MDF repair Ms Access outlook contacts Outlook corruption Outlook Email outlook recovery Outlook repair outlook VBA PST corruption pst recovery pst repair Quick Access Toolbar recover access recover outlook recover PST recover sql repair access repair excel repair outlook repair pst ScanPST SQL recovery SQL Server sql server recovery VBA View Settings Word Macro

2 Methods to Auto Update the Reference Range of a Defined Name in Excel Worksheet

Using defined name in Excel can save you a lot of time. Here we will introduce two methods to automatically update the reference range of a defined name in the worksheet. A defined name has a wide range of use. You can even use a certain name in formulas. The defined named can help you […]

2 Methods to Auto Refresh the Drop-Down List in Your Excel Worksheet

The drop-down list in data validation is a frequently used feature in Excel. In this article, we will introduce two methods to auto refresh the drop-down list. In our previous article How to Create Drop-down List from a Range of Cells in Your Excel, we have introduced the drop-down list in detail. When the source […]

2 Methods to Count the Number of Cells with Background Colors in Your Excel

In your Excel worksheet, you will certainly highlight some cells by formatting them with background colors. And here we will demonstrate two methods to count the number of those cells with background colors. There are many different methods that you can do to highlight certain important cells. And formatting cells with background colors is one […]