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.

Let's say column A contains first names, column B has last names, and you want to fill column C with first and last names combined. If you establish a pattern by typing the full name in column …

Tap to select the cell that contains the data you want to fill into other cells, and then tap the cell a second time to open the Edit menu. Tap Fill, and then tap and drag the fill arrows down or to …

Select the cell that has the formula you want to fill into adjacent cells. Drag the fill handle down or to the right of the column you want to fill. Keyboard shortcut: You can also press Ctrl+D to fill …

You can quickly fill cells with a series of dates, times, weekdays, months, or years. For example, you can enter Monday in a cell, and then fill the cells below or to the right with Tuesday, …

You can quickly copy formulas into adjacent cells by using the fill handle. When you drag the handle to other cells, Excel will show different results for each cell.

In Excel for the web, you can project values in a series by using worksheet functions, or you can click and drag the fill handle to create a linear trend of numbers.

You can highlight data in cells by using Fill Color to add or change the background color or pattern of cells. Here's how: Select the cells you want to highlight. Tip: To use a different background …

Flash Fill works with any data you need to split into more than one column, or you can simply use it to fill out data based on an example. Flash Fill typically starts working when it recognizes a …

You can extend a series of values that fit either a simple linear trend or an exponential growth trend by using the fill handle. Use the following procedures to learn how to display and predict …