WPS text is one of our commonly used office software. Because of its simplicity and practicality, it is deeply loved by the majority of users. When we edit a document, we sometimes need to insert a table into the document to compare or assist in explaining certain data. At this time, we need to count some of the data results in the table.
Quick entry method of wps table data
1. Reduce dependence on the mouse and the number of invalid keystrokes
We may have done a lot of "useless work" when entering data in the WPS form, but we didn't notice it. When entering data, generally choose to enter horizontally or vertically. For horizontal input and vertical input, you can use the "Tab" key and "Enter" key on the keyboard to switch to the next cell and continue typing.
Why do we say that we do a lot of "waste work" when entering data? When we enter data horizontally, when we want to switch to cell A2 after entering cell F1, we need to press the keys many times using the arrow keys. When using the mouse, our hands have to leave the keyboard. . Vertical entry also has the same problem.
To speed up typing, it is necessary to reduce reliance on the mouse and the number of invalid keystrokes. The method introduced below can effectively reduce the reliance on the mouse and the number of invalid keystrokes when entering data. Use the mouse to select the cell where data needs to be entered. The highlighted cell is the active cell.
Then start entering data. After the active cell is recorded, if you choose to enter data horizontally, keep pressing the "Tab" key on the keyboard to switch to the next cell; if you choose to enter data vertically, keep pressing the "Enter" key on the keyboard. Enter" to switch to the next cell. If there are previously entered cells with errors, you can press the "Shift+Tab" or "Shift+Enter" keys on the keyboard to return and select the cells with errors.
2. Enter the same data and formulas in batches
Use the mouse to select the cells where the same data or formula needs to be entered, enter the data or formula in the edit bar, and then press the "Ctrl+Enter" keys on the keyboard. Taking the input of the same formula as an example, select the cell where the formula is entered in batches, then enter the formula corresponding to the active cell in the edit bar, and press the "Ctrl+Enter" keys on the keyboard.
For the calculation of data in tables, everyone is usually accustomed to using Excel to operate, thus ignoring the table calculation function in WPS text. In fact, the table calculation function in WPS text is equally powerful. It can not only perform quick operations, but also perform complex calculations. Formula operations. After studying it, do you feel the same way?
