Excel has many hidden functions that enable this software to be a good helper. Thus, here we will discuss about the auto text expansion in Excel.
In Excel, you will find that sometimes you will misspell some words. However, if you press “Enter” button or click other cell before you want to correct it, the word will automatically change into the right form. Therefore, you don’t need to enter the word for twice due to the small typo. This is achieved by the feature replace text in Excel. And...
Read more »
The protected worksheet can protect data security very well. In addition, we will show you how to edit specific ranges in a protected worksheet.
In our previous article, we have talked about protecting worksheet. And you may refer to it to see how it works: How to Protect Your Excel Worksheets with Passwords. But sometimes you need to send this file to other people, and they will modify certain area. For example, in this file, you need those sales representatives to check their sales...
Read more »
If you receive a distribution list in Outlook, would you like to save and convert it to individual contacts, instead of a group? This article will introduce an effective and efficient method to you.
When I receive a distribution list, I prefer to expand the group in the message and then add them individually to my contacts folder. To be honest, it will take me a great deal of time. I look forward to a handier and quicker approach.
Step 1: Save the Distribution List as Text File to Your...
Read more »
