WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        331 results for excel 2003 crashes when entering data windows 10

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

        331 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 12.7K 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 7.5K 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 41.1K 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 13.5K 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 8.5K 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 8.4K views
        Format cells

        Format cells

        04:42

        Format cells

        Cell formatting is very important in data processing. We often need to set a proper cell format when entering data in WPS Spreadsheet. Let's talk about the differences between each format. Take this table as an example. Most of the cells in column B of the table are in general format. General format cells have no specific number format, which are simply displayed as numbers. In this table, most of the Column B cells are in general format. The format of cell C2 is a numeric format.....

        Spreadsheet 20.5K views
        Use the DATEDIF function to calculate the intervals of dates

        Use the DATEDIF function to calculate the intervals of dates

        03:12

        Use the DATEDIF function to calculate the intervals of dates

        The DATEDIF function is mainly used to calculate days, months, or years between two dates. Now we are going to use this table to show you the usage of this function. This table records the entry date of the company’s employees. Now we want to calculate the employee’s year of service. We can first click cell C2 and then click Insert Function. Insert DATEDIF in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up.Start dat....

        Spreadsheet 24.3K views
        Prev 1 2 3 ... 41 42 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube