Like and see, form a habit; One takes on the color of one’s company.
Wechat search [Yixin Excel] to pay attention to this different we-media person.
In this paper, making github.com/hugogoos/Ex… Has been included, including Excel system learning guide series of articles, as well as a variety of Excel materials.
When it comes to batch filling formula, what method do you first think of? Xiaobian first thought of the mouse drag filling handle, of course, this is the first way to learn the most impressive. Today xiaobian will share with you several more efficient batch filling formula method, there is always a suitable for you.
1. Drag the filling handle with the mouse
Mouse drag fill handle I think we should often use it, here is also a simple introduction, not friends can learn, have friends can skip.
Pictured above, this is a list of goods, we want to calculate each item total amount, so we entered in E5 cell formula “= C5 * D5”, then to calculate the total amount of other goods below fast, you can put the mouse to select E5 cell, the mouse moved to the lower right corner, E5 cell when the mouse into a black cross (pictured above), This black cross is also called the fill handle. Hold down the left mouse button and drag the fill handle down to make the formula fill the E6:E9 area quickly.
2. Double-click the filling handle
Double-clicking the filling handle can be said to be an upgraded version of mouse dragging and dropping the filling handle. Other steps are the same as that of mouse dragging and dropping the filling handle. The difference is that at the end, when the mouse moves to the lower right corner of the cell and the filling handle appears, double-clicking the filling handle directly fills the E6:E9 cell area quickly.
Here’s how it works:
3, CTRL + D
CTRL+D, which means “fill down,” copies the contents and format of the topmost cell in the selected range into the cell below.
Again in the above example, select the E5 cell from which the formula has been entered to the E5:E9 cell area. Then press the shortcut key “CTRL+D” to quickly fill the formula in the E5 cell into the E6:E9 cell area.
Here is a concrete demonstration:
4, CTRL + R
CTRL+R, which means “Fill right,” copies the content and format of the left-most cell in the selected range to the cell on the right. In principle, the operation is similar to CTRL+D.
As shown in the figure above, if we want to calculate the SUM of each column, enter the formula “=SUM(C5:C8)” in cell C9. If you want to quickly fill the formula into cell D9:E9, select cell C9:E9 and press the shortcut key “CTRL+R”.
Here’s a demonstration:
5, CTRL + ENTER
CTRL+ENTER populates the selected range of cells with the current entry.
This may not be easy to understand, but let’s use examples to explain it in detail.
As shown in the figure above, we want to add the formula “= quantity * price” to the total column in batches. First, select the E5:E9 cell area from the top down. At this time, notice that the red box of E5 should be blank, and then enter the formula “=C5*D5”, which is also displayed in the E5 cell. Then press CTRL+ENTER. Fill the selected cell region with the current entry. Fill the selected cell region with the current entry refers to the E5 cell and the formula in it. Fill the selected cell region refers to the E5:E9 cell region.
Note: The E5:E9 cell area cannot be selected from bottom up so that the formula is entered into the E9 cell, and since “CTRL+ENTER” is filled down, the E5:E8 cell area cannot be filled with the formula.
Take a look at the dynamic:
6, CTRL + C/V
You might be a little confused by this method, but this is a quick way to fill in formulas, right? Indeed, I believe that after reading the basic series of articles about pasting, you should know that the formula can be selected in selective pasting.
First, enter the formula “=C5*D5” in cell E5. Then select cell E5 and press the shortcut key “CTRL+C”. Then select cell E6:E9 and press the shortcut key “CTRL+V”.
You can see here that sometimes simple methods used skillfully in different situations can also bring you great surprises.
Let’s take a look at the demo:
Today’s sharing ends here, but the road of learning has just begun, I hope we can keep moving forward on the road of learning, perseverance.
If you are interested in the feature, you can tell xiaobian oh, xiaobian will write a corresponding article for you. Of course, it’s first come, first written. I will make a schedule and try to meet everyone’s needs. So if the next article is not what you want, please don’t worry, it may be the next one. Let me know what you want to learn.
This article continues to update, you can search wechat “yixin Excel” first time to read, this article GitHub github.com/hugogoos/Ex… Excel System Learning Guide series, welcome Star.