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.

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.

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 …

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?

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 can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.

This guide will walk you through the process of setting up an automated workflow between Microsoft Forms and Excel using Power Automate. The workflow could automatically add the …

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 …

You can insert the current date and time in an Excel cell as static values or as dynamic values. A static value is one that doesn’t change when the worksheet is recalculated or opened. A …

If you don't want the entries that you type to be matched automatically to other entries, you can turn this option off. On the Excel menu, click Preferences. Under Formulas and Lists, click …