How to faster WPS table data entry speed

Source: Internet
Author: User

We want to make WPS form data entry faster, here are two tips:

First, reduce the number of mouse dependencies and invalid keystrokes
We may have done a lot of "hard work" typing data into the WPS form, but we didn't notice it. Input data, the general choice of horizontal input or vertical input. Horizontal input and vertical input can be used on the keyboard "tab" key and "Enter" key to switch to the next cell to continue typing.
Why do we do a lot of "hard work" when we input data? When we entered horizontally, F1 cell input to switch to A2 cell when the key will need to keystroke many times, with the mouse, the hand will leave the keyboard. Vertical entry also has such a problem.
To speed up entry, you need to reduce the number of mouse dependencies and invalid keystrokes. The methods described below can effectively reduce the number of keystrokes on the mouse when data is entered. Select the cells you want to enter data with the mouse, and the cells that appear as anti-white are the active cells.
Then start to input data, the active cell record, if you choose to enter data across the keyboard to the "tab" key to switch to the next cell; If you choose to vertical input data, keep pressing the ENTER key on the keyboard to switch to the next cell. If you have a cell in the front of the error, you can press the "Shift+tab" key or the "Shift+enter" key on your keyboard to return and select the cell that entered the error. (www.3lian.com)
Second, batch input the same data and formula
With the mouse to select the need to enter the same data or formula cells, in the formula bar input data or formulas, and then press the "Ctrl+enter" key on the keyboard can be. To enter the same formula as an example, select the bulk input formula cell, and then in the formula bar, type the corresponding formulas for the active cell, press the "Ctrl+enter" key on the keyboard.
  

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.