Office Solutions

2 Quick Methods to Copy Contents to Multiple Worksheets in Your Excel

Often you will input same contents into several worksheets. Here we have two methods to finish this task quickly. In our previous article 2 Quick Methods to Input Duplicate Column Headers in Excel, we have introduced two methods to input same contents into several different worksheets. Now we have found another two methods. Method 1: Insert across Worksheets The first method will also use the feature of worksheet group. And in this method, the contents are already existed in one of the...

Read more »

Why and How to Define Names for Certain Cell Ranges in Your Excel

Names are very useful in Excel. And today we will talk about the names of certain ranges. The range in Excel can be a cell or a certain part in Excel. You can certainly refer to a certain range by using the row numbers and column numbers. But on the other hand, you can also define a name for a certain range that you will refer to. If you delete a row or a column, the row and column number of target range will change. And this may produce errors in formulas that will refer to this range....

Read more »

How to Change the Default Journal Entry Type in Outlook

By default, when you create a new journal entry in Outlook, it will always start with “Phone Call” type. If you would like to change the starting entry type, this article will provide you an effective and handy workaround. In reality, Outlook comes endowed with the regulation to begin with “Phone Call”. But if you indeed wish to change the default journal entry type, there is an easy workaround. That is to change the description of “Phone Call” in the Registry Editor. Now follow...

Read more »