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 Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

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

Learn more >

Alibaba Cloud Free Trial

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

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.