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

    2993 results for how to remove strikethrough in excel

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

    2993 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.4K 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.5K 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
    How to set up custom slide shows in WPS Presentation

    How to set up custom slide shows in WPS Presentation

    01:40

    How to set up custom slide shows in WPS Presentation

    When using WPS Presentation, how can we adjust the content and order of the slide show without deleting the original slides or even changing the page order of the original slides? The Custom Slide Shows feature can help us. Click the Slide Show tab at the top of the screen, and click the Custom Slide Shows button. In the popup dialog, click the New button to customize the settings for the slide show.In the popup Define Custom Show dialog, we can enter the name of the custom show in the....

    Presentation 2.4K views
    Prev 1 2 3 ... 374 375 Next
    WPS Academy
    Products
    Partners