Office File Recovery

3 Handy Methods to Batch Add a Prefix to Multiple Cells in Excel Worksheet

If you would like to batch add a specific prefix to multiple cells, you can refer to this article. Here we will introduce you 3 easy methods. Each has its own pros and cons. You can choose one as per your needs. At times, you may need to add a specific text to the beginning of multiple cells in an Excel worksheet. For those Excel newbies, they may tend to add the prefix to each cell one by one. However, it will be extremely time-consuming if there are a great number of cells to be processed....

Read more »

2 Fast Means to Split an Excel Worksheet’s Contents into Multiple Workbooks Based on a Specific Column

At times, in data analysis, you may need to split the contents of an Excel worksheet into multiple Excel workbooks according to a specific column. Now, in this post, we will teach you 2 quick ways to get it. Many users frequently need to split an Excel worksheet that contains huge rows of data into multiple separate Excel workbooks based on a specific column. For instance, here is my sample Excel worksheet. I would like to split this sheet's data on basis of the "Price of single license...

Read more »

3 Quick Methods to Recursively List All Files in a Windows Folder in Excel Worksheet

Many users need to quickly list all files in a Windows folder and all of its subfolders in an Excel worksheet. Therefore, in this article, we will introduce you 3 rapid ways to realize it. If you want to recursively list all files in a Windows folder in an Excel worksheet, you'll surely dislike copying the file names to Excel manually. Undoubtedly, it is too tedious and time-consuming. Hence, here we will teach you 3 much smarter and more convenient approaches Method 1: List Files in a...

Read more »