Office Solutions

How to Insert Different Types of Separators into Your Word Document

Tired of all these horizontal lines? Relax! This article will show you how to insert different types of separators in your Word document. We use Word for word processing. But reading all those pages of document without decoration can drive you crazy. As a matter of a fact, there are many occasions when we need some dividers to make our files look good. For example, you may need vertical lines for your multi-column Word document. And when you make some brochures, you certainly want them...

Read more »

How to Manually Input Texts into a Cell with Drop-down List in Excel

Some features in Excel may cause confusion to us. And here we have solved the problem with the drop-down list in Excel. In our previous article “How to Create Multiple Choice Questions in an Excel Form”, we have introduced the steps to create a drop-down list in cells. But sometimes when you input texts other than those in the drop-down list into the cell, Excel will show an error message. Below is an example: In this example, the cells in the first column have drop-down lists. And...

Read more »

How to Customize and Use Your Own Cell Styles in Excel

Excel enables users to modify the default settings according to actual needs. Thus, in this article, we will discuss about the cell styles in Excel. In an Excel worksheet, the cell styles sometimes can represent special meanings. For example, you will use the color grey to indicate that this cell is the first cell of an area. And the format will be applied according to your own habit and preference. What’s more, in Excel, there are already some predefined cell styles for you to choose....

Read more »