Office Solutions

How to Save Your Time by Utilizing Auto Text Expansion in Excel

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...

Read more »

How to Password Protect Specific Ranges in Your Excel Worksheet

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 »

How to Print Word Documents with Background Colors or Images

In today’s article, we are going to show you what to do to print your Word document without giving up its background color. In your daily office work, you may come across printing a variety of files. And sometimes you have to print documents with background color or image sometimes. Let’s say, you possibly need to print a Word document in a way as below: By default, however, Word will not print the document with its background color on. Then, how to achieve that goal can be a real...

Read more »