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
      • excel 2003 crashes when entering data windows 10

      19 results for excel 2003 crashes when entering data windows 10

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

      19 results for excel 2003 crashes when entering data windows 10

      How to view two sheets side by side

      How to view two sheets side by side

      01:09

      How to view two sheets side by side

      When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.· Step one: Create and view two sheets side by sideFirst, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are presenting the same file. No matter which one is edited, the changes can be....

      Spreadsheet 68 views
      Data Format-Scientific Notation

      Data Format-Scientific Notation

      02:03

      Data Format-Scientific Notation

      In WPS Spreadsheet, scientific notation is normally applied to data so as to compute more digits yet save more spaces. Today we will introduce how to apply scientific notation format to data in cells.You can use the following methods:When entering large numbers, we can manually adjust the column width of the cells . By doing so, the number will display in scientific notation format automatically. In scientific notation, the power of 10 is generally expressed by E. For example, the numb....

      Spreadsheet 2 views
      WPS Spreadsheet basic editing

      WPS Spreadsheet basic editing

      02:12

      WPS Spreadsheet basic editing

      This video introduces the basic editing operations of the table, mainly including data input in alternate rows and columns, the insertion, deletion, hiding and unhiding of rows and columns. Many beginners use the mouse to click on a cell and then enter the content when entering data. Here is a quick way to teach you how to do this. After entering the first data, press the Enter key to input data in alternate rows. Press the Tab key to input data in alternate columns. We can also click ....

      Spreadsheet 1,024 views
      Use the Mail Merge function to input tabular data quickly

      Use the Mail Merge function to input tabular data quickly

      01:49

      Use the Mail Merge function to input tabular data quickly

      WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types. Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge fun....

      Writer 383 views
      Set input conditions and drop-down menus

      Set input conditions and drop-down menus

      01:54

      Set input conditions and drop-down menus

      The Data Validation feature of the WPS Spreadsheet can help us quickly complete the setting of input conditions and drop-down menus, thereby improving the accuracy of our input data.Take this form as an example. Now we need to enter a 9-digit US passport number in column C. We can use Data Validation to improve the accuracy of our input data.1. Select the cell range, then click the Data tab. 2. Click the Validation drop-down button.3. Now select the Validation option in the drop-down m....

      Spreadsheet 173 views
      How can we use the data validation feature

      How can we use the data validation feature

      02:46

      How can we use the data validation feature

      We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Take this table as an example. This is the information collection form for US citizens joining tour groups for international travel. We need to fill in the information of all the participants. How can we ensure that the passport numbers and phone numbers we entered will not be wrong? 1. First, select the cell area where data needs to be filled.2. Click the Data tab.3.....

      Spreadsheet 1,890 views
      Use the fill handle to quickly enter data

      Use the fill handle to quickly enter data

      02:59

      Use the fill handle to quickly enter data

      AutoFill can help us quickly enter some regular data, which is an essential skill in using WPS Spreadsheet to deal with different data. It includes Fill Numerical Value, Fills Data, Fill Text, Custom Text Filling, and Fill Formulas.Take this table as an example. If we want to fill in the numbers 1 to 10 in column A, select cell A2 and move the cursor to the lower right corner of cell A2. At this time, the cursor will turn into a small black solid cross. Press and hold the left mouse bu....

      Spreadsheet 594 views
      Table rows, columns, cells, and status bar

      Table rows, columns, cells, and status bar

      03:27

      Table rows, columns, cells, and status bar

      In the last video, we just talked about the worksheet and workbook in the WPS Spreadsheet. So in this video, we will learn about the Spreadsheet interface elements: rows, columns, cells, and those tools in the lower status bar.On the left is the row, and the marked numbers 1, 2, and 3 are called the row number. Above is the column, and the marked numbers A, B, and C are called the column number. The grids in the middle are called cells.When expressing the position of a cell, we use col....

      Spreadsheet 263 views
      Prev 123 Next
      WPS Academy