After getting in touch with WPS, we know that Ctrl+C copy and Ctrl+V paste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters’ relationship and quickly fill cells. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. · 1. Extract charactersIn this table, we want to extract all the names in the sentences. First, enter the name that appear....

We sometimes need to deal with tables containing various content. Then we may find it troublesome even to use the fill handle to pull down and fill. Here, we will introduce two convenient methods to you. The first method is to double-click the fill handle. After filling the first data in column A, double-click the fill handle, then the data will be automatically filled in sequence order. Now we can see the data has been filled automatically in the row range of column B. In the digital ....

When using WPS Spreadsheet to process data, we can customize cell format with codes. In this video, you will learn about several practical codes for custom cell format. Take the worksheet here as an example. Select Column E, right-click on it and choose Format Cells in the menu. You can also use the shortcut key Ctrl+1 to pop up the dialog. Get into the tab of "Custom". Then we can see "m/d/yyyy" in the input box. Here "m", "d", and "yyyy"are respectively placeholders for month, day, a....

In WPS free PowerPoint tutorial, learn how to use themes and background styles of preseatations, and do more to create standout presentations. All WPS Presentation tutorials are free for students, teachers, business users and more and can be downloaded free in Windows, PC, Mac, Linux, Android, and iOS devices. Chemical elements and mathematical formulas are sometimes needed in slides during the learning process. These coursewares cannot be separated from the superscript and subscript f....

When we use the WPS Spreadsheet, we often need to merge and combine multiple cells. Merge and Center in WPS spreadsheet offers multiple merging methods. We will explain in detail how to use this function. · Merge and CenterSelect the cell area to be merged, click Home and find the drop-down menu of Merge and Center, and select Merge and Center or press keyboard shortcut Ctrl+M. In this way, the selected cells can be merged into one cell and displayed in the center. · Merge CellsSelect ....

When sharing a document, if we do not want others to edit the document, we can take many measures to limit the document's editing. Here, I will introduce you to one of the ways: Export to Picture. Microsoft Word can not save the document as a picture format directly.But, we can still save the document to picture through more tedious procedures. First, press Ctrl+A to select the document content, and press Ctrl+C to copy the desired content. When we press Ctrl+V to paste the content....

During study and work, WPS Presentation is often needed to make a PPT. What makes a high-quality PPT during a short time? In today's tutorials, we will learn a few quick tips commonly used in creating slideshows and thus improving efficiency. · Create a new slideSelect any slide, use the shortcut key Enter, or press Ctrl+Enter together to quickly insert a blank slide. · Delete the current slideSelect the current slide and use the shortcut key Delete or press Ctrl+Delete to remove i....

How can we insert or delete pages of the original file when editing a PDF file?Take this file as an example. Click the Page tab, then click the Insert Pages drop-down menu. Here, we can choose to insert a Blank page. Its shortcut key is Ctrl+Alt+I.In the popup dialog box, we can set the size, direction, number, and insertion position of the new page. Click OK to insert a blank page.We can also create a new page from the file by Select from PDF. Its shortcut key is Ctrl+Alt+T.After sel....