Bulk canceling manual wrapping in the WPS table

Source: Internet
Author: User
Tags manual

In the WPS table, we often use the manual newline character, which is to force the line break by pressing Alt+enter or pressing the line-wrapping button on the toolbar during the entry. How do you cancel a forced line break if you don't need it? There are two ways we can implement this, as described below.

One, the automatic line-wrapping button is invalid to the manual line break

1. Select the area to which you want to cancel line wrapping.

2, click the "Wrap" button on the toolbar.

This method works for both wrapping and wrapping, but the manual newline character is not deleted, as you can see from the formula bar, as shown in Figure 1.

Fig. 1 The WPS Table Manual wrapping Demo

Second, flexible use of replacement function to remove line breaks

1. Find a cell with a manual line break and remember where the line breaks are located.

2. Press the CTRL + C key to copy this cell.

3, press Ctrl+h key combination to bring up the replacement dialog box.

4, in the "Find Content" text box press CTRL + V to paste the content just copied.

5. Position the cursor to the beginning of the Find what text box, press the DEL key to delete the contents of the line break, position the cursor to the end of the Find what text box, and press BACKSPACE to delete the content after the line break. Note that line breaks are not visible and are based on the position of the line break that you noted earlier.

6. Delete the contents of the "Replace with" dialog box-if available, press the "Find Next", "replace" or "Replace all" buttons as needed to remove the manual line break.

This method removes the manual newline character and has no effect on the line wrap set in the cell format.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join

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.