Tag Archive


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

How to Auto Update the Sequence Numbers in Your Excel Worksheet

The sequence numbers can always be seen in an Excel worksheet. In this article, we will show you how to auto update the sequence numbers when you insert or delete rows in a range. You will certainly have used the sequence numbers in a worksheet. With those numbers, the range will be clearer and you […]

2 Methods to Find the Minimum Number in a Range Excluding Zeros in Excel Worksheet

Sometimes there is a need to find the minimum number in a range excluding zeros. In this article, we will introduce two methods to finish this task. When the worksheet contains a bunch of data and information, it is impossible for you to find the minimum number. And finding the number will cost you a […]

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 […]