In Excel cell function and references are helpful to better understand Excel spreadsheets. Use Excel cell reference functions as well.
There may be times when you need to copy the content of one cell to several other cells in your worksheet. You could copy and paste the content into each cell, but this method would be time consuming. Instead, you can use the fill handle to quickly copy and paste content to adjacent cells in the same row or column.
The fill handle can also be used to continue a series. Whenever the content of a row or column follows a sequential order, like numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday), the fill handle can guess what should come next in the series. In many cases, you may need to select multiple cells before using the fill handle to help Excel determine the series order. In our example below, the fill handle is used to extend a series of dates in a column.
You can also double-click the fill handle instead of clicking and dragging. This can be useful with larger spreadsheets, where clicking and dragging may be awkward.
Watch the video below to see an example of double-clicking the fill handle.
A new feature in Excel 2013, Flash Fill can enter data automatically into your worksheet, saving you time and effort. Just like the fill handle, Flash Fill can guess what type of information you're entering into your worksheet. In the example below, we'll use Flash Fill to create a list of first names using a list of existing email addresses.
To modify or undo Flash Fill, click the Flash Fill button next to recently added Flash Fill data.