Use the text function to extract characters in cells

In this video, we'll introduce three practical functions in excel, which are the RIGHT, LEFT, and MID functions.In this example, if we want to extract the first three numbers on the right, how can we realize it? The RIGHT function could help. It can extract characters within a cell, from the right to the left. Here is the complete formula of the RIGHT function. RIGHT(text,num_chars) The first parameter text refers to the specific text to be extracted. The second parameter num_chars....

How to clear content format and comments for cells

When we use the WPS Spreadsheet to work, we sometimes need to clear the content of the table quickly. How can we realize it? This video could help to solve this problem. Take this transcript as an example. 1. To clear all contents within the table, select the area that needs to be cleared.2. Click the Clear dropdown button in the Home tab, and choose the All option to clear the table as needed. (Notes: We can also use the Clear function in this step. To realize it, select the area, and....

How to lock and unlock cells in WPS Spreadsheet

If you have a worksheet for others to fill in, while you don't want certain important data to be modified, the Protect sheet function in WPS Spreadsheet can help you. To lock the entire sheet, get into the Review tab first. If you see the Lock Cell button grayed out, it means that the entire sheet has been locked by default.Next, click the Protect Sheet button, set the password, and click Confirm the setting. Then the sheet formally enters a locked state, and the sheet cannot be ed....

How to convert Excel to PDF

PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

How to fill cells with pure colors, gradient colors, and patterns

When using WPS Spreadsheet to write a statistical data report, we may want to emphasize the cell data. To do this, we can fill the cell with background color and pattern.Take this table as an example. 1. If we want to fill the B3:G3 cell with color, select this area first.2. Click the Home tab above.3. Then click Settings.4. And finally click Cells. Or we can use the shortcut key Ctrl+1 to open the Formats Cells dialog box. · Pure colorClick Patterns, then we can choose a pure color to....

How to insert and set pictures in WPS Spreadsheet

When using WPS Spreadsheet, we often need to add pictures for a more visual presentation. So how can we insert a picture into the table? Select the cell where you want to insert a picture, click the Insert tab, and then click Picture. Here we can choose Floating Picture or Embed to Cell. Floating Picture allows pictures to float above cells, then we can move and resize the picture at will. Embed to Cell is to pin the picture within a cell. We can't move the picture but only control....

How to adjust the overall width and font position of the table in WPS Writer

After we create the table in a document, we can adjust the size of the cells and the position of the text in the table.Take this table as an example. We move the mouse cursor to where the table is located and click the cross button in the upper left corner to select all cells. Click the Table Tools tab and the Table Properties button, then a dialog box will pop up.In the Cell tab, find Size and check Preferred width. We can also adjust the width of all cells after entering the value ac....

How to create a Form in spreadsheet

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....