Create a Custom Fill : Cell Fill « Editing « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Editing
3. Cell Fill

Select the list of items.

Click the Office button. 
           Click Excel Options.

Click Popular. Click Edit Custom Lists.

Click NEW LIST, type the entries you want, 
           press Enter after each. Click Add.

Or verify the cell reference of the selected list appears in the Import list, 
           and then click Import.

2.9.Cell Fill
	2.9.1.	Choose how to fill the selection
	2.9.2.	Fill with Contents of Adjacent Cells
	2.9.3.	Create a Custom Fill