Several methods of fast data entry

Source: Internet
Author: User
Tags time and date

1. Find replacement (if there is a very high frequency in which a phrase and name appear, we can choose another character instead of the condition that this character will not appear in our form)

2. Do not enter the decimal point method: Tools menu; options; edit tab; automatically set the decimal point number, then remember to change back after the loss.

3. Shortcut key Input Method: A. Copy and paste the contents of the previous cell; Ctrl+d with a shortcut dish; B.. ALT + (number on a small numeric keypad); C. Enter the time and date of the current system, using the shortcut key CTRL + Semicolon; Enter the time of the current system ctrl+shift+ semicolon Note: How do you know what the number of these symbols is? I have the code function to do it.

4. By setting the list of automatic Input method: Select the list area you set up, right-click, create a list of notes: The amount is the first cell must enter the formula, the other is not, will automatically fill

5. Custom sequence Fill method: Tools menu, Options, Custom Sequence tab, enter the special sequence you want to fill. There are 8 people in your department, you define such a sequence, you will not have to input, enter a person's name can be populated

6. Automatically switch Input method: For example, select the cell under Name, the data menu → validity → ime mode tab, select Open in the Mode Drop-down list box, and click OK. Then choose English Edit column, above steps, bring up "input mode" tab, in the "mode" Drop-down list box, select "Close (English mode)", click OK button OK

7. Automatic Correction Method: Tools menu, AutoCorrect options, replace input you want to correct the content, in the replacement for the input you want to correct the content

8. Alt plus down the direction of the key method: such as D20 cell has no data, it has data, select D20 Cell, alt plus the direction of the downward key, selected above has been lost a

9. Data validation Input Method: Select the validity of the range of cells you want to set, Data menu, effectivity, Settings tab, set selection sequence, source input male, female notes: Between men and women the comma must be entered in a half-width state of numbers and punctuation.

F5 positioning null value and CTRL + Return bulk fill such as method: Selected area G12:g24,f5 positioning, conditional positioning, null value, in the G12 cell input =g11 cell, remember the cursor must be in the formula bar, CTRL return

11 Format Cell Formatting input methods: Select the range of cells you set, right-click, format cells, number tabs, categorize, customize, type lose. Title: A. Select General, and then customize: g/Universal format "slice" B. Custom unit 0; Not fit "; 0;@

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.