Office Solutions

2 Simple Methods to Select All Non-blank Cells in an Excel Worksheet

In an Excel worksheet, if data is entered in nonadjacent cells, you may discover it a bit troublesome to select and copy the data in non-blank cells. Now, in this post, we will introduce 2 ways to quickly select all non-blank cells. Excel users are frequently required to copy and paste data. However, sometimes, there may be some troubles. For example, there are multiple discontinuous blank cells in an Excel worksheet. In this case, it is a bit hard to select all the cells which have content....

Read more »

How to Auto Export the Specific Incoming Emails as Word Documents in Outlook

Some users often need to export the specific incoming emails as Word documents. In this article, we will introduce a method that can configure Outlook to automatically accomplish this task. In general, for the extremely important emails, users are accustomed to storing them in the local folder as a text file or Word document. Unquestionably, it is too troublesome to export the vital emails manually every time. Therefore, here we'll share an approach which can let Outlook auto get it. Auto...

Read more »

2 Means to Batch Apply the Format of One Chart to the Others in Your Excel Worksheet

At times, you may want to batch apply the format of one chart to all the others in an Excel worksheet. In this article, we will expose 2 quick methods to you. Perhaps you have created a lot of charts in an Excel worksheet and these charts may be in different formats. For instance, some are pie charts, some are column charts and some are line charts. Now, you may want to unify the formats of all the charts. You wish to copy the format of a chart to all the other charts in the sheet. In general,...

Read more »