Office Solutions

2 Easy Ways to Consolidate Rows in Your Excel

When analyzing the data in Excel, you may find it contains multiple duplicate rows. In this case, perhaps you'll want to quickly consolidate the rows. This post will offer 2 quick means to get it. Many users frequently need to merge the duplicate rows and sum the according values in Excel. For instance, I have a range of data in an Excel worksheet which contains a plenty of duplicate entries, like the following screenshot. Hence, I wish to consolidate the duplicate rows and sum the...

Read more »

How to Auto Log Each Printed Outlook Email in Excel Workbook

Some users hope to auto save logs of printed emails in their Outlook. However, there is not such a direct feature available. Hence, in this article, we'll introduce a way to auto log each printed email in a specific Excel workbook. For some reasons, you may need to record the information of an email when you print it. Obviously, Outlook doesn't provide a native feature supporting this. Thus, in general, you have to manually accomplish this task. Nevertheless, with the help of VBA code, you...

Read more »

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 »