The main knowledge points of this lesson are the following 3 points1. Smart Split Columns can identify the contents and split them. There are four techniques for splitting columns based on text features: Delimiter, Text Type, Keyword, and Fixed Width. 2. Data formats can be standardized in addition to splitting columns. For example, numerical dates can be standardized dates, and numerical formats can be turned into text formats. 3. Ampersand operator and smart filling(Ctrl+E) can merg....

When processing table data, we sometimes need to export the table as an image to send the table information to others for viewing.Take this table as an example. We need to export the contents in the table as an image to send to the leader for review. Head to the Tools tab, and click Export to Picture. The exported image defaults to Long picture, and the table will export All pages by default in the pop-up dialog. You can find that the preview interface on the right is incomplete. At th....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out. First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate. Here is a smart way for adjusting tho....

In our life and study, we often need to copy the text content of different pages to WPS Document in order to save records. Sometimes copying and pasting text into WPS Document can lead to a messy layout of the content, and also the font size may not be uniform. In this case, we can use the Clear Formatting function. It can clear all the formats of the selected text and only keep the unformatted text. Take this document as an example, the text has a messy layout, and also the font size ....

When using WPS Presentation, we often need to edit text content in the text box. So how can we insert a text box? First, click the Insert tab above and click the Text Box drop-down button. Here, we can choose to insert a Horizontal Text Box or a Vertical Text Box. This video of How to insert and set a text box will only take the horizontal text box as an example, which could be compatible with Microsoft Office powerpoint. Click Horizontal Text Box and then long-press the left mouse but....

When designing slides, adding the same animation to similar text or shape elements can effectively unify the overall style of the slides. Here is how we can quickly copy animation effects with the Animation Painter tool in WPS Presentation. Take this slide as an example. In this slide, except for the first image, no animation has been added to the rest of the images. At this time, we only need to select the first image and click the Animation Painter button under the Animation tab.Then....

We can process and edit documents more quickly by flexibly using shortcut keys.Then, how can we customize shortcut keys in WPS Office？ First, click Menu and Options to enter the Customize Ribbon interface.You can see Keyboard shortcuts in the lower-left corner. Click Customize to take you to the custom settings dialog. Take Insert Picture as an example. Head to the Insert tab in the left categories, and then find Insert Picture in the corresponding commands on the right.You can see th....

The various filling effects added to the text can beautify the slide while emphasizing the text. So, how can we add and set the text fill? Select the text, click the Text tool tab and the Text Fill button. Here, we can fill the text with different effects, including Solid fill, Gradient fill, Picture or texture fill and Pattern fill. We can choose from a variety of colors recommended by WPS Office for filling the text quickly with one click. If you want to choose more kinds of colors, ....