WPS is a lightweight, efficient and free mobile office software. So you have some tips for using WPS. Today, the editor will introduce you to the tips for using WPS. Friends in need, come and watch!

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 the RMB capitalization format is set through a function, the complexity goes without saying. Well, some friends don’t even know how to use functions. Manual input takes a lot of energy and is error-prone. 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 to switch absolute/relative reference

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: Quickly wrap lines in cells

Do you know how to wrap a line in a cell? Do you hit the Enter key in vain every time, and then find to your chagrin that the cursor has moved to the cell in the next line? In fact, experienced people know to use the "Alt+ Enter" key combination to achieve this. , but I’m afraid there are very few such experienced hands. 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.

The above is what the editor said aboutI hope this sharing of WPS usage tips will be helpful to everyone. For more exciting tutorials, please pay attention to Huajun Software Park.