WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to remove strikethrough in excel

    3019 results for how to remove strikethrough in excel

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    3019 results for how to remove strikethrough in excel

    How to convert Excel to PDF

    How to convert Excel to PDF

    02:50

    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....

    Spreadsheet 6.1K views
    How to insert calculated fields in PivotTable

    How to insert calculated fields in PivotTable

    01:06

    How to insert calculated fields in PivotTable

    Take this sales performance table as an example. We want to generate a new column, "sales commission" based on this PivotTable. (Tips: Sales commission is equal to sales amount multiplied by 0.08.) So, how do we do that? First, we click the Options tab, and the Fields, Items drop-down button, select Calculated Fields, then the Insert Calculated Field dialog will pop up.In the Name edit box, input "Sales commission". In the Fields area, choose Sales amount. In the Formula edit box, inpu....

    Spreadsheet 2.3K views

    How to write strikethrough text in excel

    How to write strikethrough text in excel-WPS Academy Strikethrough formatting is rarely used, but it is a very useful font formatting for most applications. Strikethrough fonts are a great way to visually indicate that something has been deleted, deleted, or no longer relevant, without actually removing it from the text. This formatting option is also available in Excel, but unfortunately, it is not available directly from the ribbon commands. However, it is possible to access it in a ....

    xls Spreadsheet 1.7K views
    How to add a cover page in WPS Writer

    How to add a cover page in WPS Writer

    00:47

    How to add a cover page in WPS Writer

    WPS Writer is a terrific tool for adding a cover to your resume or report if you want them to have a great impression on others. How can we add a cover page to a document?We can turn to Cover Pages in the Section tab or click Cover Pages in the Insert tab. Click the Cover Pages button in the drop-down list, and we can see that there are different kinds of covers to choose from, including Business, Resume, Thesis and Transverse. After selecting the cover page, we can change the build-i....

    Writer 2.5K views
    How to group objects in WPS Spreadsheet

    How to group objects in WPS Spreadsheet

    01:20

    How to group objects in WPS Spreadsheet

    In the workplace, we sometimes need to adjust the objects in WPS Spreadsheet uniformly. In today's tutorial, we will learn how to group multiple objects in excel.For example, moving the figure in the upper left corner as a whole will separate the header and the content box.To solve this, we can hold down the "Shift" key to select both the header and the content box. Then the ribbon will switch to "Drawing Tools," where you can click "Group." This button can also be found in the sho....

    Spreadsheet 1.8K views
    How to use OCR in PDF

    How to use OCR in PDF

    02:12

    How to use OCR in PDF

    Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....

    PDF 7.6K views
    How to consolidate data in WPS Spreadsheet

    How to consolidate data in WPS Spreadsheet

    01:28

    How to consolidate data in WPS Spreadsheet

    In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....

    Spreadsheet 5.9K views
    How to create a Form in spreadsheet

    How to create a Form in spreadsheet

    01:26

    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. ....

    Spreadsheet 2.8K views
    Prev 1 2 3 ... 377 378 Next
    WPS Academy
    Products
    Partners