Unit 17: Filling Data

Excel can help you enter series of numbers, dates or times. For instance, if you want to fill a column with a list of consecutive or patterned dates or numbers, instead of typing dates or numbers in each cell of the column you can use the “Series” command or you can click and drag the “fill handle” on a cell. Both of these methods are described below. You can use a pre-determined series using the series command that you can customize (for instance, date fills can be weekly instead of daily), or you can enter several logical pieces of the series by hand and when selecting cells, include your custom series. Excel will fill the cells with a series based on the cells in the original series selection.

Using the Series command

Select the cell that contains the first date or number. Use your mouse to drag the selection box down the number of rows that you wish to fill. Go to the Edit menu, and select Fill, then Series. The Series window will appear. For this example, chose “Date” on the Type list and “Day” on the Date Unit list. Click on OK and the selected cells will be filled with consecutive dates.

Using the Fill Handle

When you select a cell, a small black square appears in one corner of the selection. When you point to the fill handle, the pointer changes to a black cross. Left click with the black cross and hold it down while you drag the selection box over the cells that you want to fill. When you release the mouse button, the boxes will fill automatically.

Formatting

Once you have created your worksheet, you will want to format it to make it as clear as possible. Formatting is the structure and layout of a worksheet and its individual parts. Using some of the tools available, you can change the alignment, font size and weight, the way numbers display, even add borders and shading to your finished product.

UNIT 17 – Filling Data


There aren't any posts currently published in this category.