WPS Use skill Four

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: automatic conversion of RMB capital

For the financial staff who face a lot of data every day, the conversion of the number format to the RMB capital format may be their daily work, if the use of a function to set the renminbi capital format, the complexity is needless to say, some friends do not even use the function, manual input is more time-consuming and error prone. 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 not hard to find on the keyboard.


WPS Skill Three: Quick wrap in cell


Do you know how to do a newline in a cell? Do you hit the ENTER key every time in vain, and then you find the cursor running to the next line of cells? In fact, the skilled know to use "ALT + Enter" key combination to achieve, but I am afraid such a few proficient. 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.

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.