# WPS2007 Use tips 4

Source: Internet
Author: User
Tags relative

WPS Office 2007 Simplified Chinese version, complete desktop Office features, easy to learn Easy-to-use fully compatible office, flexible enterprise automation components, secure and reliable document application processing.

WPS Skill One: RMB capitalization automatic conversion for financial personnel facing large amounts of data every day, converting the number format into renminbi capital format may be the work they do every day, if the format of the renminbi is set by the function, the complexity is needless to say, and some friends do not even use functions, Manual input takes a lot of effort and is prone to error. Isn't there a good solution? The answer is yes. The WPS table provides us with the renminbi capitalization conversion function, simply set, the input number can be automatically converted to the corresponding including rounded cents in renminbi capital.

WPS technique two: F4 key toggle Absolute/Relative reference

Using formula calculations in a table is something that you often encounter, and the switch between relative references and absolute references, I believe most friends will encounter, at this time, how do you operate? Is it hard to find on the keyboard.

WPS Skill Three: Quick wrap in cell

Do you know how to do a newline in a cell? Is it always a futile hit enter, and then annoyed to find the cursor ran to the next line of cells? In fact, the skilled know to use the "ALT + Enter" key combination to achieve, but I am afraid such a few skilled. Now let me tell you a good way: in the WPS table, you can easily break the form by simply clicking the "Wrap" button on the toolbar.

WPS Technique four: Multi-row multi-column bulk Merge

When we were working on the form, sometimes need to combine more than one row or more columns of data, and the table data is more, at this time we think if there is a tool for me to bulk merge multiple rows and columns, the WPS table "Cross-column merge" Can help us to do.

We want to merge multiple rows and columns of data at once, just select the columns, the data in the row, click Cross Column merge, and all the selected column cells are merged into one column, and the number of cell rows remains unchanged. In the following figure, we just want to keep the contents of column A, we can click the "Center Across Columns" button, and the contents of multiple rows and columns are automatically merged into one column, so you can enter descriptive text in the first merged column.

Related Keywords:
Related Article

## E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

## Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

## Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth \$300-1200 USD