Smart excel fast intelligent filling

php editor Youzi today introduces to you a powerful tool - smart Excel, which can help users quickly and intelligently fill data in Excel and improve work efficiency. No need for tedious manual operations, Smart Excel can intelligently identify data patterns and quickly fill in similar data, making your work easier and more efficient. Through this article, we will introduce you to the functions and usage of smart Excel in detail, allowing you to easily control Excel and improve work efficiency.

1. First, we open an EXCEL table file, as shown in the figure.

#2. Then, we enter the first number in the cell where the number needs to be extracted, as shown in the figure.

#3. Then select all the cells that need to be extracted, as shown in the figure.

#4. At this time, we hold down the CTRL E key on the keyboard, as shown in the figure.

#5. In this way, all cells will be filled, as shown in the figure.

6. Another way is that we enter the first two numbers in the first two cells, as shown in the figure, as shown in the figure.

7. Then pull down directly, so the filled number is wrong. We click on the small arrow of the bottom icon, click on the bottom quick fill, and that’s it. The details are as shown in the figure.

The above is the specific operation method of fast smart filling in smart excel. Do you remember it? If you find that you don’t remember it at all after reading it for the first time, it doesn’t matter. The most important thing is to try it a few more times. There are two methods introduced above, one is shortcut keys, and the other is operated with the mouse. The type of operation with the mouse is prone to small mistakes, so everyone should pay attention when operating.

The above is the detailed content of Smart excel fast intelligent filling. For more information, please follow other related articles on the PHP Chinese website!