![]() ![]() ![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |