Excel File Recovery

How to Improve Your Efficiency by Highlighting the Expiry Dates in Excel Worksheet

You will certainly input the task and the date plan into Excel worksheet. Here we will introduce a method to highlight those expiry dates to improve your efficiency. When you have many tasks to do, you can use the Excel to make your plans. However, with so many tasks to finish, sometimes you may forget one or two. The image below shows the test activities and the expiry dates in a worksheet. In order not to forget one of the dates, you can highlight those cells to remind yourself. Now...

Read more »

3 Effective Methods to Get the Path of the Current Excel Workbook

When you are working on an Excel workbook, you may need to refer to the path of this file. In this article, we will show you 3 methods to get the path. Getting the path of the current workbook seems to be very easy. However, if you close the folder and couldn’t remember the exact location, you will find it hard to get the path especially, especially when there are many files in your computer. You can certainly use the search feature in your computer. But if there are many files in your...

Read more »

How to Highlight the Top or Bottom N Items by Conditional Formatting in Excel

Finding the top and bottom items in an Excel worksheet is  very ordinary in your work. And in this article, we will use the conditional formatting to quickly achieve this task. In your Excel worksheet, you will sometimes need to find the top n items or bottom n items. If those cells are not in a column or in a row, you cannot sort values. Hence, it is very difficult for you to find out all those cells manually. But in Excel, you can use the conditional formatting to finish this task. Now...

Read more »