- Picture and text skills
Entering data in a form is a tedious task, so how to enter data quickly?
Here are some tips for quickly entering data.
Learn these tips and you will no longer have to worry about office work.
1. Double-click to fill.
When you need to fill in long serial numbers or dates, it is troublesome to manually enter or drag the fill handle down to enter.
At this point you can use the double-click fill method.
￭Take this form as an example. Place the mouse on the lower right corner of B1 and double-click it when it is in a cross shape to quickly fill in the form.
2. Ctrl+Enter batch input method.
If we want to quickly enter the same content, we can use the Ctrl+Enter batch input method.
￭Take this table as an example, hold down the Ctrl key and select the cells that need to be filled.
Use the shortcut key Ctrl+Enter to enter the same content in batches.
3. Set cell format and quickly enter gender.
At work, it is often necessary to enter employee information and it is troublesome to enter gender manually. At this time, you can use the formatting of cells to quickly enter gender.
￭Select the cell and use the shortcut key Ctrl+1 to open the Format Cells dialog box.
Click Customize and enter [=0]"Male";[=1]"Female" in the type.
It should be noted that punctuation must be entered in English half-width mode, so that by entering 0 or 1 in the form, you can quickly enter gender.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/kuai-su-shu-ru-de-ji-qiao-you-nei-xie.html
支付宝扫一扫 
评论列表（196条）
测试