Entering the Same Data into Several Cells at Once

1-Select the cells where you want to enter data. The cells can be adjacent or onadjacent.

2- Type the data and press CTRL + ENTER.

►Automatic Fill  By dragging the fill handle of a cell, you can copy that cell to other cells in the same row or column. If the cell contains a number, date, or time period that icrosoft Excel can extend in a series,

 

the values are incremented instead of copied. For example, if the cell contains "January," you can quickly fill in other cells in a row or column with February," "March," and so on. You can create a custom fill series for frequently used text entries, such as your organization’s fields of operation.

● Do as follows to fill in a series of numbers, dates, or other items:

1- Select the first cell in the range you want to fill, and enter the starting value for the series (enter 21 for example). To increment the series by a specified amount, select the next cell in the range and enter the next item in the series (enter 24 for example). The difference between the two starting items (3 in this case) determines the amount by which the series is incremented.                                                  

2- Select the cell or cells that contain the starting values.

3- Drag the fill handle over the range you want to fill. Tofill in increasing order, drag

down or to the right. To fill in decreasing order, drag up or to the left.

                               

    ►Automatic Fill Options

In some cases, you can specify the type of the series you are extending:

1-  Select the cell or cells that contain the starting values 

2- Drag the fill handle over the range you want to fill. 

3- Release the mouse button, an Auto Fill Options icon will appear to choose options for how to fill the selection.

4- Click the appropriate command from the shortcut menu. For example, if the starting value is the date Jan-04, click Fill Months for the series Feb-04, Mar-04, and so on; or click Fill Years for the series Jan-04, Jan-05, and so on.

 

►Types of Fill series

You can automatically fill in several types of series by selecting cells and dragging the fill handle or by using the Series command (point to Fill on the Edit menu, and then click Series).

To select the type of series from a shortcut menu, select the starting values for the series; then hold down the right mouse button as you drag the fill handle.

 

►Time Series

A time series can include increments of days, weeks, or months that you specify, or it can include repeating sequences such as weekdays, month names, or quarters. For example, the initial time selections in the following table result in the series shown.

►Auto Fill

The AutoFill feature extends several types of series as shown in the following table. The Fourth example shows how Microsoft Excel can extend part of a selection Product 1 and copy another part On backorder. Note that items separated by commas are in adjacent cells.

►Linear Series

When you create a linear series by dragging the fill handle, Microsoft Excel increases or decreases values by a constant value that is based on the selected starting values.

Initial selection                            Extended series

1,2                                                        3,4,5

1,3                                                        5,7,9

100,95                                                  90,85

   

►Growth Series

When you create a growth series by selecting the Growth Trend command from the shortcut menu, Microsoft Excel multiplies values by a constant factor. 

  Initial selection                            Extended growth series        

       1,2                                                  4,8,16

       1,3                                                  9.,27,81

       2,3                                                  4.5 , 6.75 , 10.125  

  

    

Creating, Changing and Deleting a Custom Fill Series

 

►Creating Custom Fill Series

You can create a custom fill series for frequently used text entries, such as your organization’s fields of operation. You can create a custom fill series from existing items that you've listed on a worksheet, or you can type the list from scratch.

Do the following to create a custom fill series:

1- Enter the list of items you want to use as a series (use the example below and type Excel Microsoft office ).

2- Select the list on the worksheet.

3- On the Tools menu, click Options, and then click the Custom Lists tab.

4- Click Add, and then click Import.

  

To use the custom list series, type the first entry of the list, then extend your selection using the fill handle (refer to earlier sections).

 

►Changing and Deleting Custom Fill Series

1- On the Tools menu, click Options, and then click the Custom Lists tab.

2- In the Custom lists box, select the list you want.

3- To edit the list, make the changes you want in the List entries box, and then click Add.

To delete the list, click Delete.

 Note that you cannot edit or delete the built-in lists for months and days.