Excel File Recovery

How to Find Missing Items in a Column with Consecutive Numbers in Excel Worksheet

When you are working on an Excel file, it is unavoidable to lose some data and information. In this article, we will show you 3 methods to find the missing items in a column with consecutive numbers. Usually in your Excel worksheet, there will be a column with consecutive numbers. However, some reasons will cause some data to be lost, such as copying and pasting, or you forget to collect a sales representative’s information. Therefore, it is necessary for you to check the worksheet in...

Read more »

2 Methods to Find the Largest or Smallest N Items in Your Excel Worksheet

Sometimes you need to find the largest N items or the smallest N items in a range in your worksheet. Here we will provide two effective methods for you. Finding the largest N items or the smallest N items in a range is a very ordinary task in your work. In our previous article How to Highlight the Top or Bottom N Items by Conditional Formatting in Excel, we have introduced the methods of using conditional formatting. And in the following part, we will discuss about the two other methods in...

Read more »

2 Methods to Hide or Show Specific Lines in a Line Chart in Your Excel Worksheet

When there are many data series in a worksheet, the corresponding line chart will also be in a mess. In order to make the chart clearer, we have the two methods in this article. The line chart in Excel can show data and information better. But with many lines in one chart, you will find it hard to check certain lines. In our previous article How to Create a Dynamic Line Chart with Checkboxes in Your Excel Worksheet, we have introduced a method to make the line chart better. And here we have...

Read more »