excel学习库

1、快速填充空白单元格

快速填充空白单元格，下面的数据表中存在多个空白的单元格，需要填充为0。

使用Ctrl+G快捷键点击定位条件，点击空值定位出空白单元格。

在定位出的第一个单元格中使用公式=0，按下快捷键Ctrl+Enter键即可批量填充。

1. Quickly fill blank cells

Quickly fill blank cells, there are multiple blank cells in the data table below, need to fill with 0.

Use the Ctrl+G shortcut to click the target, and click the null value to locate a blank cell.

Use formula=0 in the first cell you oriented, and press the shortcut Ctrl+Enter keys to fill in bulk.

2、批量删除空白行

首先使用Ctrl+G快捷键定位空白单元格位置，右键第一个空白的单元格，点击下方单元格上移，即可将空白行删除。

2. Delete blank rows in batches

First, use the Ctrl+G shortcut keys to locate the blank cell position, right-click the first blank cell, click the lower cell to move up, you can delete the blank row.

3、使用通配符进行查找替换

在查找与替换中使用*号通配符，比如"*花"代表花字前面有很多的字符，可以进行模糊查找，点击查找全部即可看到这里查找到匹配的单元格内容。

3. Use wildcards to find and replace

Use * wildcards in search and replacement, such as "* flower" means that there are many characters in front of the flower word, you can perform fuzzy search, click Find All to see the matching cell content found here.

4、数据分列文本为日期型数据

将文本型日期转化为日期型数据，在数据选项卡下点击分列功能。

在文本分列向导里默认下一步，在第三步向导勾选日期。

4. The data column text is date data

To convert text-based dates to date-based data, click Columns under the Data tab.

In the Text Column Wizard, the next step is defaulted, and in the third step of the wizard, the date is checked.