周周记(1):Excel录入怎么又快又准?

周周记(1):Excel录入怎么又快又准?

分享兴趣,传播快乐,增长见闻,留下美好!

亲爱的您,这里是LearningYard新学苑。

今天小编给您带来

【周周记(1):Excel录入怎么又快又准?】

欢迎您的访问!

Share interest, spread happiness, increase knowledge, leave a beautiful!

Dear, this is LearningYard New Academy.

Today Xiaobian would like to share with you my feelings about university.

Welcome to your visit!

周周记(1):Excel录入怎么又快又准?

一、快速填充(I. Quick Fill)

方式(Methods):

(1)开始-编辑-左二下标

Start – Edit – Left Two Subscripts

如图:

As shown in the picture:

周周记(1):Excel录入怎么又快又准?

(2)Ctrl+E

(3)填充柄+右下角快速填充

Fill Handle + Quick Fill in the lower right corner

目的:将表中信息进行提取重组,进行填充(原理:对信息位置的识别)

Purpose: To extract and reorganize the information in the table for filling (principle: identification of information location)

注:表头不可断开。

Note: The table header cannot be disconnected.

二、快速分析(II. Quick Analysis):

方式(Methods):

(1)表格全选

Select all in the table

(2)右下角出现“快速分析”的快捷键,出现分析选项

A shortcut for “Quick Analysis” appears in the lower right corner, with analysis options displayed

如图:

as shown in the figure:

周周记(1):Excel录入怎么又快又准?

(3)选择自己所需要的图表类型

Choose the chart type you need

三、录入数据

III. Data Entry

方式:

Methods:

(1)鼠标键盘手动输入

(1)Manual input using mouse and keyboard

(2)网上爬取

(2)Web scraping

鼠标键盘手动输入

Manual input using mouse and keyboard

周周记(1):Excel录入怎么又快又准?

#tab+enter结合

#Combination of Tab and Enter

步骤:

Steps:

tab-跳转下一个空格(数据的横向导入)

Tab – Move to the next cell (horizontal data entry)

enter-回到第一列单元格(数据输入换行)

Enter – Return to the first column cell (for new line in data entry)

注:tab在某行某列输入后,换行使用enter时,出现空格出现在下一行的该列。

Note: After using Tab to enter data in a specific row and column, when using Enter to move to a new line, a blank space will appear in the same column of the next row.

如图:

as shown in the figure:

周周记(1):Excel录入怎么又快又准?

改善:

Improvements:

1、在行中,输错数据后,按“shift+tab”返回上一个单元,在进行完一行的输入后,“enter”后回到下一行的首列。

1、If data is entered incorrectly in a row, press “Shift+Tab” to return to the previous cell. After completing the input for a row, pressing “Enter” will bring you back to the first column of the next row.

2、shift+enter返回上一行该列。

2、Press “Shift+Enter” to return to the same column of the previous row.

周周记(1):Excel录入怎么又快又准?

1、时间录入

Time Entry:

方式:使用“-”与“/”进行分隔,能被Excel筛选

Method:Use “-” and “/” as separators to enable Excel filtering.

现在时间显示(快捷键):

Current time display (shortcuts):

日期;“Ctrl+;”

Date: “Ctrl+;”

时间:“Ctrl+shift+;”

Time: “Ctrl+Shift+;”

日期+时间:

Date + Time:

(1)“Ctrl+;”中间输入空格“Ctrl+shift+;”

(1)”Ctrl+;” then input a space and “Ctrl+Shift+;”

(2)输入函数“NOW”,回车

(2)Enter the function “NOW” and press Enter.

2、录入百分号

2、Entering Percentages

问题:

Problem:

(1)键盘直接输入40%

(1)Directly entering 40% on the keyboard

(2)方式:输入40+%(%在开始选项卡中的数字组常规中找到百分比)

(2)Method: Entering 40+% (finding the percentage in the General group under the Number tab in the Home tab).

结果:输入40%,变成4000%

Result: Entering 40% becomes 4000%.

解决方式:

Solutions:

(1)输入0.4,加一个单元格格式

(1)Enter 0.4 and then format the cell as a percentage.

(2)选中需要输入百分比的一列或一行,直接把它的格式改为单元格。

(2)Select the column or row where you need to enter percentages and directly change its format to a percentage format.

注:改变小数点位数,方式:开始选项卡右侧

Note: To change the number of decimal places, use the options on the right side of the Home tab.

具体位置如图:

Specific location is shown in the figure:

周周记(1):Excel录入怎么又快又准?

3、录入分数

3、Entering Fractions

问题:1/5,Excel识别成日期

Problem: 1/5 is recognized as a date by Excel.

解决方式:

Solutions:

(1)先输入“0”加空格,再输入1/5

(1)First enter “0” followed by a space, then enter 1/5.

(2)开始选项卡-数字-常规-数字

(2)Go to the Home tab – Number – General – Number

4、身份证/长数据录入

4. ID card/long data entry

认识:Excel最长位数在15位

Understanding: Excel has a maximum limit of 15 digits.

问题:直接输入,超过15位变成科学计数法的格式,超过后的精度变成0

Problem: Directly entering numbers exceeding 15 digits will turn them into scientific notation format, and the precision beyond the 15th digit will become 0.

Understanding: Excel has a maximum limit of 15 digits.

Problem: Directly entering numbers exceeding 15 digits will turn them into scientific notation format, and the precision beyond the 15th digit will become 0.

如图:

as shown in the figure:

周周记(1):Excel录入怎么又快又准?

解决方式:

Solution:

调成文本:输入前,数字组下-常规-文本格式(无法计算,可完整记录)

Set to Text format: Before entering, go to the Number group – General – Text format (unable to calculate, but can record completely).

输入后,在数字前输入英文逗号(文本格式)。

After entering, add an English comma in front of the number (text format).

原位填充:输完文本后,按Ctrl+enter,光标不会下移。

In-place filling: After entering the text, press Ctrl+Enter, and the cursor will not move down.

好处:可任意选择区域进行填充,先选择填充位置,再进行原位填充。

Benefit: You can select any region to fill in data. First select the filling position, then perform in-place filling.

今天的分享就到这里了。

如果您对今天的文章有独特的看法,

欢迎给我们留言,

让我们相约明天,

祝您今天过得开心!

Thats all for todays share.

If you have a unique view of todays article,

Please leave us a message,

Lets meet tomorrow,

Have a nice day!

本文由LearningYard新学苑原创,如有侵权,请联系删除。

参考资料:哔哩哔哩

翻译:文心一言

版权声明:lida 发表于 2024年3月21日 am8:00。
转载请注明:周周记(1):Excel录入怎么又快又准? | ChatGPT资源导航

相关文章