Instead, you can double-click when you see the cross, then you can copy it to the bottom in a flash. ![]() However, if there are many rows, it takes a lot of time. ![]() Hover your cursor over it, then the cursor turns into a black cross.Īs you drag it down, the first formula will be copied. If you select a cell, the lower right corner of the cell becomes a small square. When you change or type the formula in the top cell, you would like to apply that downwards. If I had to type all of these manually, I would stop using Excel. Let’s start with the first one, Autofill.įor example, in this worksheet, there is a purchase date column in Column A and formulas are contained in all the cells in Column D. These two features are essential when you do data analyses with Excel. ![]() Today’s agenda is the AutoFill function and how to refer to other cells. Hi, this is Mike Negami, Lean Sigma Black Belt. The ‘Double-Click’ Method of Excel Autofill Function
0 Comments
Leave a Reply. |