Tips: Four tips for using WPS_Huajun Software Park

Tips: Four tips for using WPS

Author: Ai Xiaomo Date: 2024-05-11

WPS Office 2007 Simplified Chinese version, complete desktop Office functions, easy to learn and use, fully compatible with Office, flexible enterprise automation components, safe and reliable document application processing.

WPS Tip 1:Automatic RMB capitalization conversion For financial personnel who face a large amount of data every day, converting digital formats into RMB capitalization format may be their daily work. If you set the RMB capitalization format through a function, it goes without saying that the complexity is high. Friends don’t even know how to use functions, and manual input takes a lot of energy and is prone to errors. Isn't there a good solution? The answer is yes. The WPS form provides us with the RMB capital conversion function. With simple settings, the entered numbers can be automatically converted into the corresponding RMB capital including rounded corners and minutes.

WPS Tip 2:F4 key switches between absolute/relative references

It is common to use formula calculations in tables, and I believe most of my friends will encounter switching between relative references and absolute references. At this time, how do you operate? Are you searching hard on the keyboard?

WPS Tip 3:Quick line wrapping within cells

Do you know how to wrap lines within a cell? Do you hit the Enter key every time in vain, and then find to your chagrin that the cursor has moved to the cell in the next row? In fact, experienced people know how to use the "Alt+Enter" key combination to achieve this, but I'm afraid there are very few such experienced people. Now let me tell you a good way: in the WPS table, you can easily wrap the table by just clicking the "Automatically wrap" button on the toolbar.

WPS Tip 4:Batch merge of multiple rows and columns

When we are processing tables, we sometimes need to merge data from multiple rows or columns, and this table has a lot of data. At this time, we thought it would be great if there was a tool that allowed me to merge multiple rows and columns in batches. The "cross-column merge" of WPS tables can help us do it.

We want to merge data in multiple rows and columns at one time. We only need to select the data in these rows and columns and click "Merge across columns" with the mouse. All the cells in the selected columns will be merged into one column, and the cells The number of rows remains the same. As shown below, if we only want to keep the content in column A, we can click the "Center Across Columns" button, and the content of multiple rows and columns will automatically be merged into one column. At this time, you can enter a description in the merged first column. of text.

Tips: Four tips for using WPS

Related articles

Hot recommendations this week More