Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • how to remove div 0 in excel

      308 results for how to remove div 0 in excel

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

      308 results for how to remove div 0 in excel

      How to enter a number starting with 0 in the Spreadsheet

      How to enter a number starting with 0 in the Spreadsheet

      01:38

      How to enter a number starting with 0 in the Spreadsheet

      The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

      Spreadsheet 576 views
      Why error message #DIV0! occurs and how to solve it

      Why error message #DIV0! occurs and how to solve it

      02:27

      Why error message #DIV0! occurs and how to solve it

      When calculating data with WPS Spreadsheet, the error message #DIV/0! will come to us from time to time.What caused the mistake? And how can we remove it? Take this table as an example. For example, when we want to calculate the unit price of pencils, we can enter =C3/D3 in cell E3, and the calculation result will show the error value #DIV/0! This is because, in this division operation, the denominator is 0, which leads to the calculation error. When we drop down and fill in the calcul....

      Spreadsheet 3 views

      How to remove duplicates in Excel

      · Highlight Duplicates1. Open the Excel file and select the table area.2. Click the Data tab → the Highlight Duplicates drop-down button → the Set option.3. Then, the Highlight Duplicate dialog will pop up. We click the OK button.4. Now, the repeated contents in cells are set in orange background. · Remove Duplicates1. Select the table area again.2. Go to the Data tab, click the Highlight Duplicates drop-down button, and select the Remove Duplicates option.3. Then, the Remove Duplicat....

      Spreadsheet 1,118 views
      Use the ROUND function to round decimals quickly 

      Use the ROUND function to round decimals quickly 

      01:57

      Use the ROUND function to round decimals quickly 

      In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....

      Spreadsheet 1,363 views
      Display the unit symbol in the formula result

      Display the unit symbol in the formula result

      01:26

      Display the unit symbol in the formula result

      This is a table of information about the department employees. If we need to calculate the average weight of the staff, what should we do?Normally, you only need to enter the formula =AVERAGE(D2:D8) in cell D9 to get the average.However, the formula returns 0, and obviously, the result is incorrect because there are text characters in the cells, which affects the accuracy of the calculation. Do you know how to retain the weight unit and normally perform the calculation at the same time....

      Spreadsheet 9 views
      How to set custom symbols and symbols shortcut key in WPS Spreadsheet

      How to set custom symbols and symbols shortcut key in WPS Spreadsheet

      01:51

      How to set custom symbols and symbols shortcut key in WPS Spreadsheet

      When using tables to enter data, if we often need to enter symbols, we can set shortcut keys for commonly used symbols, which can improve our work efficiency. Take this size chart as an example. We need to enter the length unit cm multiple times, so how can we get a quick input? Click the Home tab, and the Symbol drop-down button, then click More Symbol to pop up a dialog box. Click the Custom Symbols tab, and then we can see that there are many system-defined symbols, including the cm....

      Spreadsheet 237 views

      How to remove the highlighted area in a PDF file

      1. Use WPS Office to open the PDF file, and select the highlighted area.2. In the small pop-up window, click the remove icon. To be office specialists, you could learn how to use WPS Office online in WPS Academy.

      PDF 1,464 views

      How to remove the dotted line in WPS Spreadsheet

      There are two reasons that users will see dotted lines in WPS Spreadsheet.· Reason 1: Page breaks1. Open the spreadsheet in WPS Office, then click Menu → Options in the upper left corner.2. Click View and uncheck Page Breaks in the Options popup window.· Reason 2: The dotted line generated after print preview1. Open the spreadsheet in WPS Office.2. Click Page Layout → Print Area. 3. And then select Set Print Area to remove the dotted lines.To be an office excel advancers, you could lea....

      Spreadsheet 1,004 views
      Prev 123...3839 Next
      WPS Academy