Fill data automatically in worksheet cells - Microsoft Support
Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.
Turn automatic completion of cell entries on or off
Click Advanced, and then under Editing options, select or clear the Enable AutoComplete for cell values check box to turn this option on or off. Need more help?
Use AutoComplete when entering formulas - Microsoft Support
AutoComplete helps you quickly insert functions and arguments while minimizing typing and syntax errors. The AutoComplete menu shows you available options based on context, and you choose …
Use Formula AutoComplete - Microsoft Support
You can use Formula AutoComplete in the middle of an existing nested function or formula. The text immediately before the insertion point is used to display values in the drop-down list, and all of the …
Using Flash Fill in Excel - Microsoft Support
Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two …
Excel help & learning - support.microsoft.com
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
What is Excel? - Microsoft Support
What is Excel? Excel makes it easy to crunch numbers. With Excel, you can streamline data entry with AutoFill. Then, get chart recommendations based on your data, and create them with one click. Or …
Enter a series of numbers, dates, or other items
Excel can continue a series of numbers, text-and-number combinations, or formulas based on a pattern that you establish. For example, you can enter Item1 in a cell, and then fill the cells below or to the …
Fill a formula down into adjacent cells - Microsoft Support
Use Fill Down to copy a formula into adjacent cells of the same column, or press Ctrl+D or Ctrl+R to fill formulas in a column or row.
Create or delete a custom list for sorting and filling data
Use a custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list.