Check out this quick video tip about the autofill feature in Excel from the Affinity Insight live training session Excel Data Dive!
Microsoft Excel has a few features that I like to describe as pure magic; they save you time and improve accuracy without complex formulas. This month, we unleash the magic with autofill. (Text version below.)
Autofill automatically populates data across multiple cells, simply by dragging and dropping.
When it comes to numbers and dates, if Excel can recognize your pattern, it can autofill. For simple patterns, start by typing the first number or date in the appropriate cell. Then drag and drop the autofill handle (found in the bottom right-hand corner of every cell) across the cells to be filled.
For more complex number or date patterns, type the first two numbers or dates in the appropriate cells. Then, select both cells and drag and drop the autofill handle across the cells to be filled.
If you need more than numbers and dates, you can create a custom list. Start by typing each item in its own cell, either across a row or down a column. Select the cells. Open the file menu, click on Options. Under the Advanced Options, in the General group, click on the Edit Custom Lists button. In the Custom Lists dialog, click on the Import button, OK, and OK again.
Now you can enter an item from your list and autofill the rest. It’s magic!
If you are interested in more training videos, or if you're ready to create a culture of training in your organization, discover all that Affinity Insight has to offer.
Affinity Insight is a subscription membership program with 3 levels of membership available – Standard, Plus and Premium. The plans are based upon the level of service - not on the number of users in a firm. Yes, you read that right. As part of our introductory offer, the price is the same if you have 3 users, 30 users, or 300 users.
Find out all the details by going to https://www.affinityconsulting.com/insight/. Or, if you have any questions about the Excel autofill tip or Affinity Insight, contact us at 877-676-5492, or request a consultation. Our team of experts are ready to help!