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.

Microsoft Office Excel completes text entries that you start to type in a column of data — if the first few letters that you type match an existing entry in that column. If you want to stop automatic …

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 …

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. See Also Fill data automatically in worksheet cells

Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. However, you can easily add sequential numbers to rows of data by dragging …

Have Excel automatically fill your data when it detects a pattern. For example, the months of the year, the days in a month, or a sequence of numbers. You can also parse data, like splitting …

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 …

Use Excel on your mobile device to duplicate data or fill a series of data across columns or rows.

To change how you want to fill the selection, click the small Auto Fill Options icon that appears after you finish dragging, and choose the option that want. For more information about copying …

Excel automatically completes only those entries that contain text or a combination of text and numbers. Entries that contain only numbers, dates, or times are not completed.