Office Solutions

5 Quick Ways to Split a Table in Your Word Document

In the following article, we will introduce you 5 quick and effective ways to split a table in your Word document. Once in a while, you will meet the need to split a table into several for varying reasons, be it for privacy or teamwork. Anyway, you should know Word is totally capable of this operation and there is more than one way to complete the task. For instance, we catalog our 5 methods into 2 categories. Category 1: Split a Table Horizontally Splitting a table in horizontal way is...

Read more »

3 Effective Ways to Align and Anchor Texts in Your Word Document

In this article, we have 3 effective ways available not only enabling you to align but anchor texts in a certain place in your Word document. Every time we create a Word document, we don’t just pile up words, but have to take care of the file format. And one thing is to align texts, be it to left, center, or right. You could possibly use it when create a table of content, a resume, or a questionnaire. Then here is a question: how can you align texts and make them stay at a...

Read more »

How to Search for Values via HLOOKUP or VLOOKUP Functions in Your Excel Worksheet

We will introduce HLOOKUP function which will return the cell value in a column whose column header matches a specific criterion. We will also compare it with VLOOKUP, another similar function but searching vertically. HLOOKUP function is a seldom mentioned Excel function. Actually this function is a variant of the standard LOOKUP function, and “H” means horizontal. Given a range of tabular data, the function will search in the top row with the specific criterion, and return the value...

Read more »